/*ApVer 1.4.3 (16) DBVer 3.0 Time 542752239*/
Delete FROM ramps WHERE intID=4009 AND rampNum = 9
Delete FROM ramps WHERE intID=4009 AND rampNum = 11
UPDATE Intersections SET lastUpdateTime=542752239, status=2,assignedToPrelim=9,assignedToDetail=0,intX=92606298,intY=322291158,ramp1=0,ramp2=0,ramp3=0,ramp4=0,ramp5=0,ramp6=0,ramp7=0,ramp8=0,ramp81=0,ramp23=0,ramp45=0,ramp67=0,xWalkA=0,xWalkB=0,xWalkC=0,xWalkD=0,signal81=0,signal23=0,signal45=0,signal67=0,latitude=33.935076,longitude=-117.902638,zoomLevel=21,doLater=0,intersectionComment='' WHERE intID=4009;
UPDATE Intersections_index SET minY=33.935076,minX=-117.902638,maxY=33.935076,maxX=-117.902638 WHERE Intersections_index.id=4009
INSERT OR REPLACE INTO Ramps VALUES(4009,9,'23 (Middle)',0,0,1,0,335.000000,114,0,1,1,0,0,0,0,0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0,0,0,0.000000,0.000000,92606408,322291107,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(4009,11,'67 (Middle)',0,0,1,0,92.000000,357,0,1,1,0,0,0,0,0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0,0,0,0.000000,0.000000,92606288,322291351,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
UPDATE Intersections SET lastUpdateTime=542752293, status=2,assignedToPrelim=9,assignedToDetail=0,intX=92606298,intY=322291158,ramp1=0,ramp2=0,ramp3=0,ramp4=0,ramp5=0,ramp6=0,ramp7=0,ramp8=0,ramp81=-3342226,ramp23=0,ramp45=12713974,ramp67=0,xWalkA=0,xWalkB=0,xWalkC=0,xWalkD=0,signal81=0,signal23=0,signal45=0,signal67=0,latitude=33.935076,longitude=-117.902638,zoomLevel=21,doLater=0,intersectionComment='' WHERE intID=4009;
UPDATE Intersections_index SET minY=33.935076,minX=-117.902638,maxY=33.935076,maxX=-117.902638 WHERE Intersections_index.id=4009
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(183709,9,198,4009,9,2,87,33.935120,-117.902590,542752603);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(183809,9,199,4009,9,2,87,33.935120,-117.902590,542752616);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(37909,4009,23,0,2,'Yellow truncated domes are black not yellow. |Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(183909,9,200,4009,11,7,354,33.935194,-117.902691,542752839);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(184009,9,201,4009,11,2,101,33.935229,-117.902677,542752922);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(184109,9,202,4009,11,2,101,33.935229,-117.902677,542752935);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(38009,4009,67,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO Ramps VALUES(4009,9,'23 (Middle)',0,1521059821,1,1,298.831696,114,0,1,1,12,11,11,11,0,0,0,48,38,-7.668293,2.587712,286.128937,-0.817609,3.588558,281.572052,-8.161428,-3.643009,106.294304,-3.965734,10.079926,4.538356,-8.614420,-2.425714,207.979218,6.112461,2.825446,345.502197,-5.665218,-2.435034,222.384232,0,0,0,0,0.000000,0.000000,92606408,322291107,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(4009,11,'67 (Middle)',0,1521060139,1,1,154.654739,357,0,1,1,12,11,11,11,0,0,1,48,48,-10.728903,1.682565,183.432617,-3.262415,-0.004066,168.425262,-7.555081,3.820215,352.930695,-8.629768,5.238810,249.853577,-12.473140,-5.063787,101.389000,-3.657183,5.016200,230.601959,-2.498690,-2.561730,107.218170,0,0,0,0,0.000000,0.000000,92606288,322291351,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,1.500000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
UPDATE Intersections SET lastUpdateTime=542752948, status=3,assignedToPrelim=9,assignedToDetail=0,intX=92606298,intY=322291158,ramp1=0,ramp2=0,ramp3=0,ramp4=0,ramp5=0,ramp6=0,ramp7=0,ramp8=0,ramp81=-3342226,ramp23=0,ramp45=12713974,ramp67=0,xWalkA=0,xWalkB=0,xWalkC=0,xWalkD=0,signal81=0,signal23=0,signal45=0,signal67=0,latitude=33.935076,longitude=-117.902638,zoomLevel=21,doLater=0,intersectionComment='' WHERE intID=4009;
UPDATE Intersections_index SET minY=33.935076,minX=-117.902638,maxY=33.935076,maxX=-117.902638 WHERE Intersections_index.id=4009