/*ApVer 1.4.2 (15) DBVer 3.0 Time 542652720*/
INSERT OR REPLACE INTO Ramps VALUES(87,2,'2(Right)',0,1520959910,1,1,2.000000,148,0,1,1,11,11,11,11,0,0,0,48,44,0.000000,0.000000,0.000000,-2.704807,8.890603,317.488251,-2.907598,-9.535822,133.195145,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2.043289,0.784708,50.437115,-10.440994,-1.245404,225.687668,0,0,0,0,0.000000,0.000000,92633499,322270484,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,48,36);
INSERT OR REPLACE INTO Ramps VALUES(87,8,'8(Right)',0,1520959678,1,1,265.000000,24,0,1,1,11,11,11,11,0,0,0,48,50,0.000000,0.000000,0.000000,-1.221869,1.672612,227.672607,8.060836,-0.951599,44.853748,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-5.533729,8.231373,317.894043,-7.254181,-0.675341,140.908127,0,0,0,0,0.000000,0.000000,92633508,322270738,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,48,36);
UPDATE Intersections SET lastUpdateTime=542652720, status=3,                     assignedToPrelim=9,                     assignedToDetail=9,                     intX=92633438,                     intY=322270584,                     ramp1=0,                     ramp2=-6553539,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=10092614,                     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.923630,                     longitude=-117.884439,                     zoomLevel=20,                     doLater=0,                     intersectionComment=''                      WHERE intID=87;
UPDATE Intersections_index SET minY=33.923630,minX=-117.884439,maxY=33.923630,maxX=-117.884439 WHERE Intersections_index.id=87
DELETE FROM Intersections WHERE intID = 95;DELETE FROM Intersections_index WHERE id = 95
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (2409,0,0,9,0,92635479,322270647,0,1,'Added in Prelim',33.923666,-117.883071);INSERT INTO Intersections_index VALUES (2409,-117.883071,-117.883071,33.923666,33.923666);
DELETE FROM Intersections WHERE intID = 2409;DELETE FROM Intersections_index WHERE id = 2409
INSERT OR REPLACE INTO Ramps VALUES(527,9,'23 (Middle)',0,0,1,0,317.000000,132,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,92633503,322269222,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(527,12,'81 (Middle)',0,0,1,0,60.000000,29,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,92633486,322269491,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=542653266, status=2,                     assignedToPrelim=9,                     assignedToDetail=9,                     intX=92633392,                     intY=322269326,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-6815633,                     ramp23=0,                     ramp45=0,                     ramp67=10813534,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.922930,                     longitude=-117.884470,                     zoomLevel=20,                     doLater=0,                     intersectionComment=''                      WHERE intID=527;
UPDATE Intersections_index SET minY=33.922930,minX=-117.884470,maxY=33.922930,maxX=-117.884470 WHERE Intersections_index.id=527