/*ApVer 1.4.2 (15) DBVer 3.0 Time 542578527*/
INSERT OR REPLACE INTO Ramps VALUES(150,9,'23 (Middle)',0,0,1,0,304.000000,145,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,92635209,322278959,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(150,10,'45 (Middle)',0,0,1,0,214.000000,235,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,92634871,322278910,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=542578527, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92635123,                     intY=322279085,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-8257450,                     ramp23=-11403516,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.928360,                     longitude=-117.883309,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=150;
UPDATE Intersections_index SET minY=33.928360,minX=-117.883309,maxY=33.928360,maxX=-117.883309 WHERE Intersections_index.id=150
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(145508,8,18,150,10,4,2,33.928304,-117.883476,542578895);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(145608,8,19,150,10,4,2,33.928304,-117.883476,542578907);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(145708,8,20,150,10,2,29,33.928301,-117.883477,542579047);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(145808,8,21,150,9,4,309,33.928323,-117.883223,542579204);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(145908,8,22,150,9,2,52,33.928326,-117.883214,542579273);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(146008,8,23,150,9,2,118,33.928312,-117.883220,542579291);
INSERT OR REPLACE INTO Ramps VALUES(150,9,'23 (Middle)',0,1520886497,1,1,343.184448,145,0,1,1,12,11,11,11,0,0,0,48,43,-11.170039,0.847140,310.460388,-0.648318,0.539993,312.239441,-10.425366,-1.069147,124.361099,102.067787,-66.619980,32.837105,-10.606199,-8.211447,229.760040,0.692730,0.713682,11.854543,-1.340183,-0.369451,267.483063,0,0,0,0,0.000000,0.000000,92635209,322278959,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(150,10,'45 (Middle)',0,1520886253,1,1,15.643628,235,0,1,1,12,11,11,11,0,0,0,48,38,-9.298470,0.621455,35.092136,-0.839539,0.076968,41.873489,-13.319432,-0.949971,216.318314,-46.369385,-23.725237,120.592079,-8.662849,-734.895569,319.769104,0.760422,1.235039,113.837456,-0.366336,-1.211722,335.356750,0,0,0,0,0.000000,0.000000,92634871,322278910,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=542579304, status=3,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92635123,                     intY=322279085,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-8257450,                     ramp23=-11403516,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.928360,                     longitude=-117.883309,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=150;
UPDATE Intersections_index SET minY=33.928360,minX=-117.883309,maxY=33.928360,maxX=-117.883309 WHERE Intersections_index.id=150
DELETE FROM Intersections WHERE intID = 1368;DELETE FROM Intersections_index WHERE id = 1368
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (2408,0,0,8,0,92634472,322277338,0,1,'Added in Prelim',33.927388,-117.883746);INSERT INTO Intersections_index VALUES (2408,-117.883746,-117.883746,33.927388,33.927388);
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (2508,0,0,8,0,92634472,322277338,0,1,'Added in Prelim',33.927388,-117.883746);INSERT INTO Intersections_index VALUES (2508,-117.883746,-117.883746,33.927388,33.927388);
DELETE FROM Intersections WHERE intID = 2408;DELETE FROM Intersections_index WHERE id = 2408
DELETE FROM Intersections WHERE intID = 2508;DELETE FROM Intersections_index WHERE id = 2508