/*ApVer 1.4.2 (15) DBVer 3.0 Time 542224273*/
INSERT OR REPLACE INTO Ramps VALUES(938,2,'2(Right)',0,0,1,0,332.000000,117,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,92628095,322290949,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(938,4,'4(Right)',0,0,1,0,221.000000,228,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,92627790,322290867,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=542224273, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92627964,                     intY=322291019,                     ramp1=0,                     ramp2=-4587389,                     ramp3=0,                     ramp4=-9896110,                     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.934999,                     longitude=-117.888110,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=938;
UPDATE Intersections_index SET minY=33.934999,minX=-117.888110,maxY=33.934999,maxX=-117.888110 WHERE Intersections_index.id=938
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(109504,4,312,938,2,7,138,33.934979,-117.888044,542224333);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(109604,4,313,938,2,7,138,33.934979,-117.888044,542224345);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(109704,4,314,938,2,7,273,33.934968,-117.888031,542224360);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(109804,4,315,938,2,7,273,33.934968,-117.888031,542224364);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(109904,4,316,938,2,4,106,33.934975,-117.888041,542224385);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110004,4,317,938,2,2,135,33.934970,-117.888042,542224429);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(24504,938,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110104,4,318,938,4,7,236,33.934931,-117.888175,542224502);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110204,4,319,938,4,7,6,33.934925,-117.888199,542224516);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110304,4,320,938,4,4,2,33.934925,-117.888199,542224531);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(110404,4,321,938,4,2,219,33.934937,-117.888204,542224587);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(24604,938,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO Ramps VALUES(938,2,'2(Right)',0,1520531631,1,1,334.000000,117,0,1,1,11,11,11,11,0,1,1,48,33,0.000000,0.000000,0.000000,-3.415597,5.116687,292.614410,7.862350,-5.265635,113.354362,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-5.935672,6.036349,13.780214,-15.203771,-3.634135,212.351700,0,0,0,0,0.000000,0.000000,92628095,322290949,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.500000,1.500000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
INSERT OR REPLACE INTO Ramps VALUES(938,4,'4(Right)',0,1520531789,1,1,76.000000,228,0,1,1,11,11,11,11,0,1,1,48,68,0.000000,0.000000,0.000000,-0.595467,12.273943,38.011703,-9.051161,-10.038673,212.596786,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2.057333,-0.098422,105.940872,-16.760452,1.367639,309.087708,0,0,0,0,0.000000,0.000000,92627790,322290867,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.500000,0.100000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
UPDATE Intersections SET lastUpdateTime=542224601, status=3,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92627964,                     intY=322291019,                     ramp1=0,                     ramp2=-4587389,                     ramp3=0,                     ramp4=-9896110,                     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.934999,                     longitude=-117.888110,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=938;
UPDATE Intersections_index SET minY=33.934999,minX=-117.888110,maxY=33.934999,maxX=-117.888110 WHERE Intersections_index.id=938
DELETE FROM Intersections WHERE intID = 340;DELETE FROM Intersections_index WHERE id = 340
DELETE FROM Intersections WHERE intID = 341;DELETE FROM Intersections_index WHERE id = 341
DELETE FROM Intersections WHERE intID = 416;DELETE FROM Intersections_index WHERE id = 416
DELETE FROM Intersections WHERE intID = 1529;DELETE FROM Intersections_index WHERE id = 1529
DELETE FROM Intersections WHERE intID = 766;DELETE FROM Intersections_index WHERE id = 766
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (2104,0,0,4,0,92627038,322290867,0,1,'Added in Prelim',33.934915,-117.888731);INSERT INTO Intersections_index VALUES (2104,-117.888731,-117.888731,33.934915,33.934915);
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (2204,0,0,4,0,92626542,322290912,0,1,'Added in Prelim',33.934940,-117.889064);INSERT INTO Intersections_index VALUES (2204,-117.889064,-117.889064,33.934940,33.934940);
UPDATE Intersections SET lastUpdateTime=542224954, nStreets=1, streetNames='Canyon Country Rd' WHERE intID=2104
UPDATE Intersections SET lastUpdateTime=542224970, nStreets=1, streetNames='Canyon Country Rd' WHERE intID=2204