/*ApVer 1.4.2 (15) DBVer 3.0 Time 542312077*/
INSERT OR REPLACE INTO Ramps VALUES(80,10,'45 (Middle)',0,0,1,0,196.000000,253,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,92607915,322265655,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=542312077, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92608115,                     intY=322265714,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=-3801288,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920920,                     longitude=-117.901420,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=80;
UPDATE Intersections_index SET minY=33.920920,minX=-117.901420,maxY=33.920920,maxX=-117.901420 WHERE Intersections_index.id=80
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29404,80,45,0,2,'Curb Ramp missing left flare. ');
INSERT OR REPLACE INTO CURBRAMP_STANDARD_TEXT VALUES(6,2,'Curb Ramp missing left flare. ');
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29404,80,45,0,2,'Curb Ramp missing left flare. |Yellow truncated domes are black not yellow. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136204,4,579,80,10,4,320,33.920891,-117.901540,542312232);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136304,4,580,80,10,7,234,33.920895,-117.901554,542312241);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136404,4,581,80,10,7,206,33.920892,-117.901507,542312265);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136504,4,582,80,10,5,307,33.920907,-117.901539,542312279);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136604,4,583,80,10,6,175,33.920930,-117.901546,542312301);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136704,4,584,80,10,2,206,33.920924,-117.901549,542312319);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29404,80,45,0,2,'Curb Ramp missing left flare. |Yellow truncated domes are black not yellow. |Curb Ramp is missing upper landing. ');
INSERT OR REPLACE INTO Ramps VALUES(80,10,'45 (Middle)',0,1520619522,1,1,26.081966,253,0,1,1,12,1,0,0,0,0,1,48,0,-6.114633,-2.591976,358.359528,-9998.000000,-9998.000000,-9998.000000,-3.247263,-2.563529,171.209106,-9998.000000,-9998.000000,-9998.000000,-2.122030,-2.985952,295.188477,-9998.000000,-9998.000000,-9998.000000,-1.873608,-3.736213,309.058746,0,0,0,0,0.000000,0.500000,92607915,322265655,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.500000,0.000000,0.400000,0.000000,0.000000,0.000000,0,0);
UPDATE Intersections SET lastUpdateTime=542312365, status=3,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92608115,                     intY=322265714,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=-3801288,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920920,                     longitude=-117.901420,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=80;
UPDATE Intersections_index SET minY=33.920920,minX=-117.901420,maxY=33.920920,maxX=-117.901420 WHERE Intersections_index.id=80
DELETE FROM Intersections WHERE intID = 1473;DELETE FROM Intersections_index WHERE id = 1473
DELETE FROM Intersections WHERE intID = 1447;DELETE FROM Intersections_index WHERE id = 1447
DELETE FROM Intersections WHERE intID = 1483;DELETE FROM Intersections_index WHERE id = 1483
DELETE FROM Intersections WHERE intID = 1484;DELETE FROM Intersections_index WHERE id = 1484
DELETE FROM Intersections WHERE intID = 382;DELETE FROM Intersections_index WHERE id = 382
DELETE FROM Intersections WHERE intID = 1509;DELETE FROM Intersections_index WHERE id = 1509
DELETE FROM Intersections WHERE intID = 78;DELETE FROM Intersections_index WHERE id = 78
DELETE FROM Intersections WHERE intID = 568;DELETE FROM Intersections_index WHERE id = 568
DELETE FROM Intersections WHERE intID = 520;DELETE FROM Intersections_index WHERE id = 520
DELETE FROM Intersections WHERE intID = 1442;DELETE FROM Intersections_index WHERE id = 1442
DELETE FROM Intersections WHERE intID = 79;DELETE FROM Intersections_index WHERE id = 79
DELETE FROM Intersections WHERE intID = 1058;DELETE FROM Intersections_index WHERE id = 1058
DELETE FROM Intersections WHERE intID = 569;DELETE FROM Intersections_index WHERE id = 569
DELETE FROM Intersections WHERE intID = 1030;DELETE FROM Intersections_index WHERE id = 1030