/*ApVer 1.4.2 (15) DBVer 3.0 Time 542314229*/
INSERT OR REPLACE INTO Ramps VALUES(81,6,'6(Right)',0,0,1,0,132.000000,317,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,92609765,322265738,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(81,12,'81 (Middle)',0,0,1,0,35.000000,54,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,92609940,322265641,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=542314229, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92609889,                     intY=322265605,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=8781700,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=0,                     ramp45=0,                     ramp67=2359347,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920859,                     longitude=-117.900230,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=81;
UPDATE Intersections_index SET minY=33.920859,minX=-117.900230,maxY=33.920859,maxX=-117.900230 WHERE Intersections_index.id=81
Delete FROM ramps WHERE intID=81 AND rampNum = 6
INSERT OR REPLACE INTO Ramps VALUES(81,11,'67 (Middle)',0,0,1,0,132.000000,317,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,92609765,322265738,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(81,12,'81 (Middle)',0,0,1,0,35.000000,54,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,92609940,322265641,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=542314240, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92609889,                     intY=322265605,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=0,                     ramp45=8781700,                     ramp67=2359347,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920859,                     longitude=-117.900230,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=81;
UPDATE Intersections_index SET minY=33.920859,minX=-117.900230,maxY=33.920859,maxX=-117.900230 WHERE Intersections_index.id=81
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136804,4,585,81,11,7,172,33.920958,-117.900293,542314383);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136904,4,586,81,11,7,157,33.920958,-117.900293,542314395);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(137004,4,587,81,11,4,311,33.920963,-117.900270,542314412);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(137104,4,588,81,11,6,228,33.920980,-117.900283,542314443);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(137204,4,589,81,11,2,20,33.920956,-117.900306,542314458);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29504,81,67,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(137304,4,590,81,12,7,192,33.920887,-117.900196,542314589);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(137404,4,591,81,12,7,192,33.920887,-117.900196,542314686);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(137504,4,592,81,12,4,178,33.920883,-117.900251,542315023);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(137604,4,593,81,12,6,284,33.920890,-117.900200,542315038);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(137704,4,594,81,12,2,163,33.920921,-117.900197,542315054);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29604,81,81,0,2,'Curb Ramp missing top landing. |Yellow truncated domes are black not yellow. ');
INSERT OR REPLACE INTO Ramps VALUES(81,11,'67 (Middle)',0,1520621659,1,1,141.264450,317,0,1,1,12,11,11,11,1,0,1,50,42,0.000000,0.000000,0.000000,-10.325569,1.283434,131.690964,-16.165188,-3.656507,311.421173,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-3.112974,5.680138,213.810638,-10.258124,-10.017163,52.778088,0,0,0,0,0.000000,0.500000,92609765,322265738,6,'',0,0,0,0,0,0.000000,0.000000,0.500000,0.000000,2.100000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(81,12,'81 (Middle)',0,1520622256,1,1,245.960052,54,0,1,1,12,11,11,11,0,0,0,50,0,-6.620779,-2.759209,320.281403,-5.074265,-1.656738,318.669647,-4.167382,-0.241711,139.935455,-6.958512,5.814837,47.750523,-11.921699,-7.851231,224.978729,1.853671,1.366716,20.047962,-9998.000000,-9998.000000,-9998.000000,0,0,0,0,0.000000,0.500000,92609940,322265641,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=542315080, status=3,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92609889,                     intY=322265605,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=0,                     ramp45=8781700,                     ramp67=2359347,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920859,                     longitude=-117.900230,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=81;
UPDATE Intersections_index SET minY=33.920859,minX=-117.900230,maxY=33.920859,maxX=-117.900230 WHERE Intersections_index.id=81