/*ApVer 1.4.2 (15) DBVer 3.0 Time 542660362*/
INSERT OR REPLACE INTO Ramps VALUES(531,2,'2(Right)',0,0,1,0,310.000000,139,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,92636114,322270991,6,'',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(531,8,'8(Right)',0,0,1,0,35.000000,54,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,92636185,322271307,6,'',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=542660362, status=0,                     assignedToPrelim=0,                     assignedToDetail=9,                     intX=92635976,                     intY=322271157,                     ramp1=0,                     ramp2=-10878838,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=9830609,                     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.923948,                     longitude=-117.882738,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=531;
UPDATE Intersections_index SET minY=33.923948,minX=-117.882738,maxY=33.923948,maxX=-117.882738 WHERE Intersections_index.id=531
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(154809,9,71,531,9,2,178,33.923836,-117.882586,542660731);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(154909,9,72,531,9,2,178,33.923836,-117.882586,542660743);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(32809,531,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(155009,9,73,531,12,2,116,33.924015,-117.882578,542661230);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(155109,9,74,531,12,2,116,33.924015,-117.882578,542661245);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(32909,531,81,0,2,'Detectable yellow truncated domes not provided. ');
Delete FROM ramps WHERE intID=531 AND rampNum = 2
Delete FROM ramps WHERE intID=531 AND rampNum = 8
INSERT OR REPLACE INTO Ramps VALUES(531,9,'23 (Middle)',0,1520967997,1,1,323.039581,139,0,1,1,11,11,11,11,0,0,0,48,57,0.000000,0.000000,0.000000,-1.772656,9.675021,326.703278,-4.063569,-10.146379,144.577545,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,5.510747,0.191393,52.445797,-15.649044,-1.381703,244.890259,0,0,0,0,0.000000,0.000000,92636114,322270991,6,'',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,36,0);
INSERT OR REPLACE INTO Ramps VALUES(531,12,'81 (Middle)',0,1520968449,1,1,226.380386,54,0,1,1,11,11,11,11,0,0,0,48,75,-7.618439,9.261551,228.604187,-4.371066,9.549393,230.778229,0.847644,-10.244427,48.141670,-3.637296,8.596392,305.111237,-11.656136,-8.160666,150.380096,3.081697,8.585449,314.504395,-7.103136,0.568786,174.827118,0,0,0,0,0.000000,0.000000,92636185,322271307,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,46,36);
UPDATE Intersections SET lastUpdateTime=542661266, status=3,                     assignedToPrelim=0,                     assignedToDetail=9,                     intX=92635976,                     intY=322271157,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-10878838,                     ramp23=0,                     ramp45=0,                     ramp67=9830609,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.923948,                     longitude=-117.882738,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=531;
UPDATE Intersections_index SET minY=33.923948,minX=-117.882738,maxY=33.923948,maxX=-117.882738 WHERE Intersections_index.id=531
DELETE FROM Intersections WHERE intID = 529;DELETE FROM Intersections_index WHERE id = 529
DELETE FROM Intersections WHERE intID = 1225;DELETE FROM Intersections_index WHERE id = 1225