/*ApVer 1.4.2 (15) DBVer 3.0 Time 542224996*/
INSERT OR REPLACE INTO Ramps VALUES(2104,2,'2(Right)',0,0,1,0,281.000000,168,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,92627061,322290747,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(2104,4,'4(Right)',0,0,1,0,207.000000,242,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,92626843,322290766,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=542224996, status=0,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92627038,                     intY=322290867,                     ramp1=0,                     ramp2=-7864297,                     ramp3=0,                     ramp4=-6553795,                     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.934915,                     longitude=-117.888731,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=2104;
UPDATE Intersections_index SET minY=33.934915,minX=-117.888731,maxY=33.934915,maxX=-117.888731 WHERE Intersections_index.id=2104
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(24704,2104,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO Ramps VALUES(2104,2,'2(Right)',0,1520532218,1,1,359.000000,168,0,1,1,0,0,0,0,0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-2.643896,3.740973,316.906464,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,92627061,322290747,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(2104,4,'4(Right)',0,0,1,0,207.000000,242,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,92626843,322290766,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=542225023, status=0,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92627038,                     intY=322290867,                     ramp1=0,                     ramp2=-7864297,                     ramp3=0,                     ramp4=-6553795,                     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.934915,                     longitude=-117.888731,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=2104;
UPDATE Intersections_index SET minY=33.934915,minX=-117.888731,maxY=33.934915,maxX=-117.888731 WHERE Intersections_index.id=2104
Delete FROM ramps WHERE intID=2104 AND rampNum = 2
Delete FROM ramps WHERE intID=2104 AND rampNum = 4
INSERT OR REPLACE INTO Ramps VALUES(2104,9,'23 (Middle)',0,0,1,0,359.000000,168,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,92627061,322290747,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(2104,10,'45 (Middle)',0,0,1,0,207.000000,242,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,92626843,322290766,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=542225044, status=0,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92627038,                     intY=322290867,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-7864297,                     ramp23=-6553795,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.934915,                     longitude=-117.888731,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=2104;
UPDATE Intersections_index SET minY=33.934915,minX=-117.888731,maxY=33.934915,maxX=-117.888731 WHERE Intersections_index.id=2104
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110504,4,322,2104,9,7,206,33.934835,-117.888722,542225106);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110604,4,323,2104,9,7,159,33.934845,-117.888712,542225116);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110704,4,324,2104,9,7,159,33.934845,-117.888712,542225122);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110804,4,325,2104,9,7,159,33.934845,-117.888712,542225138);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110904,4,326,2104,9,4,216,33.934854,-117.888680,542225153);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111004,4,327,2104,9,4,216,33.934854,-117.888680,542225153);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111104,4,328,2104,9,2,172,33.934850,-117.888719,542225212);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111204,4,329,2104,10,7,315,33.934826,-117.888835,542225329);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111304,4,330,2104,10,7,296,33.934826,-117.888835,542225339);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111404,4,331,2104,10,7,296,33.934826,-117.888835,542225347);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111504,4,332,2104,10,7,296,33.934826,-117.888835,542225352);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111604,4,333,2104,10,7,296,33.934826,-117.888835,542225361);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111704,4,334,2104,10,4,115,33.934856,-117.888832,542225378);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(111804,4,335,2104,10,2,144,33.934858,-117.888840,542225424);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(24804,2104,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO Ramps VALUES(2104,9,'23 (Middle)',0,1520532416,1,1,310.564697,168,0,1,1,11,11,11,11,0,1,1,48,40,0.000000,0.000000,0.000000,-3.498105,3.357659,317.475677,9.289608,-5.962769,135.564590,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-9.796483,0.742788,34.259678,-16.306000,-2.291322,236.450638,0,0,0,0,0.000000,0.000000,92627061,322290747,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.500000,0.800000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
INSERT OR REPLACE INTO Ramps VALUES(2104,10,'45 (Middle)',0,1520532626,1,1,40.774876,242,0,1,1,11,11,11,11,0,1,1,48,23,0.000000,0.000000,0.000000,-2.810924,6.898076,41.615150,-5.288775,-12.465826,222.519012,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,6.143719,0.489611,125.196335,-20.894993,3.280090,322.492981,0,0,0,0,0.000000,0.000000,92626843,322290766,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.500000,3.600000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
UPDATE Intersections SET lastUpdateTime=542225431, status=3,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92627038,                     intY=322290867,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-7864297,                     ramp23=-6553795,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.934915,                     longitude=-117.888731,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=2104;
UPDATE Intersections_index SET minY=33.934915,minX=-117.888731,maxY=33.934915,maxX=-117.888731 WHERE Intersections_index.id=2104