/*ApVer 1.4.2 (15) DBVer 3.0 Time 542146259*/
INSERT OR REPLACE INTO Ramps VALUES(872,9,'23 (Middle)',0,0,1,0,319.000000,130,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,92632914,322275706,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(872,10,'45 (Middle)',0,0,1,0,202.000000,247,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,92632607,322275711,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(872,11,'67 (Middle)',0,0,1,0,137.000000,312,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,92632597,322275994,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(872,12,'81 (Middle)',0,0,1,0,66.000000,23,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,92632898,322275994,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=542146259, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92632811,                     intY=322275796,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-5898137,                     ramp23=-5505228,                     ramp45=13041450,                     ramp67=12976215,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.926530,                     longitude=-117.884860,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=872;
UPDATE Intersections_index SET minY=33.926530,minX=-117.884860,maxY=33.926530,maxX=-117.884860 WHERE Intersections_index.id=872
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(22704,872,81,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(101804,4,235,872,12,4,145,33.926662,-117.884790,542146349);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(101904,4,236,872,12,2,62,33.926651,-117.884786,542146397);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102004,4,237,872,12,2,62,33.926651,-117.884786,542146417);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102104,4,238,872,11,4,195,33.926660,-117.885001,542146596);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102204,4,239,872,11,2,316,33.926642,-117.885003,542146647);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102304,4,240,872,11,2,316,33.926642,-117.885003,542146653);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(22804,872,67,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(22904,872,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102404,4,241,872,10,7,44,33.926477,-117.885024,542146777);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102504,4,242,872,10,4,81,33.926480,-117.885018,542146788);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102604,4,243,872,10,2,283,33.926509,-117.885019,542146831);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102704,4,244,872,10,2,283,33.926509,-117.885019,542146838);
INSERT OR REPLACE INTO Ramps VALUES(872,9,'23 (Middle)',0,0,1,0,319.000000,130,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,92632914,322275706,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(872,10,'45 (Middle)',0,1520454051,1,1,39.406364,247,0,1,1,11,11,11,11,1,0,0,48,47,-6.827213,-3.035290,43.010899,-0.196074,-1.887587,41.925907,-3.797736,0.670312,221.644684,-8.458854,4.781378,117.287361,-3.508801,-5.672323,333.700836,-7.743337,-1.187995,112.278046,-0.235147,-2.361857,336.025360,0,0,0,0,0.000000,0.000000,92632607,322275711,10,'',0,0,0,0,0,0.000000,0.000000,0.100000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
INSERT OR REPLACE INTO Ramps VALUES(872,11,'67 (Middle)',0,1520453863,1,1,129.923523,312,0,1,1,11,11,11,11,0,0,0,48,46,-3.420284,-5.541118,127.784645,-1.949853,-5.317441,126.157021,-5.779020,6.119670,313.196960,-14.635264,7.223249,217.311340,-2.115621,-6.803816,56.639896,-18.674164,-1.324122,195.843155,4.704985,-4.086313,55.708847,0,0,0,0,0.000000,0.000000,92632597,322275994,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(872,12,'81 (Middle)',0,1520453619,1,1,209.496841,23,0,1,1,11,11,11,11,0,0,0,48,48,-6.686873,1.955314,208.873886,-0.793560,0.001998,211.314453,-5.672868,-3.643641,34.509289,-4.897740,6.828322,288.782501,-8.535032,-5.077969,137.326340,-1.047815,3.160431,280.053558,-9.587237,-2.281745,142.439743,0,0,0,0,0.000000,0.000000,92632898,322275994,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=542146855, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92632811,                     intY=322275796,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-5898137,                     ramp23=-5505228,                     ramp45=13041450,                     ramp67=12976215,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.926530,                     longitude=-117.884860,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=872;
UPDATE Intersections_index SET minY=33.926530,minX=-117.884860,maxY=33.926530,maxX=-117.884860 WHERE Intersections_index.id=872
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102804,4,245,872,9,4,1,33.926499,-117.884816,542146933);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(102904,4,246,872,9,7,342,33.926489,-117.884786,542146952);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(103004,4,247,872,9,7,342,33.926489,-117.884786,542146957);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(103104,4,248,872,9,7,342,33.926489,-117.884786,542146961);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(103204,4,249,872,9,2,197,33.926466,-117.884770,542147017);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(103304,4,250,872,9,2,197,33.926466,-117.884770,542147029);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(23004,872,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO Ramps VALUES(872,9,'23 (Middle)',0,1520454230,1,1,324.272095,130,0,1,1,11,11,11,11,0,0,1,48,38,0.000000,0.000000,0.000000,0.093537,3.109271,321.906647,-6.376745,-4.779994,143.354599,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-0.085019,-0.456447,33.727650,-7.269743,-5.333035,249.639862,0,0,0,0,0.000000,0.000000,92632914,322275706,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.800000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
INSERT OR REPLACE INTO Ramps VALUES(872,10,'45 (Middle)',0,1520454051,1,1,39.406364,247,0,1,1,11,11,11,11,1,0,0,48,47,-6.827213,-3.035290,43.010899,-0.196074,-1.887587,41.925907,-3.797736,0.670312,221.644684,-8.458854,4.781378,117.287361,-3.508801,-5.672323,333.700836,-7.743337,-1.187995,112.278046,-0.235147,-2.361857,336.025360,0,0,0,0,0.000000,0.000000,92632607,322275711,10,'',0,0,0,0,0,0.000000,0.000000,0.100000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
INSERT OR REPLACE INTO Ramps VALUES(872,11,'67 (Middle)',0,1520453863,1,1,129.923523,312,0,1,1,11,11,11,11,0,0,0,48,46,-3.420284,-5.541118,127.784645,-1.949853,-5.317441,126.157021,-5.779020,6.119670,313.196960,-14.635264,7.223249,217.311340,-2.115621,-6.803816,56.639896,-18.674164,-1.324122,195.843155,4.704985,-4.086313,55.708847,0,0,0,0,0.000000,0.000000,92632597,322275994,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(872,12,'81 (Middle)',0,1520453619,1,1,209.496841,23,0,1,1,11,11,11,11,0,0,0,48,48,-6.686873,1.955314,208.873886,-0.793560,0.001998,211.314453,-5.672868,-3.643641,34.509289,-4.897740,6.828322,288.782501,-8.535032,-5.077969,137.326340,-1.047815,3.160431,280.053558,-9.587237,-2.281745,142.439743,0,0,0,0,0.000000,0.000000,92632898,322275994,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=542147035, status=3,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92632811,                     intY=322275796,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-5898137,                     ramp23=-5505228,                     ramp45=13041450,                     ramp67=12976215,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.926530,                     longitude=-117.884860,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=872;
UPDATE Intersections_index SET minY=33.926530,minX=-117.884860,maxY=33.926530,maxX=-117.884860 WHERE Intersections_index.id=872
DELETE FROM Intersections WHERE intID = 146;DELETE FROM Intersections_index WHERE id = 146
DELETE FROM Intersections WHERE intID = 1455;DELETE FROM Intersections_index WHERE id = 1455