/*ApVer 1.4.2 (15) DBVer 3.0 Time 543173351*/
INSERT OR REPLACE INTO Ramps VALUES(845,10,'45 (Middle)',0,0,1,0,223.000000,226,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,92611584,322271674,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(845,11,'67 (Middle)',0,0,1,0,149.000000,300,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,92611584,322271979,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=543173351, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92611783,                     intY=322271860,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=-12124359,                     ramp45=7864121,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.924340,                     longitude=-117.898960,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=845;
UPDATE Intersections_index SET minY=33.924340,minX=-117.898960,maxY=33.924340,maxX=-117.898960 WHERE Intersections_index.id=845
INSERT OR REPLACE INTO Ramps VALUES(845,9,'23 (Middle)',0,0,1,0,303.000000,146,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,92611904,322271674,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(845,10,'45 (Middle)',0,0,1,0,223.000000,226,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,92611584,322271674,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);
Delete FROM ramps WHERE intID=845 AND rampNum = 11
UPDATE Intersections SET lastUpdateTime=543174788, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92611783,                     intY=322271860,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-12189575,                     ramp23=-12124359,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.924340,                     longitude=-117.898960,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=845;
UPDATE Intersections_index SET minY=33.924340,minX=-117.898960,maxY=33.924340,maxX=-117.898960 WHERE Intersections_index.id=845
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(55508,845,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(323808,8,1801,845,9,4,246,33.924260,-117.898905,543174804);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(323908,8,1802,845,9,4,246,33.924260,-117.898905,543174807);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(324008,8,1803,845,9,2,210,33.924246,-117.898907,543174821);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(324108,8,1804,845,9,2,210,33.924246,-117.898907,543174827);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(55608,845,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(324208,8,1805,845,10,2,184,33.924260,-117.899081,543175007);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(324308,8,1806,845,10,4,263,33.924214,-117.899066,543175055);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(324408,8,1807,845,10,4,263,33.924214,-117.899066,543175058);
INSERT OR REPLACE INTO Ramps VALUES(845,9,'23 (Middle)',0,1521482185,1,1,323.019287,146,0,1,1,12,11,11,11,0,0,0,62,43,-13.617936,0.722378,311.290619,-3.103703,1.861769,308.024323,-1.016875,-0.970558,135.317932,-5.893628,11.231869,42.015133,-19.157469,-8.635970,234.014389,1.061523,2.268289,12.583544,-1.420308,-4.154953,237.427505,0,0,0,0,0.000000,0.000000,92611904,322271674,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(845,10,'45 (Middle)',0,1521482346,1,1,31.002176,226,0,1,1,12,11,11,11,0,0,0,38,48,-10.221538,2.147676,48.212460,-4.261230,2.852825,51.183044,-8.686185,-0.488280,222.819626,-9.889290,9.610857,121.123970,-11.532104,-8.995616,323.832733,1.747076,3.475886,109.082237,-2.711834,-4.482069,343.690033,0,0,0,0,0.000000,0.000000,92611584,322271674,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=543175148, status=3,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92611783,                     intY=322271860,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-12189575,                     ramp23=-12124359,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.924340,                     longitude=-117.898960,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=845;
UPDATE Intersections_index SET minY=33.924340,minX=-117.898960,maxY=33.924340,maxX=-117.898960 WHERE Intersections_index.id=845