/*ApVer 1.4.2 (15) DBVer 3.0 Time 542758597*/
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (5101,0,0,1,0,92663378,322257548,0,1,'Added in Prelim',33.916376,-117.864363);INSERT INTO Intersections_index VALUES (5101,-117.864363,-117.864363,33.916376,33.916376);
DELETE FROM Intersections WHERE intID = 3401;DELETE FROM Intersections_index WHERE id = 3401
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (5201,0,0,1,0,92661358,322256214,0,1,'Added in Prelim',33.915634,-117.865718);INSERT INTO Intersections_index VALUES (5201,-117.865718,-117.865718,33.915634,33.915634);
DELETE FROM Intersections WHERE intID = 3601;DELETE FROM Intersections_index WHERE id = 3601
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (5301,0,0,1,0,92662700,322256858,0,1,'Added in Prelim',33.915993,-117.864818);INSERT INTO Intersections_index VALUES (5301,-117.864818,-117.864818,33.915993,33.915993);
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (5401,0,0,1,0,92663046,322256030,0,1,'Added in Prelim',33.915532,-117.864585);INSERT INTO Intersections_index VALUES (5401,-117.864585,-117.864585,33.915532,33.915532);
UPDATE Intersections SET lastUpdateTime=542759040, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92664134,                     intY=322256870,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915999,                     longitude=-117.863856,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=3101;
UPDATE Intersections_index SET minY=33.915999,minX=-117.863856,maxY=33.915999,maxX=-117.863856 WHERE Intersections_index.id=3101
UPDATE Intersections SET lastUpdateTime=542759045, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92663590,                     intY=322256848,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915986,                     longitude=-117.864221,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=3001;
UPDATE Intersections_index SET minY=33.915986,minX=-117.864221,maxY=33.915986,maxX=-117.864221 WHERE Intersections_index.id=3001
UPDATE Intersections SET lastUpdateTime=542759051, status=1,                     assignedToPrelim=1,                     assignedToDetail=0,                     intX=92663378,                     intY=322257548,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.916376,                     longitude=-117.864363,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=5101;
UPDATE Intersections_index SET minY=33.916376,minX=-117.864363,maxY=33.916376,maxX=-117.864363 WHERE Intersections_index.id=5101
UPDATE Intersections SET lastUpdateTime=542759055, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92663315,                     intY=322256864,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915995,                     longitude=-117.864405,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=2901;
UPDATE Intersections_index SET minY=33.915995,minX=-117.864405,maxY=33.915995,maxX=-117.864405 WHERE Intersections_index.id=2901
UPDATE Intersections SET lastUpdateTime=542759061, status=1,                     assignedToPrelim=1,                     assignedToDetail=0,                     intX=92662700,                     intY=322256858,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915992,                     longitude=-117.864818,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=5301;
UPDATE Intersections_index SET minY=33.915992,minX=-117.864818,maxY=33.915992,maxX=-117.864818 WHERE Intersections_index.id=5301
UPDATE Intersections SET lastUpdateTime=542759065, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92662327,                     intY=322256862,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915994,                     longitude=-117.865068,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=3201;
UPDATE Intersections_index SET minY=33.915994,minX=-117.865068,maxY=33.915994,maxX=-117.865068 WHERE Intersections_index.id=3201
UPDATE Intersections SET lastUpdateTime=542759069, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92662135,                     intY=322257049,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.916098,                     longitude=-117.865197,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=3301;
UPDATE Intersections_index SET minY=33.916098,minX=-117.865197,maxY=33.916098,maxX=-117.865197 WHERE Intersections_index.id=3301
UPDATE Intersections SET lastUpdateTime=542759073, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92662146,                     intY=322256417,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915747,                     longitude=-117.865189,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=3501;
UPDATE Intersections_index SET minY=33.915747,minX=-117.865189,maxY=33.915747,maxX=-117.865189 WHERE Intersections_index.id=3501
UPDATE Intersections SET lastUpdateTime=542759077, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92662415,                     intY=322256231,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915643,                     longitude=-117.865009,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=3701;
UPDATE Intersections_index SET minY=33.915643,minX=-117.865009,maxY=33.915643,maxX=-117.865009 WHERE Intersections_index.id=3701
UPDATE Intersections SET lastUpdateTime=542759081, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92663464,                     intY=322255786,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915395,                     longitude=-117.864305,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=3901;
UPDATE Intersections_index SET minY=33.915395,minX=-117.864305,maxY=33.915395,maxX=-117.864305 WHERE Intersections_index.id=3901
UPDATE Intersections SET lastUpdateTime=542759084, status=1,                     assignedToPrelim=1,                     assignedToDetail=0,                     intX=92663046,                     intY=322256030,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915531,                     longitude=-117.864586,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=5401;
UPDATE Intersections_index SET minY=33.915531,minX=-117.864586,maxY=33.915531,maxX=-117.864586 WHERE Intersections_index.id=5401
UPDATE Intersections SET lastUpdateTime=542759088, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92662162,                     intY=322255715,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915356,                     longitude=-117.865178,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=3801;
UPDATE Intersections_index SET minY=33.915356,minX=-117.865178,maxY=33.915356,maxX=-117.865178 WHERE Intersections_index.id=3801
UPDATE Intersections SET lastUpdateTime=542759092, status=1,                     assignedToPrelim=1,                     assignedToDetail=1,                     intX=92663195,                     intY=322255231,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     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.915087,                     longitude=-117.864486,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=4001;
UPDATE Intersections_index SET minY=33.915087,minX=-117.864486,maxY=33.915087,maxX=-117.864486 WHERE Intersections_index.id=4001
UPDATE Intersections SET lastUpdateTime=542759115, assignedToDetail=1 WHERE intID=5201
UPDATE Intersections SET lastUpdateTime=542759115, assignedToDetail=1 WHERE intID=5301
UPDATE Intersections SET lastUpdateTime=542759116, assignedToDetail=1 WHERE intID=5101
UPDATE Intersections SET lastUpdateTime=542759117, assignedToDetail=1 WHERE intID=5401
UPDATE Intersections SET lastUpdateTime=542759122, assignedToDetail=1 WHERE intID=1477
UPDATE Intersections SET lastUpdateTime=542759123, assignedToDetail=1 WHERE intID=647
UPDATE Intersections SET lastUpdateTime=542759123, assignedToDetail=1 WHERE intID=648
UPDATE Intersections SET lastUpdateTime=542759124, assignedToDetail=1 WHERE intID=646
UPDATE Intersections SET lastUpdateTime=542759124, assignedToDetail=1 WHERE intID=252
UPDATE Intersections SET lastUpdateTime=542759125, assignedToDetail=1 WHERE intID=253
UPDATE Intersections SET lastUpdateTime=542759126, assignedToDetail=1 WHERE intID=649
UPDATE Intersections SET lastUpdateTime=542759126, assignedToDetail=1 WHERE intID=436
UPDATE Intersections SET lastUpdateTime=542759127, assignedToDetail=1 WHERE intID=256
UPDATE Intersections SET lastUpdateTime=542759128, assignedToDetail=1 WHERE intID=1400
UPDATE Intersections SET lastUpdateTime=542759128, assignedToDetail=1 WHERE intID=1109
UPDATE Intersections SET lastUpdateTime=542759129, assignedToDetail=1 WHERE intID=908
UPDATE Intersections SET lastUpdateTime=542759130, assignedToDetail=1 WHERE intID=347
UPDATE Intersections SET lastUpdateTime=542759130, assignedToDetail=1 WHERE intID=254
UPDATE Intersections SET lastUpdateTime=542759131, assignedToDetail=1 WHERE intID=257
UPDATE Intersections SET lastUpdateTime=542759132, assignedToDetail=1 WHERE intID=258
UPDATE Intersections SET lastUpdateTime=542759132, assignedToDetail=1 WHERE intID=349
UPDATE Intersections SET lastUpdateTime=542759133, assignedToDetail=1 WHERE intID=350
UPDATE Intersections SET lastUpdateTime=542759134, assignedToDetail=1 WHERE intID=1414
UPDATE Intersections SET lastUpdateTime=542759157, assignedToDetail=1 WHERE intID=709
UPDATE Intersections SET lastUpdateTime=542759230, assignedToDetail=1 WHERE intID=143
UPDATE Intersections SET lastUpdateTime=542759431, assignedToDetail=1 WHERE intID=1142
UPDATE Intersections SET lastUpdateTime=542759433, assignedToDetail=0 WHERE intID=1142
DELETE FROM Intersections WHERE intID = 752;DELETE FROM Intersections_index WHERE id = 752
DELETE FROM Intersections WHERE intID = 318;DELETE FROM Intersections_index WHERE id = 318
DELETE FROM Intersections WHERE intID = 1142;DELETE FROM Intersections_index WHERE id = 1142
DELETE FROM Intersections WHERE intID = 121;DELETE FROM Intersections_index WHERE id = 121
DELETE FROM Intersections WHERE intID = 566;DELETE FROM Intersections_index WHERE id = 566
DELETE FROM Intersections WHERE intID = 567;DELETE FROM Intersections_index WHERE id = 567
DELETE FROM Intersections WHERE intID = 10;DELETE FROM Intersections_index WHERE id = 10
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (5501,0,0,1,0,92614277,322268104,0,1,'Added in Prelim',33.922251,-117.897288);INSERT INTO Intersections_index VALUES (5501,-117.897288,-117.897288,33.922251,33.922251);