/*ApVer 1.4.2 (15) DBVer 3.0 Time 542764662*/
INSERT OR REPLACE INTO Ramps VALUES(4,9,'23 (Middle)',0,0,1,0,310.000000,139,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,92584333,322311562,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(4,10,'45 (Middle)',0,0,1,0,207.000000,242,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,92584007,322311552,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=542764662, status=0,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92584238,                     intY=322311674,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-7339937,                     ramp23=-7930087,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.946490,                     longitude=-117.917431,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=4;
UPDATE Intersections_index SET minY=33.946490,minX=-117.917431,maxY=33.946490,maxX=-117.917431 WHERE Intersections_index.id=4
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(41508,4,45,0,2,'Yellow truncated domes are black not yellow. |Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(234808,8,911,4,10,4,149,33.946429,-117.917575,542764779);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(234908,8,912,4,10,4,247,33.946436,-117.917548,542764801);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235008,8,913,4,10,4,247,33.946436,-117.917548,542764805);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235108,8,914,4,10,4,247,33.946436,-117.917548,542764809);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235208,8,915,4,10,4,247,33.946436,-117.917548,542764812);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235308,8,916,4,10,4,247,33.946436,-117.917548,542764815);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235408,8,917,4,10,4,64,33.946420,-117.917559,542764850);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235508,8,918,4,10,4,64,33.946420,-117.917559,542764853);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235608,8,919,4,10,4,44,33.946420,-117.917578,542764867);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235708,8,920,4,10,4,44,33.946420,-117.917578,542764869);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235808,8,921,4,10,2,270,33.946398,-117.917570,542764881);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(235908,8,922,4,10,2,270,33.946398,-117.917570,542764890);
INSERT OR REPLACE INTO CURBRAMP_NOTES VALUES(41608,4,23,0,2,'Yellow truncated domes are black not yellow. |Detectable yellow truncated domes not provided. ');
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236008,8,923,4,9,4,153,33.946453,-117.917359,542765021);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236108,8,924,4,9,4,193,33.946451,-117.917345,542765045);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236208,8,925,4,9,4,193,33.946451,-117.917345,542765048);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236308,8,926,4,9,4,193,33.946451,-117.917345,542765051);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236408,8,927,4,9,4,171,33.946429,-117.917357,542765078);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236508,8,928,4,9,4,171,33.946429,-117.917357,542765082);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236608,8,929,4,9,4,118,33.946445,-117.917361,542765095);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236708,8,930,4,9,4,118,33.946445,-117.917361,542765098);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236808,8,931,4,9,4,118,33.946445,-117.917361,542765102);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(236908,8,932,4,9,4,118,33.946445,-117.917361,542765106);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(237008,8,933,4,9,4,118,33.946445,-117.917361,542765110);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(237108,8,934,4,9,2,92,33.946436,-117.917354,542765127);
INSERT OR REPLACE INTO CURBRAMP_PICTURES VALUES(237208,8,935,4,9,2,92,33.946436,-117.917354,542765136);
INSERT OR REPLACE INTO Ramps VALUES(4,9,'23 (Middle)',0,1521072338,1,1,315.083069,139,0,1,1,11,11,11,11,0,0,0,60,30,-0.956522,1.268287,320.338837,-2.034276,2.596533,322.624146,-7.539880,-1.275433,147.989609,1.386930,2.553817,47.575005,-7.660627,0.992267,244.737671,8.348753,3.223458,24.854025,-2.284617,-3.388423,284.295990,0,0,0,0,0.000000,0.000000,92584333,322311562,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,60,36);
INSERT OR REPLACE INTO Ramps VALUES(4,10,'45 (Middle)',0,1521072092,1,1,66.763710,242,0,1,1,11,11,11,11,0,0,0,60,39,-3.577953,-4.273777,58.513584,-1.399357,-7.140199,59.486725,-6.266312,3.870360,236.839371,-7.570196,0.273007,130.117096,-9998.000000,-9998.000000,-9998.000000,-1.408540,1.711261,111.904709,2.422268,-2.491573,353.789307,0,0,0,0,0.000000,0.000000,92584007,322311552,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,60,36);
UPDATE Intersections SET lastUpdateTime=542765142, status=3,                     assignedToPrelim=0,                     assignedToDetail=8,                     intX=92584238,                     intY=322311674,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-7339937,                     ramp23=-7930087,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.946490,                     longitude=-117.917431,                     zoomLevel=0,                     doLater=0,                     intersectionComment=''                      WHERE intID=4;
UPDATE Intersections_index SET minY=33.946490,minX=-117.917431,maxY=33.946490,maxX=-117.917431 WHERE Intersections_index.id=4