/*ApVer 1.4.2 (15) DBVer 3.0 Time 542225461*/
INSERT OR REPLACE INTO Ramps VALUES(2204,2,'2(Right)',0,0,1,0,303.000000,146,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,92626641,322290761,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(2204,4,'4(Right)',0,0,1,0,234.000000,215,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,92626438,322290768,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=542225461, status=0,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92626542,                     intY=322290912,                     ramp1=0,                     ramp2=-9895837,                     ramp3=0,                     ramp4=-9371752,                     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.934940,                     longitude=-117.889064,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=2204;
UPDATE Intersections_index SET minY=33.934940,minX=-117.889064,maxY=33.934940,maxX=-117.889064 WHERE Intersections_index.id=2204
Delete FROM ramps WHERE intID=2204 AND rampNum = 2
Delete FROM ramps WHERE intID=2204 AND rampNum = 4
INSERT OR REPLACE INTO Ramps VALUES(2204,9,'23 (Middle)',0,0,1,0,303.000000,146,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,92626641,322290761,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(2204,10,'45 (Middle)',0,0,1,0,234.000000,215,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,92626438,322290768,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=542225471, status=0,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92626542,                     intY=322290912,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-9895837,                     ramp23=-9371752,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.934940,                     longitude=-117.889064,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=2204;
UPDATE Intersections_index SET minY=33.934940,minX=-117.889064,maxY=33.934940,maxX=-117.889064 WHERE Intersections_index.id=2204
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(24904,2204,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111904,4,336,2204,9,7,43,33.934843,-117.889030,542225530);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(112004,4,337,2204,9,4,42,33.934850,-117.889007,542225545);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(112104,4,338,2204,9,2,243,33.934850,-117.889004,542225594);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(25004,2204,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(112204,4,339,2204,10,7,163,33.934880,-117.889139,542225787);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(112304,4,340,2204,10,7,115,33.934877,-117.889147,542225795);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(112404,4,341,2204,10,4,121,33.934876,-117.889165,542225805);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(112504,4,342,2204,10,2,55,33.934830,-117.889160,542225866);
INSERT OR REPLACE INTO Ramps VALUES(2204,9,'23 (Middle)',0,1520532797,1,1,323.687561,146,0,1,1,11,11,11,11,0,1,0,48,26,0.000000,0.000000,0.000000,-4.310663,3.728226,322.729187,6.315858,-3.907612,141.846939,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-5.984618,-0.684594,37.113388,-16.620991,-5.276511,240.391571,0,0,0,0,0.000000,0.000000,92626641,322290761,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.500000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
INSERT OR REPLACE INTO Ramps VALUES(2204,10,'45 (Middle)',0,1520533068,1,1,53.483295,215,0,1,1,11,11,11,11,0,1,1,48,50,0.000000,0.000000,0.000000,-1.595712,13.346747,50.403118,-5.488128,-11.953763,234.592438,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,5.665068,0.439293,128.098145,-18.107510,-5.032725,334.684479,0,0,0,0,0.000000,0.000000,92626438,322290768,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.500000,0.100000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
UPDATE Intersections SET lastUpdateTime=542225879, status=3,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92626542,                     intY=322290912,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-9895837,                     ramp23=-9371752,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.934940,                     longitude=-117.889064,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=2204;
UPDATE Intersections_index SET minY=33.934940,minX=-117.889064,maxY=33.934940,maxX=-117.889064 WHERE Intersections_index.id=2204