/*ApVer 1.4.2 (15) DBVer 3.0 Time 542309316*/
INSERT OR REPLACE INTO Ramps VALUES(1804,10,'45 (Middle)',0,0,1,0,219.000000,230,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,92599763,322244917,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(1804,11,'67 (Middle)',0,0,1,0,136.000000,313,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,92599746,322245182,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=542309316, status=0,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92599904,                     intY=322245033,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=-7536781,                     ramp45=9830242,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.909412,                     longitude=-117.906926,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=1804;
UPDATE Intersections_index SET minY=33.909412,minX=-117.906926,maxY=33.909412,maxX=-117.906926 WHERE Intersections_index.id=1804
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(28804,1804,67,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(132904,4,546,1804,11,7,10,33.909489,-117.907060,542309433);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133004,4,547,1804,11,7,93,33.909476,-117.907066,542309451);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133104,4,548,1804,11,4,277,33.909478,-117.907030,542309463);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133204,4,549,1804,11,6,317,33.909508,-117.907040,542309495);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133304,4,550,1804,11,2,37,33.909499,-117.907051,542309510);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(28904,1804,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133404,4,551,1804,10,7,105,33.909385,-117.907060,542309790);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133504,4,552,1804,10,7,3,33.909378,-117.907069,542309810);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133604,4,553,1804,10,7,57,33.909404,-117.907065,542309822);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133704,4,554,1804,10,4,179,33.909404,-117.907065,542309832);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133804,4,555,1804,10,6,330,33.909397,-117.907067,542309862);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(133904,4,556,1804,10,2,134,33.909410,-117.907079,542309875);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134004,4,557,1804,10,2,134,33.909410,-117.907079,542309879);
INSERT OR REPLACE INTO Ramps VALUES(1804,10,'45 (Middle)',0,1520617080,1,1,34.571377,230,0,1,1,12,11,11,11,1,1,1,48,45,-6.056834,1.045133,36.089104,-2.414096,2.212625,43.524197,-10.602973,-2.017081,215.663498,-5.096822,5.610438,102.486801,-10.572325,-3.866181,320.911865,-4.835733,-0.118796,112.311829,-14.107612,-1.893810,332.276886,0,0,0,0,0.000000,0.500000,92599763,322244917,10,'',0,0,0,0,0,0.000000,0.000000,0.500000,0.500000,0.500000,0.000000,0.200000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(1804,11,'67 (Middle)',0,1520616712,1,1,157.229355,313,0,1,1,12,11,11,11,0,0,1,52,41,-5.837022,-1.454298,151.290558,-0.184164,-0.856953,155.471924,-2.297032,-0.355296,338.121613,-7.248338,4.032665,228.512009,-7.677543,-6.011461,81.043747,-5.746428,0.443291,203.115692,-4.732797,-1.203268,89.759407,0,0,0,0,0.000000,0.500000,92599746,322245182,10,'',0,0,0,0,0,0.000000,0.000000,0.400000,0.000000,1.300000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
UPDATE Intersections SET lastUpdateTime=542309884, status=3,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92599904,                     intY=322245033,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=-7536781,                     ramp45=9830242,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.909412,                     longitude=-117.906926,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=1804;
UPDATE Intersections_index SET minY=33.909412,minX=-117.906926,maxY=33.909412,maxX=-117.906926 WHERE Intersections_index.id=1804
DELETE FROM Intersections WHERE intID = 122;DELETE FROM Intersections_index WHERE id = 122
DELETE FROM Intersections WHERE intID = 1448;DELETE FROM Intersections_index WHERE id = 1448
DELETE FROM Intersections WHERE intID = 1516;DELETE FROM Intersections_index WHERE id = 1516
DELETE FROM Intersections WHERE intID = 1517;DELETE FROM Intersections_index WHERE id = 1517
DELETE FROM Intersections WHERE intID = 1053;DELETE FROM Intersections_index WHERE id = 1053
DELETE FROM Intersections WHERE intID = 1493;DELETE FROM Intersections_index WHERE id = 1493
DELETE FROM Intersections WHERE intID = 1459;DELETE FROM Intersections_index WHERE id = 1459
DELETE FROM Intersections WHERE intID = 558;DELETE FROM Intersections_index WHERE id = 558