/*ApVer 1.4.2 (15) DBVer 3.0 Time 543189890*/
INSERT OR REPLACE INTO Ramps VALUES(167,9,'23 (Middle)',0,0,1,0,313.000000,136,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,92587038,322250047,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(167,12,'81 (Middle)',0,0,1,0,42.000000,47,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,92587047,322250315,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=543189890, status=0,                     assignedToPrelim=0,                     assignedToDetail=2,                     intX=92586908,                     intY=322250186,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-9109374,                     ramp23=0,                     ramp45=0,                     ramp67=8454283,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.912279,                     longitude=-117.915640,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=167;
UPDATE Intersections_index SET minY=33.912279,minX=-117.915640,maxY=33.912279,maxX=-117.915640 WHERE Intersections_index.id=167
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(56902,167,81,0,2,'Yellow truncated domes are black not yellow. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(322402,2,171,167,12,2,152,33.912342,-117.915550,543190074);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(322502,2,172,167,12,2,152,33.912342,-117.915550,543190094);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(57002,167,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(322602,2,173,167,9,2,74,33.912187,-117.915550,543190340);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(322702,2,174,167,9,2,74,33.912187,-117.915550,543190350);
INSERT OR REPLACE INTO Ramps VALUES(167,9,'23 (Middle)',0,1521497552,1,1,315.006836,136,0,1,1,12,11,11,11,0,0,0,50,38,-5.790970,-1.380748,313.983856,-1.424382,-0.061758,308.249695,-10.920270,3.278659,132.553299,-8.215837,5.607421,28.044502,-3.353595,-5.233382,241.463776,0.951665,1.473416,355.682068,4.959566,-2.243360,268.400757,0,0,0,0,0.000000,0.000000,92587038,322250047,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(167,12,'81 (Middle)',0,1521497298,1,1,214.126144,47,0,1,1,12,11,11,11,0,0,0,44,43,-6.917875,1.360929,223.697479,-2.716586,-0.028521,227.032898,-10.208756,0.170246,41.003933,-3.823446,7.539070,294.648651,-5.000307,-5.573260,138.828583,-4.142022,1.811951,271.960114,0.137590,-1.697283,170.569809,0,0,0,0,0.000000,0.000000,92587047,322250315,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=543190358, status=3,                     assignedToPrelim=0,                     assignedToDetail=2,                     intX=92586908,                     intY=322250186,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-9109374,                     ramp23=0,                     ramp45=0,                     ramp67=8454283,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.912279,                     longitude=-117.915640,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=167;
UPDATE Intersections_index SET minY=33.912279,minX=-117.915640,maxY=33.912279,maxX=-117.915640 WHERE Intersections_index.id=167