/*ApVer 1.4.2 (15) DBVer 3.0 Time 542667460*/
INSERT OR REPLACE INTO Ramps VALUES(1335,9,'23 (Middle)',0,0,1,0,348.000000,101,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,92627809,322285614,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(1335,10,'45 (Middle)',0,0,1,0,249.000000,200,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,92627587,322285429,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=542667460, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92627666,                     intY=322285645,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-2031473,                     ramp23=-14090319,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.932009,                     longitude=-117.888310,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=1335;
UPDATE Intersections_index SET minY=33.932009,minX=-117.888310,maxY=33.932009,maxX=-117.888310 WHERE Intersections_index.id=1335
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(33408,1335,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(165908,8,222,1335,9,4,110,33.932025,-117.888198,542667573);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166008,8,223,1335,9,4,110,33.932025,-117.888198,542667576);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166108,8,224,1335,9,6,272,33.932010,-117.888204,542667639);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166208,8,225,1335,9,2,259,33.931989,-117.888212,542667660);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166308,8,226,1335,9,2,259,33.931989,-117.888212,542667668);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(33508,1335,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166408,8,227,1335,10,4,258,33.931916,-117.888320,542667816);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166508,8,228,1335,10,4,258,33.931916,-117.888320,542667821);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166608,8,229,1335,10,6,5,33.931919,-117.888333,542667885);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166708,8,230,1335,10,2,337,33.931909,-117.888377,542667904);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(166808,8,231,1335,10,2,337,33.931909,-117.888377,542667913);
INSERT OR REPLACE INTO Ramps VALUES(1335,9,'23 (Middle)',0,1520974872,1,1,290.215393,101,0,1,1,1,11,11,11,0,0,0,48,43,-9.178727,7.018313,282.399414,-5.357682,10.612853,280.347839,1.796359,-7.229462,104.405685,3.954290,7.288399,5.281857,-16.273678,-6.193168,198.736603,8.576400,0.641939,5.793591,-11.427974,-2.344010,208.310760,0,0,0,0,0.000000,1.000000,92627809,322285614,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(1335,10,'45 (Middle)',0,1520975117,1,1,21.041992,200,0,1,1,1,11,11,11,0,0,0,36,36,-8.057311,11.925474,359.267609,1.480616,15.018731,2.949801,-7.883568,-11.844963,182.432739,6.668518,4.957577,83.056541,-20.875381,-2.935888,279.007599,14.117767,-0.796651,79.123352,-5.936020,-0.646985,298.694733,0,0,0,0,0.000000,1.000000,92627587,322285429,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=542667921, status=3,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92627666,                     intY=322285645,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-2031473,                     ramp23=-14090319,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.932009,                     longitude=-117.888310,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=1335;
UPDATE Intersections_index SET minY=33.932009,minX=-117.888310,maxY=33.932009,maxX=-117.888310 WHERE Intersections_index.id=1335
DELETE FROM Intersections WHERE intID = 941;DELETE FROM Intersections_index WHERE id = 941
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (2508,0,0,8,0,92629587,322283253,0,1,'Added in Prelim',33.930679,-117.887022);INSERT INTO Intersections_index VALUES (2508,-117.887022,-117.887022,33.930679,33.930679);
DELETE FROM Intersections WHERE intID = 342;DELETE FROM Intersections_index WHERE id = 342
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (2608,0,0,8,0,92628702,322282415,0,1,'Added in Prelim',33.930213,-117.887615);INSERT INTO Intersections_index VALUES (2608,-117.887615,-117.887615,33.930213,33.930213);
DELETE FROM Intersections WHERE intID = 1068;DELETE FROM Intersections_index WHERE id = 1068
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (2708,0,0,8,0,92628736,322279504,0,1,'Added in Prelim',33.928593,-117.887593);INSERT INTO Intersections_index VALUES (2708,-117.887593,-117.887593,33.928593,33.928593);