/*ApVer 1.4.2 (15) DBVer 3.0 Time 542140525*/
INSERT OR REPLACE INTO Ramps VALUES(473,2,'2(Right)',0,0,1,0,311.000000,138,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,92623079,322274412,11,'',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(473,4,'4(Right)',0,0,1,0,209.000000,240,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,92622758,322274418,11,'',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=542140525, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92622968,                     intY=322274537,                     ramp1=0,                     ramp2=-8191889,                     ramp3=0,                     ramp4=-7733458,                     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.925829,                     longitude=-117.891460,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=473;
UPDATE Intersections_index SET minY=33.925829,minX=-117.891460,maxY=33.925829,maxX=-117.891460 WHERE Intersections_index.id=473
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(20904,473,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(93904,4,156,473,4,7,16,33.925767,-117.891627,542140601);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(94004,4,157,473,4,4,77,33.925780,-117.891625,542140618);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(94104,4,158,473,4,4,77,33.925780,-117.891625,542140619);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(94204,4,159,473,4,2,186,33.925773,-117.891620,542140677);
INSERT OR REPLACE INTO Ramps VALUES(473,2,'2(Right)',0,1520447896,1,1,4.000000,138,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,92623079,322274412,11,'',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(473,4,'4(Right)',0,1520447879,1,1,91.000000,240,0,1,1,11,11,11,11,0,0,1,85,100,-5.021035,3.058012,90.186279,1.275627,4.612061,90.455734,5.922989,0.427411,211.769958,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,92622758,322274418,11,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,1.800000,0.000000,0.000000,0.000000,0.000000,0.000000,80,35);
UPDATE Intersections SET lastUpdateTime=542140699, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92622968,                     intY=322274537,                     ramp1=0,                     ramp2=-8191889,                     ramp3=0,                     ramp4=-7733458,                     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.925829,                     longitude=-117.891460,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=473;
UPDATE Intersections_index SET minY=33.925829,minX=-117.891460,maxY=33.925829,maxX=-117.891460 WHERE Intersections_index.id=473
Delete FROM ramps WHERE intID=473 AND rampNum = 2
INSERT OR REPLACE INTO Ramps VALUES(473,3,'3(Left)',0,0,1,0,4.000000,138,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,92623079,322274412,11,'',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(473,4,'4(Right)',0,1520447879,1,1,91.000000,240,0,1,1,11,11,11,11,0,0,1,85,100,-5.021035,3.058012,90.186279,1.275627,4.612061,90.455734,5.922989,0.427411,211.769958,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,92622758,322274418,11,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,1.800000,0.000000,0.000000,0.000000,0.000000,0.000000,80,35);
UPDATE Intersections SET lastUpdateTime=542140704, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92622968,                     intY=322274537,                     ramp1=0,                     ramp2=0,                     ramp3=-8191889,                     ramp4=-7733458,                     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.925829,                     longitude=-117.891460,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=473;
UPDATE Intersections_index SET minY=33.925829,minX=-117.891460,maxY=33.925829,maxX=-117.891460 WHERE Intersections_index.id=473
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(21004,473,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(94304,4,160,473,3,7,87,33.925763,-117.891395,542140769);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(94404,4,161,473,3,4,240,33.925757,-117.891410,542140783);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(94504,4,162,473,3,2,231,33.925778,-117.891398,542140832);
INSERT OR REPLACE INTO Ramps VALUES(473,3,'3(Left)',0,1520448034,1,1,282.000000,138,0,1,1,11,11,11,11,1,0,0,90,100,-7.042987,-1.709349,270.632507,-0.514381,-4.363149,272.700378,5.867638,0.570958,154.146652,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,92623079,322274412,11,'',0,0,0,0,0,0.000000,0.000000,0.100000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,84,36);
INSERT OR REPLACE INTO Ramps VALUES(473,4,'4(Right)',0,1520447879,1,1,91.000000,240,0,1,1,11,11,11,11,0,0,1,85,100,-5.021035,3.058012,90.186279,1.275627,4.612061,90.455734,5.922989,0.427411,211.769958,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,92622758,322274418,11,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,1.800000,0.000000,0.000000,0.000000,0.000000,0.000000,80,35);
UPDATE Intersections SET lastUpdateTime=542140838, status=3,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92622968,                     intY=322274537,                     ramp1=0,                     ramp2=0,                     ramp3=-8191889,                     ramp4=-7733458,                     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.925829,                     longitude=-117.891460,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=473;
UPDATE Intersections_index SET minY=33.925829,minX=-117.891460,maxY=33.925829,maxX=-117.891460 WHERE Intersections_index.id=473
INSERT INTO Intersections (intID,lastUpdateTime,status, assignedToPrelim,assignedToDetail,intX,intY,rotation,nStreets,streetNames,latitude,longitude) VALUES (1704,0,0,4,0,92624153,322274656,0,1,'Added in Prelim',33.925896,-117.890665);INSERT INTO Intersections_index VALUES (1704,-117.890665,-117.890665,33.925896,33.925896);
UPDATE Intersections SET lastUpdateTime=542140889, intX=92623996, intY=322274485, latitude=33.925801, longitude=-117.890771 WHERE intID=808
UPDATE Intersections_index SET minY=33.925801,minX=-117.890771,maxY=33.925801,maxX=-117.890771 WHERE Intersections_index.id=808
UPDATE Intersections SET lastUpdateTime=542140891, status=2,                     assignedToPrelim=4,                     assignedToDetail=0,                     intX=92623995,                     intY=322274485,                     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.925800,                     longitude=-117.890771,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=808;
UPDATE Intersections_index SET minY=33.925800,minX=-117.890771,maxY=33.925800,maxX=-117.890771 WHERE Intersections_index.id=808