/*ApVer 1.4.2 (15) DBVer 3.0 Time 542310972*/
INSERT OR REPLACE INTO Ramps VALUES(77,2,'2(Right)',0,0,1,0,290.000000,159,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,92608689,322263953,4,'',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(77,7,'7(Left)',0,0,1,0,130.000000,319,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,92608505,322264250,4,'',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(77,8,'8(Right)',0,0,1,0,17.000000,72,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,92608771,322264139,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(77,10,'45 (Middle)',0,0,1,0,199.000000,250,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,92608393,322264008,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);
UPDATE Intersections SET lastUpdateTime=542310972, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92608636,                     intY=322264096,                     ramp1=0,                     ramp2=-9371595,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=10157949,                     ramp8=2818183,                     ramp81=0,                     ramp23=-5701875,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920020,                     longitude=-117.901070,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=77;
UPDATE Intersections_index SET minY=33.920020,minX=-117.901070,maxY=33.920020,maxX=-117.901070 WHERE Intersections_index.id=77
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134104,4,558,77,10,7,121,33.920010,-117.901260,542311072);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134204,4,559,77,10,4,131,33.919999,-117.901256,542311092);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134304,4,560,77,10,2,306,33.919980,-117.901235,542311132);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134404,4,561,77,10,2,306,33.919980,-117.901235,542311136);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29004,77,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO Ramps VALUES(77,2,'2(Right)',0,0,1,0,290.000000,159,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,92608689,322263953,4,'',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=77 AND rampNum = 7
INSERT OR REPLACE INTO Ramps VALUES(77,8,'8(Right)',0,0,1,0,17.000000,72,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,92608771,322264139,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(77,10,'45 (Middle)',0,1520618339,1,1,65.145126,250,0,1,1,10,11,11,11,1,0,0,62,44,0.000000,0.000000,0.000000,-3.076583,-2.724515,72.083771,-8.701600,2.576668,250.035019,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-3.643211,0.520242,140.597275,-6.968389,-7.212362,356.201599,0,0,0,0,0.000000,0.000000,92608393,322264008,6,'',0,0,0,0,0,0.000000,0.000000,0.500000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(77,11,'67 (Middle)',0,0,1,0,122.000000,319,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,92608505,322264250,4,'',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=542311243, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92608636,                     intY=322264096,                     ramp1=0,                     ramp2=-9371595,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=2818183,                     ramp81=0,                     ramp23=-5701875,                     ramp45=10157949,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920020,                     longitude=-117.901070,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=77;
UPDATE Intersections_index SET minY=33.920020,minX=-117.901070,maxY=33.920020,maxX=-117.901070 WHERE Intersections_index.id=77
INSERT OR REPLACE INTO Ramps VALUES(77,2,'2(Right)',0,0,1,0,290.000000,159,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,92608689,322263953,4,'',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(77,6,'6(Right)',0,0,1,0,122.000000,319,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,92608505,322264250,4,'',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(77,8,'8(Right)',0,0,1,0,17.000000,72,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,92608771,322264139,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(77,10,'45 (Middle)',0,1520618339,1,1,65.145126,250,0,1,1,10,11,11,11,1,0,0,62,44,0.000000,0.000000,0.000000,-3.076583,-2.724515,72.083771,-8.701600,2.576668,250.035019,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-3.643211,0.520242,140.597275,-6.968389,-7.212362,356.201599,0,0,0,0,0.000000,0.000000,92608393,322264008,6,'',0,0,0,0,0,0.000000,0.000000,0.500000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
Delete FROM ramps WHERE intID=77 AND rampNum = 11
UPDATE Intersections SET lastUpdateTime=542311251, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92608636,                     intY=322264096,                     ramp1=0,                     ramp2=-9371595,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=10157949,                     ramp7=0,                     ramp8=2818183,                     ramp81=0,                     ramp23=-5701875,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920020,                     longitude=-117.901070,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=77;
UPDATE Intersections_index SET minY=33.920020,minX=-117.901070,maxY=33.920020,maxX=-117.901070 WHERE Intersections_index.id=77
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29104,77,67,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134504,4,562,77,6,7,40,33.920118,-117.901177,542311411);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134604,4,563,77,6,7,183,33.920137,-117.901169,542311421);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134704,4,564,77,6,7,145,33.920115,-117.901168,542311432);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134804,4,565,77,6,4,174,33.920107,-117.901190,542311444);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(134904,4,566,77,6,6,228,33.920120,-117.901147,542311473);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135004,4,567,77,6,2,292,33.920113,-117.901150,542311490);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135104,4,568,77,8,7,188,33.920092,-117.901027,542311648);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135204,4,569,77,8,7,155,33.920086,-117.901024,542311660);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135304,4,570,77,8,4,212,33.920088,-117.900996,542311673);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135404,4,571,77,8,6,113,33.920100,-117.901001,542311707);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135504,4,572,77,8,2,116,33.920116,-117.901002,542311726);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29204,77,81,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135604,4,573,77,2,7,4,33.919951,-117.901094,542311843);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135704,4,574,77,2,7,14,33.919944,-117.901094,542311853);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135804,4,575,77,2,4,342,33.919944,-117.901094,542311865);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(135904,4,576,77,2,6,229,33.919981,-117.901085,542311899);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136004,4,577,77,2,2,152,33.919972,-117.901103,542311916);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(136104,4,578,77,2,2,152,33.919972,-117.901103,542311922);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(29304,77,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO Ramps VALUES(77,2,'2(Right)',0,1520619124,1,1,26.000000,159,0,1,1,12,11,11,11,1,1,0,60,100,-6.482789,3.110674,20.302826,-2.339570,1.525668,23.034304,-9.527517,-1.864507,157.593445,-5.245001,3.746798,53.285988,-9998.000000,-9998.000000,-9998.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0,0,0,0.000000,0.500000,92608689,322263953,4,'',0,0,0,0,0,0.000000,0.000000,0.400000,0.500000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(77,6,'6(Right)',0,1520618697,1,1,224.000000,319,0,1,1,12,11,11,11,1,1,1,60,90,-6.634628,1.830386,204.833893,-0.012538,1.155612,207.158783,-10.046797,-4.010517,332.955780,-5.848703,4.043476,235.244354,-9998.000000,-9998.000000,-9998.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0,0,0,0.000000,0.500000,92608505,322264250,4,'',0,0,0,0,0,0.000000,0.000000,0.400000,0.500000,0.400000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(77,8,'8(Right)',0,1520618928,1,1,281.000000,72,0,1,1,12,11,11,11,1,0,1,75,47,0.000000,0.000000,0.000000,-3.228278,-3.485965,242.783188,-12.475480,-0.857850,69.856194,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-9.145647,4.411831,321.404663,-6.020422,-9.032502,172.386063,0,0,0,0,0.000000,0.500000,92608771,322264139,6,'',0,0,0,0,0,0.000000,0.000000,0.500000,0.000000,0.400000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(77,10,'45 (Middle)',0,1520618339,1,1,65.145126,250,0,1,1,10,11,11,11,1,0,0,62,44,0.000000,0.000000,0.000000,-3.076583,-2.724515,72.083771,-8.701600,2.576668,250.035019,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-3.643211,0.520242,140.597275,-6.968389,-7.212362,356.201599,0,0,0,0,0.000000,0.000000,92608393,322264008,6,'',0,0,0,0,0,0.000000,0.000000,0.500000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
UPDATE Intersections SET lastUpdateTime=542311928, status=3,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92608636,                     intY=322264096,                     ramp1=0,                     ramp2=-9371595,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=10157949,                     ramp7=0,                     ramp8=2818183,                     ramp81=0,                     ramp23=-5701875,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920020,                     longitude=-117.901070,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=77;
UPDATE Intersections_index SET minY=33.920020,minX=-117.901070,maxY=33.920020,maxX=-117.901070 WHERE Intersections_index.id=77
DELETE FROM Intersections WHERE intID = 82;DELETE FROM Intersections_index WHERE id = 82
DELETE FROM Intersections WHERE intID = 1306;DELETE FROM Intersections_index WHERE id = 1306