/*ApVer 1.4.2 (15) DBVer 3.0 Time 542838795*/
INSERT OR REPLACE INTO Ramps VALUES(101,9,'23 (Middle)',0,0,1,0,305.000000,144,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,92587080,322298223,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(101,10,'45 (Middle)',0,0,1,0,210.000000,239,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,92586732,322298334,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(101,11,'67 (Middle)',0,0,1,0,131.000000,318,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,92586748,322298641,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(101,12,'81 (Middle)',0,0,1,0,53.000000,36,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,92587037,322298597,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=542838795, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92586923,                     intY=322298445,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-14548835,                     ramp23=-7209151,                     ramp45=12910417,                     ramp67=9961586,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.939130,                     longitude=-117.915630,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=101;
UPDATE Intersections_index SET minY=33.939130,minX=-117.915630,maxY=33.939130,maxX=-117.915630 WHERE Intersections_index.id=101
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(46008,101,45,0,2,'Detectable yellow truncated domes not provided. |Yellow truncated domes are black not yellow. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(267308,8,1236,101,10,4,344,33.939087,-117.915753,542838819);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(267408,8,1237,101,10,4,233,33.939066,-117.915748,542838932);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(267508,8,1238,101,10,4,233,33.939066,-117.915748,542838936);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(267608,8,1239,101,10,4,233,33.939066,-117.915748,542838939);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(267708,8,1240,101,10,4,233,33.939066,-117.915748,542838942);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(267808,8,1241,101,10,4,326,33.939086,-117.915730,542838969);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(267908,8,1242,101,10,4,326,33.939086,-117.915730,542838974);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268008,8,1243,101,10,4,326,33.939086,-117.915730,542838979);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268108,8,1244,101,10,4,38,33.939082,-117.915750,542838997);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268208,8,1245,101,10,4,38,33.939082,-117.915750,542839001);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268308,8,1246,101,10,2,321,33.939062,-117.915736,542839030);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268408,8,1247,101,10,2,321,33.939062,-117.915736,542839037);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(46108,101,23,0,2,'Yellow truncated domes are black not yellow. |Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268508,8,1248,101,9,2,244,33.939010,-117.915537,542839097);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268608,8,1249,101,9,2,244,33.939010,-117.915537,542839106);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268708,8,1250,101,9,4,209,33.939027,-117.915509,542839202);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268808,8,1251,101,9,4,83,33.939020,-117.915551,542839251);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(268908,8,1252,101,9,4,83,33.939020,-117.915551,542839257);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269008,8,1253,101,9,4,83,33.939020,-117.915551,542839260);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269108,8,1254,101,9,4,182,33.939009,-117.915537,542839305);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269208,8,1255,101,9,4,182,33.939009,-117.915537,542839308);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269308,8,1256,101,9,4,251,33.939009,-117.915541,542839326);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269408,8,1257,101,9,4,251,33.939009,-117.915541,542839330);
INSERT OR REPLACE INTO Ramps VALUES(101,9,'23 (Middle)',0,1521146535,1,1,302.552338,144,0,1,1,11,11,11,11,0,0,0,48,48,-11.137824,1.806357,314.065582,-2.355368,5.830168,309.133942,-9.116582,-5.813529,133.709442,-7.864027,9.641006,33.316887,-8.134678,-8.649168,222.518738,5.043999,0.144216,34.568405,-4.380988,-3.490060,222.118484,0,0,0,0,0.000000,0.000000,92587080,322298223,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(101,10,'45 (Middle)',0,1521146240,1,1,71.111252,239,0,1,1,11,11,11,11,0,0,0,48,47,-6.658107,2.412825,40.009083,-2.892910,4.183761,51.074783,-17.860788,-2.689221,217.629929,-4.632865,6.937029,128.139603,-3.212786,-9.603209,311.880310,1.391265,5.160619,94.223434,-1.869526,-4.688286,348.326508,0,0,0,0,0.000000,0.000000,92586732,322298334,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,47,36);
INSERT OR REPLACE INTO Ramps VALUES(101,11,'67 (Middle)',0,0,1,0,131.000000,318,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,92586748,322298641,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(101,12,'81 (Middle)',0,0,1,0,53.000000,36,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,92587037,322298597,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=542839339, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92586923,                     intY=322298445,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-14548835,                     ramp23=-7209151,                     ramp45=12910417,                     ramp67=9961586,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.939130,                     longitude=-117.915630,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=101;
UPDATE Intersections_index SET minY=33.939130,minX=-117.915630,maxY=33.939130,maxX=-117.915630 WHERE Intersections_index.id=101
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(46208,101,81,0,2,'Yellow truncated domes are black not yellow. |Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269508,8,1258,101,12,7,309,33.939229,-117.915527,542839391);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269608,8,1259,101,12,7,309,33.939229,-117.915527,542839402);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269708,8,1260,101,12,4,153,33.939234,-117.915515,542839451);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269808,8,1261,101,12,4,22,33.939249,-117.915529,542839497);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(269908,8,1262,101,12,4,22,33.939249,-117.915529,542839502);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270008,8,1263,101,12,4,22,33.939249,-117.915529,542839505);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270108,8,1264,101,12,4,22,33.939249,-117.915529,542839509);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270208,8,1265,101,12,4,145,33.939235,-117.915541,542839535);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270308,8,1266,101,12,4,145,33.939235,-117.915541,542839538);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270408,8,1267,101,12,4,225,33.939236,-117.915523,542839555);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270508,8,1268,101,12,4,225,33.939236,-117.915523,542839558);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270608,8,1269,101,12,2,63,33.939275,-117.915517,542839573);
INSERT OR REPLACE INTO Ramps VALUES(101,9,'23 (Middle)',0,1521146535,1,1,302.552338,144,0,1,1,11,11,11,11,0,0,0,48,48,-11.137824,1.806357,314.065582,-2.355368,5.830168,309.133942,-9.116582,-5.813529,133.709442,-7.864027,9.641006,33.316887,-8.134678,-8.649168,222.518738,5.043999,0.144216,34.568405,-4.380988,-3.490060,222.118484,0,0,0,0,0.000000,0.000000,92587080,322298223,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(101,10,'45 (Middle)',0,1521146240,1,1,71.111252,239,0,1,1,11,11,11,11,0,0,0,48,47,-6.658107,2.412825,40.009083,-2.892910,4.183761,51.074783,-17.860788,-2.689221,217.629929,-4.632865,6.937029,128.139603,-3.212786,-9.603209,311.880310,1.391265,5.160619,94.223434,-1.869526,-4.688286,348.326508,0,0,0,0,0.000000,0.000000,92586732,322298334,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,47,36);
INSERT OR REPLACE INTO Ramps VALUES(101,11,'67 (Middle)',0,0,1,0,131.000000,318,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,92586748,322298641,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(101,12,'81 (Middle)',0,1521146871,1,1,222.701187,36,0,1,1,11,11,11,11,0,0,0,48,61,-13.940829,2.834703,221.435638,-4.054630,5.608297,229.874359,-1.074170,-3.293647,43.912041,-9.610935,9.327826,309.356506,-10.663161,-9.114891,142.618973,-9998.000000,-9998.000000,-9998.000000,-5.342899,-6.012568,158.314972,0,0,0,0,0.000000,0.000000,92587037,322298597,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2.000000,0.000000,0.000000,0.000000,48,37);
UPDATE Intersections SET lastUpdateTime=542839674, status=3,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92586923,                     intY=322298445,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-14548835,                     ramp23=-7209151,                     ramp45=12910417,                     ramp67=9961586,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.939130,                     longitude=-117.915630,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=101;
UPDATE Intersections_index SET minY=33.939130,minX=-117.915630,maxY=33.939130,maxX=-117.915630 WHERE Intersections_index.id=101
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(46308,101,67,0,2,'Yellow truncated domes are black not yellow. |Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270708,8,1270,101,11,2,319,33.939252,-117.915769,542839806);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270808,8,1271,101,11,2,319,33.939252,-117.915769,542839816);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(270908,8,1272,101,11,4,28,33.939211,-117.915774,542839828);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(271008,8,1273,101,11,4,342,33.939228,-117.915781,542839863);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(271108,8,1274,101,11,4,342,33.939228,-117.915781,542839869);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(271208,8,1275,101,11,4,342,33.939228,-117.915781,542839873);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(271308,8,1276,101,11,4,13,33.939230,-117.915782,542839910);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(271408,8,1277,101,11,4,13,33.939230,-117.915782,542839914);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(271508,8,1278,101,11,4,124,33.939236,-117.915763,542839939);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(271608,8,1279,101,11,4,124,33.939236,-117.915763,542839943);
INSERT OR REPLACE INTO Ramps VALUES(101,9,'23 (Middle)',0,1521146535,1,1,302.552338,144,0,1,1,11,11,11,11,0,0,0,48,48,-11.137824,1.806357,314.065582,-2.355368,5.830168,309.133942,-9.116582,-5.813529,133.709442,-7.864027,9.641006,33.316887,-8.134678,-8.649168,222.518738,5.043999,0.144216,34.568405,-4.380988,-3.490060,222.118484,0,0,0,0,0.000000,0.000000,92587080,322298223,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(101,10,'45 (Middle)',0,1521146240,1,1,71.111252,239,0,1,1,11,11,11,11,0,0,0,48,47,-6.658107,2.412825,40.009083,-2.892910,4.183761,51.074783,-17.860788,-2.689221,217.629929,-4.632865,6.937029,128.139603,-3.212786,-9.603209,311.880310,1.391265,5.160619,94.223434,-1.869526,-4.688286,348.326508,0,0,0,0,0.000000,0.000000,92586732,322298334,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,47,36);
INSERT OR REPLACE INTO Ramps VALUES(101,11,'67 (Middle)',0,1521147184,1,1,117.844177,318,0,1,1,11,11,11,11,0,0,0,75,48,-5.129268,-7.359244,133.173203,-5.809191,-8.645352,140.821564,-5.177063,9.238347,313.681732,-14.490296,0.206120,181.896713,5.391088,-8.372966,58.457973,-9.578831,-3.316038,173.784668,9.240922,-3.290876,82.304329,0,0,0,0,0.000000,0.000000,92586748,322298641,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,75,46);
INSERT OR REPLACE INTO Ramps VALUES(101,12,'81 (Middle)',0,1521146871,1,1,222.701187,36,0,1,1,11,11,11,11,0,0,0,48,61,-13.940829,2.834703,221.435638,-4.054630,5.608297,229.874359,-1.074170,-3.293647,43.912041,-9.610935,9.327826,309.356506,-10.663161,-9.114891,142.618973,-9998.000000,-9998.000000,-9998.000000,-5.342899,-6.012568,158.314972,0,0,0,0,0.000000,0.000000,92587037,322298597,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,2.000000,0.000000,0.000000,0.000000,48,37);
UPDATE Intersections SET lastUpdateTime=542839986, status=3,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92586923,                     intY=322298445,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-14548835,                     ramp23=-7209151,                     ramp45=12910417,                     ramp67=9961586,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.939130,                     longitude=-117.915630,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=101;
UPDATE Intersections_index SET minY=33.939130,minX=-117.915630,maxY=33.939130,maxX=-117.915630 WHERE Intersections_index.id=101