/*ApVer 1.4.2 (15) DBVer 3.0 Time 542239409*/
INSERT OR REPLACE INTO Ramps VALUES(405,9,'23 (Middle)',0,0,1,0,275.000000,174,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,92621826,322292896,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(405,10,'45 (Middle)',0,0,1,0,197.000000,252,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,92621570,322293030,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(405,11,'67 (Middle)',0,0,1,0,113.000000,336,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,92621685,322293379,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(405,12,'81 (Middle)',0,0,1,0,39.000000,50,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,92621972,322293244,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=542239409, status=0,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92621805,                     intY=322293105,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-13697003,                     ramp23=-4849899,                     ramp45=18022280,                     ramp67=9109671,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.936160,                     longitude=-117.892240,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=405;
UPDATE Intersections_index SET minY=33.936160,minX=-117.892240,maxY=33.936160,maxX=-117.892240 WHERE Intersections_index.id=405
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(118604,4,403,405,12,7,338,33.936207,-117.892183,542239484);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(118704,4,404,405,12,7,338,33.936207,-117.892183,542239505);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(118804,4,405,405,12,7,252,33.936219,-117.892172,542239522);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(118904,4,406,405,12,4,220,33.936215,-117.892190,542239535);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119004,4,407,405,12,5,139,33.936190,-117.892149,542239597);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119104,4,408,405,12,2,291,33.936172,-117.892198,542239613);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119204,4,409,405,12,2,291,33.936172,-117.892198,542239620);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(26104,405,81,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(26204,405,67,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119304,4,410,405,11,7,280,33.936283,-117.892246,542239703);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119404,4,411,405,11,7,168,33.936292,-117.892268,542239720);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119504,4,412,405,11,7,168,33.936292,-117.892268,542239728);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119604,4,413,405,11,7,6,33.936285,-117.892242,542239749);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119704,4,414,405,11,7,121,33.936258,-117.892274,542239777);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119804,4,415,405,11,4,126,33.936263,-117.892266,542239786);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(119904,4,416,405,11,2,260,33.936268,-117.892295,542239845);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(26304,405,45,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120004,4,417,405,10,7,318,33.936118,-117.892416,542239956);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120104,4,418,405,10,7,132,33.936136,-117.892460,542239981);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120204,4,419,405,10,7,132,33.936136,-117.892460,542239985);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120304,4,420,405,10,4,200,33.936127,-117.892385,542240000);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120404,4,421,405,10,6,335,33.936080,-117.892415,542240071);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120504,4,422,405,10,2,345,33.936075,-117.892416,542240091);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120604,4,423,405,10,2,345,33.936075,-117.892416,542240098);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(26404,405,23,0,2,'Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120704,4,424,405,9,7,160,33.936092,-117.892226,542240172);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120804,4,425,405,9,4,260,33.936067,-117.892229,542240195);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(120904,4,426,405,9,2,298,33.936079,-117.892212,542240264);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(121004,4,427,405,9,2,298,33.936079,-117.892212,542240270);
INSERT OR REPLACE INTO Ramps VALUES(405,9,'23 (Middle)',0,1520547472,1,1,348.918457,174,0,1,1,11,11,11,11,0,1,1,60,50,0.000000,0.000000,0.000000,-1.420397,12.312521,351.646301,-0.666720,-14.467396,171.247879,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,3.563217,0.234555,58.761501,-23.644812,-1.226293,270.200653,0,0,0,0,0.000000,0.000000,92621826,322292896,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.500000,0.400000,0.000000,0.000000,0.000000,0.000000,0.000000,60,36);
INSERT OR REPLACE INTO Ramps VALUES(405,10,'45 (Middle)',0,1520547300,1,1,73.039612,252,0,1,1,11,11,11,11,1,1,1,60,80,0.000000,0.000000,0.000000,-5.812357,11.911640,72.074310,-7.653335,-13.738445,255.068375,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,5.308260,6.628464,151.802368,-10.464366,-4.928648,5.751820,0,0,0,0,0.500000,0.000000,92621570,322293030,6,'',0,0,0,0,0,0.000000,0.000000,0.500000,0.500000,3.000000,0.000000,0.000000,0.000000,0.000000,0.000000,60,36);
INSERT OR REPLACE INTO Ramps VALUES(405,11,'67 (Middle)',0,1520547046,1,1,160.676987,336,0,1,1,11,11,11,11,0,0,1,48,99,0.000000,0.000000,0.000000,0.332421,-6.660245,157.896576,-6.697720,9.133619,340.251099,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-17.922386,-4.681236,234.380447,0.586923,-2.187485,84.445198,0,0,0,0,0.000000,0.000000,92621685,322293379,6,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.500000,0.900000,3.000000,0.300000,0.000000,0.000000,0.000000,48,37);
INSERT OR REPLACE INTO Ramps VALUES(405,12,'81 (Middle)',0,1520546823,1,1,257.081390,50,0,1,1,11,11,11,3,0,0,1,48,100,0.000000,0.000000,0.000000,-0.715688,-2.767405,253.315781,7.625440,1.588209,83.874420,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-12.602805,0.207511,324.487518,-6.173364,-2.794967,181.674957,0,0,0,0,0.000000,0.000000,92621972,322293244,6,'',0,0,0,0,0,0.000000,0.000000,1.000000,0.000000,0.400000,0.000000,0.000000,0.000000,0.000000,0.000000,48,36);
UPDATE Intersections SET lastUpdateTime=542240276, status=3,                     assignedToPrelim=0,                     assignedToDetail=0,                     intX=92621805,                     intY=322293105,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-13697003,                     ramp23=-4849899,                     ramp45=18022280,                     ramp67=9109671,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.936160,                     longitude=-117.892240,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=405;
UPDATE Intersections_index SET minY=33.936160,minX=-117.892240,maxY=33.936160,maxX=-117.892240 WHERE Intersections_index.id=405
DELETE FROM Intersections WHERE intID = 1184;DELETE FROM Intersections_index WHERE id = 1184