/*ApVer 1.4.2 (15) DBVer 3.0 Time 542827384*/
INSERT OR REPLACE INTO Ramps VALUES(172,11,'67 (Middle)',0,0,1,0,158.000000,291,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,92583552,322303443,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(172,12,'81 (Middle)',0,0,1,0,79.000000,10,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,92583831,322303580,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=542827384, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92583791,                     intY=322303350,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=0,                     ramp45=6160145,                     ramp67=15073320,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.941859,                     longitude=-117.917730,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=172;
UPDATE Intersections_index SET minY=33.941859,minX=-117.917730,maxY=33.941859,maxX=-117.917730 WHERE Intersections_index.id=172
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(43208,172,81,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247108,8,1034,172,12,4,142,33.942020,-117.917733,542827473);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247208,8,1035,172,12,4,142,33.942020,-117.917733,542827477);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247308,8,1036,172,12,2,270,33.942014,-117.917689,542827514);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247408,8,1037,172,12,2,270,33.942014,-117.917689,542827521);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(43308,172,67,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247508,8,1038,172,11,4,7,33.941916,-117.917890,542827655);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247608,8,1039,172,11,4,7,33.941916,-117.917890,542827659);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247708,8,1040,172,11,5,145,33.941946,-117.917874,542827674);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247808,8,1041,172,11,2,130,33.941934,-117.917878,542827718);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(247908,8,1042,172,11,2,130,33.941934,-117.917878,542827726);
INSERT OR REPLACE INTO Ramps VALUES(172,11,'67 (Middle)',0,1521134929,1,1,119.023544,291,0,1,1,12,6,0,0,0,0,0,45,34,-9.108239,-1.241389,96.490166,-7.550627,-5.918450,110.530930,-6.487764,3.856395,292.328033,-12.453251,5.432440,198.468216,-0.652706,-6.955789,25.851534,-4.469035,2.673998,158.721634,5.291795,-4.778503,47.178246,0,0,0,0,0.000000,0.000000,92583552,322303443,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(172,12,'81 (Middle)',0,1521134723,1,1,197.798828,10,0,1,1,12,11,11,11,0,0,0,48,44,-7.314865,-5.911835,188.083847,-7.123138,-8.796209,201.113907,12.976641,3.207690,21.294233,-11.822362,7.215059,270.033600,-2.541378,-6.169604,116.387405,-9.693884,2.186982,259.137177,5.917037,-4.381633,136.878540,0,0,0,0,0.000000,0.000000,92583831,322303580,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=542827732, status=3,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92583791,                     intY=322303350,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=0,                     ramp45=6160145,                     ramp67=15073320,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.941859,                     longitude=-117.917730,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=172;
UPDATE Intersections_index SET minY=33.941859,minX=-117.917730,maxY=33.941859,maxX=-117.917730 WHERE Intersections_index.id=172