/*ApVer 1.4.2 (15) DBVer 3.0 Time 543261818*/
INSERT OR REPLACE INTO Ramps VALUES(199,9,'23 (Middle)',0,0,1,0,292.000000,157,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,92614057,322276950,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(199,12,'81 (Middle)',0,0,1,0,60.000000,29,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,92614073,322277256,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=543261818, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92613991,                     intY=322277108,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-10354622,                     ramp23=0,                     ramp45=0,                     ramp67=9699410,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.927260,                     longitude=-117.897480,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=199;
UPDATE Intersections_index SET minY=33.927260,minX=-117.897480,maxY=33.927260,maxX=-117.897480 WHERE Intersections_index.id=199
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(61808,199,23,0,2,'Yellow truncated domes are black not yellow. |Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(369208,8,2255,199,9,4,45,33.927227,-117.897525,543262017);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(369308,8,2256,199,9,4,45,33.927227,-117.897525,543262023);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(369408,8,2257,199,9,4,45,33.927227,-117.897525,543262026);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(369508,8,2258,199,9,4,247,33.927232,-117.897429,543262067);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(369608,8,2259,199,9,4,247,33.927232,-117.897429,543262070);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(369708,8,2260,199,9,2,287,33.927129,-117.897528,543262121);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(369808,8,2261,199,9,2,287,33.927129,-117.897528,543262130);
INSERT OR REPLACE INTO Ramps VALUES(199,9,'23 (Middle)',0,1521569332,1,1,329.955841,157,0,1,1,11,11,11,11,0,0,0,49,49,-5.880916,-1.140121,311.442688,-0.621963,-0.184448,308.247742,5.724265,1.822256,134.063721,-4.586981,6.629940,45.650066,-4.786082,-5.481654,238.513870,-3.026875,1.875589,5.014151,-0.810410,-2.604956,254.077118,0,0,0,0,0.000000,0.000000,92614057,322276950,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,48,36);
INSERT OR REPLACE INTO Ramps VALUES(199,12,'81 (Middle)',0,0,1,0,60.000000,29,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,92614073,322277256,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=543262137, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92613991,                     intY=322277108,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-10354622,                     ramp23=0,                     ramp45=0,                     ramp67=9699410,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.927260,                     longitude=-117.897480,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=199;
UPDATE Intersections_index SET minY=33.927260,minX=-117.897480,maxY=33.927260,maxX=-117.897480 WHERE Intersections_index.id=199
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(61908,199,81,0,2,'Yellow truncated domes are black not yellow. |Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(369908,8,2262,199,12,2,292,33.927226,-117.897525,543262150);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370008,8,2263,199,12,2,292,33.927226,-117.897525,543262159);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370108,8,2264,199,12,4,219,33.927219,-117.897525,543262295);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370208,8,2265,199,12,4,87,33.927329,-117.897518,543262327);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370308,8,2266,199,12,4,87,33.927329,-117.897518,543262331);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370408,8,2267,199,12,4,87,33.927329,-117.897518,543262334);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370508,8,2268,199,12,4,114,33.927329,-117.897518,543262339);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370608,8,2269,199,12,4,166,33.927322,-117.897465,543262529);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370708,8,2270,199,12,4,166,33.927322,-117.897465,543262533);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370808,8,2271,199,12,4,201,33.927326,-117.897464,543262549);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(370908,8,2272,199,12,4,201,33.927326,-117.897464,543262552);
INSERT OR REPLACE INTO Ramps VALUES(199,9,'23 (Middle)',0,1521569332,1,1,329.955841,157,0,1,1,11,11,11,11,0,0,0,49,49,-5.880916,-1.140121,311.442688,-0.621963,-0.184448,308.247742,5.724265,1.822256,134.063721,-4.586981,6.629940,45.650066,-4.786082,-5.481654,238.513870,-3.026875,1.875589,5.014151,-0.810410,-2.604956,254.077118,0,0,0,0,0.000000,0.000000,92614057,322276950,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,48,36);
INSERT OR REPLACE INTO Ramps VALUES(199,12,'81 (Middle)',0,1521569763,1,1,238.029968,29,0,1,1,11,11,11,11,0,0,0,48,45,-8.320327,-1.950038,240.935776,-1.976707,-4.502576,233.235306,-0.295620,2.106168,55.725365,-9.053236,5.072356,306.959991,-5.757654,-4.375921,150.885162,-3.502567,3.105830,279.904449,3.017201,-3.211424,180.699570,0,0,0,0,0.000000,0.000000,92614073,322277256,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,48,36);
UPDATE Intersections SET lastUpdateTime=543262566, status=3,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92613991,                     intY=322277108,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-10354622,                     ramp23=0,                     ramp45=0,                     ramp67=9699410,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.927260,                     longitude=-117.897480,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=199;
UPDATE Intersections_index SET minY=33.927260,minX=-117.897480,maxY=33.927260,maxX=-117.897480 WHERE Intersections_index.id=199