/*ApVer 1.4.2 (15) DBVer 3.0 Time 542142126*/
INSERT OR REPLACE INTO Ramps VALUES(920,4,'4(Right)',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,92673065,322263765,9,'',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=542142126, status=0,                     assignedToPrelim=0,                     assignedToDetail=5,                     intX=92673180,                     intY=322263844,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=-5111923,                     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.919879,                     longitude=-117.857790,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=920;
UPDATE Intersections_index SET minY=33.919879,minX=-117.857790,maxY=33.919879,maxX=-117.857790 WHERE Intersections_index.id=920
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(95805,5,25,920,4,4,168,33.919809,-117.857763,542142345);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(95905,5,26,920,4,6,201,33.919815,-117.857820,542142502);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(96005,5,27,920,4,2,118,33.919811,-117.857761,542142524);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(96105,5,28,920,4,2,118,33.919811,-117.857761,542142540);
INSERT OR REPLACE INTO Ramps VALUES(920,4,'4(Right)',0,1520449751,1,1,45.000000,235,0,1,1,1,11,11,11,0,0,0,216,0,0.000000,0.000000,0.000000,-7.059784,1.859386,2.997298,-8.749246,-1.103951,190.029419,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-11.254868,4.437896,109.622246,-9.398273,-5.156286,259.221222,0,0,0,0,0.000000,3.000000,92673065,322263765,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=542142555, status=3,                     assignedToPrelim=0,                     assignedToDetail=5,                     intX=92673180,                     intY=322263844,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=-5111923,                     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.919879,                     longitude=-117.857790,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=920;
UPDATE Intersections_index SET minY=33.919879,minX=-117.857790,maxY=33.919879,maxX=-117.857790 WHERE Intersections_index.id=920
DELETE FROM Intersections WHERE intID = 260;DELETE FROM Intersections_index WHERE id = 260
DELETE FROM Intersections WHERE intID = 49;DELETE FROM Intersections_index WHERE id = 49
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (1705,0,0,5,0,92672346,322268409,0,1,'Added in Prelim',33.922420,-117.858350);INSERT INTO Intersections_index VALUES (1705,-117.858350,-117.858350,33.922420,33.922420);
UPDATE Intersections SET lastUpdateTime=542143041, nStreets=1, streetNames='Shamrock ' WHERE intID=1705
UPDATE Intersections SET lastUpdateTime=542143048, nStreets=1, streetNames='Shamrock ' WHERE intID=1705
UPDATE Intersections SET lastUpdateTime=542143057, intX=92672346, intY=322268359, latitude=33.922392, longitude=-117.858350 WHERE intID=1705
UPDATE Intersections_index SET minY=33.922392,minX=-117.858350,maxY=33.922392,maxX=-117.858350 WHERE Intersections_index.id=1705
INSERT OR REPLACE INTO Ramps VALUES(1705,6,'6(Right)',0,0,1,0,118.000000,331,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,92672222,322268587,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,0);
INSERT OR REPLACE INTO Ramps VALUES(1705,8,'8(Right)',0,0,1,0,4.000000,85,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,92672460,322268369,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,0);
UPDATE Intersections SET lastUpdateTime=542143073, status=2,                     assignedToPrelim=5,                     assignedToDetail=0,                     intX=92672346,                     intY=322268360,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=14942084,                     ramp7=0,                     ramp8=589938,                     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.922392,                     longitude=-117.858350,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=1705;
UPDATE Intersections_index SET minY=33.922392,minX=-117.858350,maxY=33.922392,maxX=-117.858350 WHERE Intersections_index.id=1705