/*ApVer 1.4.2 (15) DBVer 3.0 Time 543182640*/
INSERT OR REPLACE INTO Ramps VALUES(376,9,'23 (Middle)',0,0,1,0,301.000000,148,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,92602170,322240369,11,'',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(376,10,'45 (Middle)',0,0,1,0,257.000000,192,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,92602269,322240602,11,'',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(376,11,'67 (Middle)',0,0,1,0,128.000000,321,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,92601852,322240813,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(376,12,'81 (Middle)',0,0,1,0,8.000000,81,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,92601771,322240557,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=543182640, status=0,                     assignedToPrelim=0,                     assignedToDetail=2,                     intX=92602045,                     intY=322240572,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-13303683,                     ramp23=1966304,                     ramp45=15859519,                     ramp67=-917778,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.906929,                     longitude=-117.905490,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=376;
UPDATE Intersections_index SET minY=33.906929,minX=-117.905490,maxY=33.906929,maxX=-117.905490 WHERE Intersections_index.id=376
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319102,2,138,376,3,7,151,33.906936,-117.905368,543182838);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319202,2,139,376,3,2,169,33.906952,-117.905347,543182940);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319302,2,140,376,3,2,169,33.906952,-117.905347,543182966);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319402,2,141,376,2,7,304,33.906841,-117.905398,543183103);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319502,2,142,376,2,2,330,33.906795,-117.905426,543183188);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319602,2,143,376,2,2,330,33.906795,-117.905426,543183199);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(56002,376,67,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319702,2,144,376,11,7,33,33.906929,-117.905727,543183501);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319802,2,145,376,11,2,268,33.906940,-117.905741,543183551);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(319902,2,146,376,11,2,268,33.906940,-117.905741,543183562);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(56002,376,67,0,2,'|Yellow truncated domes are black not yellow. ');
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(56102,376,81,0,2,'Yellow truncated domes are black not yellow. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(320002,2,147,376,12,2,102,33.907082,-117.905641,543183873);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(320102,2,148,376,12,2,102,33.907082,-117.905641,543183884);
INSERT OR REPLACE INTO Ramps VALUES(376,2,'2(Right)',0,1521490403,1,1,355.000000,148,0,1,1,11,11,11,11,0,0,1,48,50,0.124155,2.584664,20.410931,2.105341,1.260910,23.069283,-0.703789,-5.271971,213.437851,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,92602170,322240369,11,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,1.000000,0.000000,0.000000,0.000000,0.000000,0.000000,48,25);
INSERT OR REPLACE INTO Ramps VALUES(376,5,'5(Left)',0,0,1,0,257.000000,192,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,92602269,322240602,11,'',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);
Delete FROM ramps WHERE intID=376 AND rampNum = 9
Delete FROM ramps WHERE intID=376 AND rampNum = 10
INSERT OR REPLACE INTO Ramps VALUES(376,11,'67 (Middle)',0,1521490816,1,1,151.589218,321,0,1,1,12,11,11,11,0,0,1,48,0,-7.258265,-0.800476,69.340492,-9998.000000,-9998.000000,-9998.000000,-2.477998,0.941912,250.107269,-11.962000,6.266806,146.258743,-9.329805,-5.115037,346.364410,-3.651078,0.057041,136.833786,-1.585003,-1.703212,22.777607,0,0,0,0,0.000000,0.000000,92601852,322240813,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.500000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(376,12,'81 (Middle)',0,1521491086,1,1,187.659195,81,0,1,1,11,11,11,11,0,0,0,48,36,-5.612023,-2.490957,162.181427,-0.414975,-0.603267,150.991074,0.505856,0.714735,341.618378,-9.596821,3.886068,237.604095,-8.279465,-2.710508,81.557419,-3.154354,2.237636,204.644775,-0.312095,-3.659153,90.182190,0,0,0,0,0.000000,0.000000,92601770,322240557,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,48,35);
UPDATE Intersections SET lastUpdateTime=543183890, status=3,                     assignedToPrelim=0,                     assignedToDetail=2,                     intX=92602045,                     intY=322240572,                     ramp1=0,                     ramp2=-13303683,                     ramp3=0,                     ramp4=0,                     ramp5=1966304,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=0,                     ramp45=15859519,                     ramp67=-917779,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.906929,                     longitude=-117.905490,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=376;
UPDATE Intersections_index SET minY=33.906929,minX=-117.905490,maxY=33.906929,maxX=-117.905490 WHERE Intersections_index.id=376