/*ApVer 1.4.2 (15) DBVer 3.0 Time 542738932*/
INSERT OR REPLACE INTO Ramps VALUES(1605,6,'6(Right)',0,1520447780,1,1,179.000000,350,0,1,1,12,11,11,11,0,0,0,44,48,-11.126318,-1.713347,177.681076,-1.103972,0.964728,181.859802,3.490952,0.104169,358.686615,-6.252986,6.450700,264.288422,-5.367698,-5.773390,94.614365,0.735419,2.353042,265.651550,-1.482516,-4.683296,95.644531,0,0,0,0,0.000000,0.500000,92675949,322265094,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,0);
INSERT OR REPLACE INTO Ramps VALUES(1605,8,'8(Right)',0,1520447563,1,1,299.000000,62,0,1,1,12,11,11,11,0,0,0,48,47,-8.495929,1.122187,273.144928,-0.529902,2.334462,278.533508,-9.347213,-2.525903,100.163635,-5.672204,5.038293,10.257807,-11.934704,-9.035890,188.492096,2.833327,-0.282907,4.199449,-3.281091,-2.228271,186.286621,0,0,0,0,0.000000,0.500000,92676125,322264901,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,0);
UPDATE Intersections SET lastUpdateTime=542738932, status=2,                     assignedToPrelim=1,                     assignedToDetail=0,                     intX=92675995,                     intY=322264833,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=17170386,                     ramp7=0,                     ramp8=4456578,                     ramp81=0,                     ramp23=0,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.920430,                     longitude=-117.855903,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=1605;
UPDATE Intersections_index SET minY=33.920430,minX=-117.855903,maxY=33.920430,maxX=-117.855903 WHERE Intersections_index.id=1605
UPDATE Intersections SET lastUpdateTime=542738935, status=2,                     assignedToPrelim=1,                     assignedToDetail=3,                     intX=92679206,                     intY=322261059,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=0,                     ramp23=0,                     ramp45=0,                     ramp67=0,                     xWalkA=0,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.918330,                     longitude=-117.853750,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=1218;
UPDATE Intersections_index SET minY=33.918330,minX=-117.853750,maxY=33.918330,maxX=-117.853750 WHERE Intersections_index.id=1218
UPDATE Intersections SET lastUpdateTime=542738954, assignedToDetail=1 WHERE intID=50
UPDATE Intersections SET lastUpdateTime=542738955, assignedToDetail=1 WHERE intID=1705
UPDATE Intersections SET lastUpdateTime=542738957, assignedToDetail=0 WHERE intID=1705
UPDATE Intersections SET lastUpdateTime=542738958, assignedToDetail=0 WHERE intID=50
UPDATE Intersections SET lastUpdateTime=542738960, assignedToDetail=3 WHERE intID=1705
UPDATE Intersections SET lastUpdateTime=542738960, assignedToDetail=3 WHERE intID=50
UPDATE Intersections SET lastUpdateTime=542738961, assignedToDetail=3 WHERE intID=51
UPDATE Intersections SET lastUpdateTime=542738962, assignedToDetail=3 WHERE intID=1345
UPDATE Intersections SET lastUpdateTime=542738963, assignedToDetail=3 WHERE intID=1466
UPDATE Intersections SET lastUpdateTime=542738963, assignedToDetail=3 WHERE intID=261
UPDATE Intersections SET lastUpdateTime=542738964, assignedToDetail=3 WHERE intID=920
UPDATE Intersections SET lastUpdateTime=542738964, assignedToDetail=3 WHERE intID=918
UPDATE Intersections SET lastUpdateTime=542738965, assignedToDetail=3 WHERE intID=1605
UPDATE Intersections SET lastUpdateTime=542738990, assignedToDetail=3 WHERE intID=513
UPDATE Intersections SET lastUpdateTime=542738991, assignedToDetail=3 WHERE intID=571
UPDATE Intersections SET lastUpdateTime=542738991, assignedToDetail=3 WHERE intID=514
UPDATE Intersections SET lastUpdateTime=542738992, assignedToDetail=3 WHERE intID=515
UPDATE Intersections SET lastUpdateTime=542738993, assignedToDetail=3 WHERE intID=625
UPDATE Intersections SET lastUpdateTime=542738993, assignedToDetail=3 WHERE intID=229
UPDATE Intersections SET lastUpdateTime=542738994, assignedToDetail=3 WHERE intID=565
UPDATE Intersections SET lastUpdateTime=542738995, assignedToDetail=3 WHERE intID=829
UPDATE Intersections SET lastUpdateTime=542738996, assignedToDetail=3 WHERE intID=516
UPDATE Intersections SET lastUpdateTime=542738996, assignedToDetail=3 WHERE intID=563
UPDATE Intersections SET lastUpdateTime=542738997, assignedToDetail=3 WHERE intID=561
UPDATE Intersections SET lastUpdateTime=542738998, assignedToDetail=3 WHERE intID=562
UPDATE Intersections SET lastUpdateTime=542738998, assignedToDetail=3 WHERE intID=517
UPDATE Intersections SET lastUpdateTime=542738999, assignedToDetail=3 WHERE intID=118
UPDATE Intersections SET lastUpdateTime=542739000, assignedToDetail=3 WHERE intID=442
UPDATE Intersections SET lastUpdateTime=542739000, assignedToDetail=3 WHERE intID=894
UPDATE Intersections SET lastUpdateTime=542739001, assignedToDetail=3 WHERE intID=1468
UPDATE Intersections SET lastUpdateTime=542739002, assignedToDetail=3 WHERE intID=1386
UPDATE Intersections SET lastUpdateTime=542739002, assignedToDetail=3 WHERE intID=1178
UPDATE Intersections SET lastUpdateTime=542739003, assignedToDetail=3 WHERE intID=1312
UPDATE Intersections SET lastUpdateTime=542739011, assignedToDetail=0 WHERE intID=1312
UPDATE Intersections SET lastUpdateTime=542739012, assignedToDetail=3 WHERE intID=235
UPDATE Intersections SET lastUpdateTime=542739013, assignedToDetail=3 WHERE intID=1177
INSERT OR REPLACE INTO Ramps VALUES(592,1,'1(Left)',0,0,0,1,0.000000,0,1,1,0,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,2,4,40,140,0.000000,0.000000,0,0,0,'',2,1,1,1,1,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(592,2,'2(Right)',0,0,0,1,0.000000,0,1,1,0,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,2,4,40,114,0.000000,0.000000,0,0,0,'',1,1,1,1,1,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(592,3,'3(Left)',0,0,0,1,0.000000,0,1,1,0,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,2,4,39,150,0.000000,0.000000,0,0,0,'',1,1,1,1,1,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(592,4,'4(Right)',0,0,0,1,0.000000,0,1,1,0,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,2,4,41,55,0.000000,0.000000,0,0,0,'',1,1,1,1,1,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(592,5,'5(Left)',0,0,0,1,0.000000,0,1,1,0,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,2,4,39,144,0.000000,0.000000,0,0,0,'',2,1,1,1,1,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(592,6,'6(Right)',0,0,0,1,0.000000,0,1,1,0,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,2,4,38,89,0.000000,0.000000,0,0,0,'',1,1,1,1,1,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(592,7,'7(Left)',0,0,0,1,0.000000,0,1,1,0,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,2,4,39,38,0.000000,0.000000,0,0,0,'',1,1,1,1,1,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(592,8,'8(Right)',0,0,0,1,0.000000,0,1,1,0,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,2,4,40,139,0.000000,0.000000,0,0,0,'',2,1,1,1,1,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(592,9,'23 (Middle)',0,1519673780,1,1,337.780670,148,0,1,1,2,11,11,11,0,0,0,48,52,-7.676699,1.513222,346.931824,-3.448311,1.524185,347.962738,3.699284,-2.630470,163.430222,-4.216130,3.377718,62.431499,-8.133626,-4.272427,267.296387,0.368717,4.124584,79.981827,0.193918,-3.008845,248.995880,0,0,0,0,0.000000,0.000000,92607116,322251558,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(592,10,'45 (Middle)',0,1519673218,1,1,77.679207,263,0,1,1,2,11,11,11,0,0,0,48,70,-6.532264,3.502919,71.644402,-0.898054,0.209077,68.865936,-4.659216,-4.070593,246.161652,-1.340927,6.950192,152.405380,-8.800151,-5.898721,354.379639,2.712077,1.469036,160.954788,-5.088562,-0.966887,344.962402,0,0,0,0,0.000000,0.000000,92606652,322251689,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(592,11,'67 (Middle)',0,1519672396,1,1,165.382919,323,0,1,1,2,10,10,10,0,0,1,52,70,-6.540989,-0.265518,157.425034,-0.652813,-1.560212,159.728531,-10.560004,1.422588,342.219086,-8.884163,4.476734,241.410507,-8.256522,-4.619458,77.892868,-1.968733,0.247160,242.232956,2.843843,1.073607,58.729095,0,0,0,0,0.000000,0.000000,92606807,322252006,10,'',0,0,0,0,0,0.000000,0.000000,0.000000,0.000000,0.500000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
INSERT OR REPLACE INTO Ramps VALUES(592,12,'81 (Middle)',0,1519674231,1,1,245.603851,79,0,1,1,2,11,11,11,1,0,0,48,57,-7.867437,-2.128456,254.497894,-1.386748,-1.700073,252.811584,-6.169429,2.566586,72.854721,-8.466138,3.084077,333.379730,-2.832532,-3.045221,169.491196,-3.870623,1.451667,335.502045,2.630870,-1.408461,163.801422,0,0,0,0,0.000000,0.000000,92607278,322251781,10,'',0,0,0,0,0,0.000000,0.000000,15.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0,0);
UPDATE Intersections SET lastUpdateTime=542739022, status=2,                     assignedToPrelim=1,                     assignedToDetail=0,                     intX=92607011,                     intY=322251732,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-11403159,                     ramp23=-2752871,                     ramp45=18022196,                     ramp67=3211531,                     xWalkA=-2359081,                     xWalkB=-10420309,                     xWalkC=7536370,                     xWalkD=10747924,                     signal81=7799017,                     signal23=-10485549,                     signal45=-7995707,                     signal67=20512669,                     latitude=33.913139,                     longitude=-117.902160,                     zoomLevel=20,                     doLater=0,                     intersectionComment=''                      WHERE intID=592;
UPDATE Intersections_index SET minY=33.913139,minX=-117.902160,maxY=33.913139,maxX=-117.902160 WHERE Intersections_index.id=592
UPDATE Intersections SET lastUpdateTime=542739029, assignedToDetail=3 WHERE intID=592
UPDATE Intersections SET lastUpdateTime=542739031, assignedToDetail=3 WHERE intID=830
UPDATE Intersections SET lastUpdateTime=542739031, assignedToDetail=3 WHERE intID=244
UPDATE Intersections SET lastUpdateTime=542739032, assignedToDetail=3 WHERE intID=828
UPDATE Intersections SET lastUpdateTime=542739033, assignedToDetail=3 WHERE intID=519
UPDATE Intersections SET lastUpdateTime=542739034, assignedToDetail=3 WHERE intID=1196
UPDATE Intersections SET lastUpdateTime=542739034, assignedToDetail=3 WHERE intID=1197
UPDATE Intersections SET lastUpdateTime=542739043, assignedToDetail=3 WHERE intID=245
UPDATE Intersections SET lastUpdateTime=542739056, assignedToDetail=3 WHERE intID=783
UPDATE Intersections SET lastUpdateTime=542739057, assignedToDetail=3 WHERE intID=784
UPDATE Intersections SET lastUpdateTime=542739057, assignedToDetail=3 WHERE intID=1195
UPDATE Intersections SET lastUpdateTime=542739058, assignedToDetail=3 WHERE intID=913
UPDATE Intersections SET lastUpdateTime=542739059, assignedToDetail=3 WHERE intID=1105
UPDATE Intersections SET lastUpdateTime=542739060, assignedToDetail=3 WHERE intID=904
UPDATE Intersections SET lastUpdateTime=542739060, assignedToDetail=3 WHERE intID=645
UPDATE Intersections SET lastUpdateTime=542739061, assignedToDetail=3 WHERE intID=1325
UPDATE Intersections SET lastUpdateTime=542739062, assignedToDetail=3 WHERE intID=644
UPDATE Intersections SET lastUpdateTime=542739062, assignedToDetail=3 WHERE intID=1270
UPDATE Intersections SET lastUpdateTime=542739063, assignedToDetail=3 WHERE intID=271
UPDATE Intersections SET lastUpdateTime=542739064, assignedToDetail=3 WHERE intID=270
UPDATE Intersections SET lastUpdateTime=542739064, assignedToDetail=3 WHERE intID=655
UPDATE Intersections SET lastUpdateTime=542739065, assignedToDetail=3 WHERE intID=682
UPDATE Intersections SET lastUpdateTime=542739066, assignedToDetail=3 WHERE intID=1804
UPDATE Intersections SET lastUpdateTime=542739066, assignedToDetail=3 WHERE intID=160
UPDATE Intersections SET lastUpdateTime=542739067, assignedToDetail=3 WHERE intID=1250
UPDATE Intersections SET lastUpdateTime=542739068, assignedToDetail=3 WHERE intID=849
UPDATE Intersections SET lastUpdateTime=542739069, assignedToDetail=3 WHERE intID=1078
UPDATE Intersections SET lastUpdateTime=542739069, assignedToDetail=3 WHERE intID=162
UPDATE Intersections SET lastUpdateTime=542739071, assignedToDetail=3 WHERE intID=903
UPDATE Intersections SET lastUpdateTime=542739072, assignedToDetail=3 WHERE intID=243
UPDATE Intersections SET lastUpdateTime=542739072, assignedToDetail=3 WHERE intID=594
UPDATE Intersections SET lastUpdateTime=542739073, assignedToDetail=3 WHERE intID=1004
UPDATE Intersections SET lastUpdateTime=542739074, assignedToDetail=3 WHERE intID=1235
UPDATE Intersections SET lastUpdateTime=542739087, assignedToDetail=3 WHERE intID=557
UPDATE Intersections SET lastUpdateTime=542739088, assignedToDetail=3 WHERE intID=1054
UPDATE Intersections SET lastUpdateTime=542739089, assignedToDetail=3 WHERE intID=1080
UPDATE Intersections SET lastUpdateTime=542739089, assignedToDetail=3 WHERE intID=1081
UPDATE Intersections SET lastUpdateTime=542739090, assignedToDetail=3 WHERE intID=1251
UPDATE Intersections SET lastUpdateTime=542739091, assignedToDetail=3 WHERE intID=1079
UPDATE Intersections SET lastUpdateTime=542739092, assignedToDetail=3 WHERE intID=669
UPDATE Intersections SET lastUpdateTime=542739092, assignedToDetail=3 WHERE intID=670
UPDATE Intersections SET lastUpdateTime=542739093, assignedToDetail=3 WHERE intID=595
UPDATE Intersections SET lastUpdateTime=542739094, assignedToDetail=3 WHERE intID=1394
UPDATE Intersections SET lastUpdateTime=542739094, assignedToDetail=3 WHERE intID=1384
UPDATE Intersections SET lastUpdateTime=542739095, assignedToDetail=3 WHERE intID=1108
UPDATE Intersections SET lastUpdateTime=542739096, assignedToDetail=3 WHERE intID=1107
UPDATE Intersections SET lastUpdateTime=542739097, assignedToDetail=3 WHERE intID=906
UPDATE Intersections SET lastUpdateTime=542739097, assignedToDetail=3 WHERE intID=617
INSERT OR REPLACE INTO Ramps VALUES(1175,4,'4(Right)',0,0,0,1,0.000000,0,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,3,2,37,44,0.000000,0.000000,0,0,0,'',1,1,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(1175,9,'23 (Middle)',0,1519421127,1,1,349.412445,171,0,1,1,10,11,11,11,0,0,0,48,48,-8.366673,-0.951977,344.264771,-2.987141,0.104602,340.301727,2.055734,0.570038,153.700378,-9.696651,5.093792,63.645538,-9.429478,-6.924760,259.549408,-0.304239,1.482665,61.056499,0.978822,-2.841913,247.545227,0,0,0,0,0.000000,0.500000,92612765,322259823,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(1175,10,'45 (Middle)',0,1519416750,1,1,40.976227,231,0,1,1,1,11,11,11,0,0,0,48,48,-7.062303,-0.175057,79.863655,-3.234064,-2.298931,81.203903,1.054743,-2.249089,252.180786,-11.157907,5.055588,147.921844,-9.687306,-6.595073,353.937073,-0.226902,2.592462,149.133316,1.444267,-2.414509,12.858455,0,0,0,0,0.000000,0.000000,92612454,322259895,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(1175,11,'67 (Middle)',0,1519414257,1,1,163.701920,337,0,1,1,2,11,11,11,0,0,0,36,48,-8.866458,-1.211999,155.119019,-2.541768,-0.986814,159.689026,6.154513,2.489531,339.912262,-4.928675,5.115419,232.685440,-10.000522,-3.397370,91.583359,-0.055287,4.366744,242.126740,0.200077,-3.333033,82.488091,0,0,0,0,0.000000,0.500000,92612637,322260315,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(1175,12,'81 (Middle)',0,1519414968,1,1,246.184128,64,0,1,1,10,11,11,11,0,0,0,48,48,-8.627429,1.929427,247.179764,-4.424386,2.042339,248.496368,1.951437,-2.861594,70.406387,-7.450809,5.812287,330.506531,-10.288816,-5.335561,167.098206,3.965852,2.813422,336.816803,-1.661620,-4.599393,161.860245,0,0,0,0,0.000000,0.500000,92612942,322260210,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=542739108, status=2,                     assignedToPrelim=1,                     assignedToDetail=0,                     intX=92612722,                     intY=322260106,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-18546645,                     ramp23=-13762828,                     ramp45=13762475,                     ramp67=6815964,                     xWalkA=0,                     xWalkB=-16515179,                     xWalkC=0,                     xWalkD=12124216,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.917799,                     longitude=-117.898331,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=1175;
UPDATE Intersections_index SET minY=33.917799,minX=-117.898331,maxY=33.917799,maxX=-117.898331 WHERE Intersections_index.id=1175
INSERT OR REPLACE INTO Ramps VALUES(567,9,'23 (Middle)',0,0,1,0,347.000000,102,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,92612739,322259831,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(567,11,'67 (Middle)',0,0,1,0,80.000000,9,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,92612452,322259901,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=542739112, status=2,                     assignedToPrelim=1,                     assignedToDetail=0,                     intX=92612452,                     intY=322259898,                     ramp1=0,                     ramp2=0,                     ramp3=0,                     ramp4=0,                     ramp5=0,                     ramp6=0,                     ramp7=0,                     ramp8=0,                     ramp81=-4390625,                     ramp23=0,                     ramp45=196608,                     ramp67=0,                     xWalkA=-2752365,                     xWalkB=0,                     xWalkC=0,                     xWalkD=0,                     signal81=0,                     signal23=0,                     signal45=0,                     signal67=0,                     latitude=33.917684,                     longitude=-117.898512,                     zoomLevel=21,                     doLater=0,                     intersectionComment=''                      WHERE intID=567;
UPDATE Intersections_index SET minY=33.917684,minX=-117.898512,maxY=33.917684,maxX=-117.898512 WHERE Intersections_index.id=567