function waypointsFromSQL() { routeInfo[0] = { firstWaypoint: 0, root: "ab.crotrl", tier: 3, color: "TMteal", system: "cansf", label: "AB CroTrl" }; routeInfo[1] = { firstWaypoint: 26, root: "ab.gletrl", tier: 3, color: "TMteal", system: "cansf", label: "AB GleTrl" }; routeInfo[2] = { firstWaypoint: 42, root: "ab.sheparkfwy", tier: 3, color: "TMteal", system: "cansf", label: "AB SheParkFwy" }; routeInfo[3] = { firstWaypoint: 49, root: "bc.golearsway", tier: 3, color: "TMteal", system: "cansf", label: "BC GolEarsWay" }; routeInfo[4] = { firstWaypoint: 54, root: "bc.knist", tier: 3, color: "TMteal", system: "cansf", label: "BC KniSt" }; routeInfo[5] = { firstWaypoint: 59, root: "ns.bedbyp", tier: 3, color: "TMteal", system: "cansf", label: "NS BedByp" }; routeInfo[6] = { firstWaypoint: 63, root: "on.allrd", tier: 3, color: "TMteal", system: "cansf", label: "ON AllRd" }; routeInfo[7] = { firstWaypoint: 68, root: "on.donvalpkwy", tier: 3, color: "TMteal", system: "cansf", label: "ON DonValPkwy" }; routeInfo[8] = { firstWaypoint: 89, root: "on.doupkwy", tier: 3, color: "TMteal", system: "cansf", label: "ON DouPkwy" }; routeInfo[9] = { firstWaypoint: 92, root: "on.ecrowexpy", tier: 3, color: "TMteal", system: "cansf", label: "ON ECRowExpy" }; routeInfo[10] = { firstWaypoint: 105, root: "on.garexpy", tier: 3, color: "TMteal", system: "cansf", label: "ON GarExpy" }; routeInfo[11] = { firstWaypoint: 126, root: "on.higave", tier: 3, color: "TMteal", system: "cansf", label: "ON HigAve" }; routeInfo[12] = { firstWaypoint: 130, root: "on.hwy2a", tier: 3, color: "TMteal", system: "cansf", label: "ON Hwy2A" }; routeInfo[13] = { firstWaypoint: 132, root: "on.linalepkwy", tier: 3, color: "TMteal", system: "cansf", label: "ON LinAlePkwy" }; routeInfo[14] = { firstWaypoint: 140, root: "on.niktesblvd", tier: 3, color: "TMteal", system: "cansf", label: "ON NikTesBlvd" }; routeInfo[15] = { firstWaypoint: 146, root: "on.redhillpkwy", tier: 3, color: "TMteal", system: "cansf", label: "ON RedHillPkwy" }; routeInfo[16] = { firstWaypoint: 157, root: "on.rr174", tier: 3, color: "TMteal", system: "cansf", label: "ON RR174" }; routeInfo[17] = { firstWaypoint: 167, root: "sk.ringrd", tier: 3, color: "TMteal", system: "cansf", label: "SK RingRd" }; waypoints = [ new Waypoint("GleTrl",51.000266,-114.117994), new Waypoint("54Ave",51.005,-114.117989), new Waypoint("50Ave",51.008705,-114.117973), new Waypoint("FlaAve",51.016047,-114.117999), new Waypoint("33Ave",51.023952,-114.117903), new Waypoint("24St",51.035417,-114.117179), new Waypoint("RicRd",51.037343,-114.113477), new Waypoint("BowTrl",51.043141,-114.112035), new Waypoint("10Ave",51.045343,-114.113941), new Waypoint("MemDr",51.048982,-114.1161), new Waypoint("KenRd",51.052483,-114.117967), new Waypoint("UniDr",51.062281,-114.117956), new Waypoint("AB1",51.067048,-114.118037), new Waypoint("BanTrl",51.072549,-114.117935), new Waypoint("24Ave",51.074258,-114.118424), new Waypoint("32Ave",51.083064,-114.125698), new Waypoint("BreRd",51.085371,-114.128873), new Waypoint("40Ave",51.088655,-114.134882), new Waypoint("NorDr",51.0938,-114.14221), new Waypoint("ShaTrl",51.098085,-114.149366), new Waypoint("53St",51.105119,-114.165142), new Waypoint("SarTrl",51.110686,-114.178365), new Waypoint("NoseHillDr",51.120576,-114.202108), new Waypoint("CroRise",51.124482,-114.21147), new Waypoint("AB201",51.131165,-114.227627), new Waypoint("12MileRd",51.143434,-114.25696), new Waypoint("AB201",51.007794,-114.164922), new Waypoint("37St",51.008624,-114.141474), new Waypoint("RicRd",51.003274,-114.131368), new Waypoint("CroTrl",51.000266,-114.117994), new Waypoint("14St",50.994189,-114.095507), new Waypoint("ElbDr",50.994373,-114.083158), new Waypoint("5St",50.994355,-114.076667), new Waypoint("MacTrl",50.99423,-114.07153), new Waypoint("CenSt",50.993961,-114.063822), new Waypoint("BlaTrl",50.994135,-114.052141), new Waypoint("AB2",50.993133,-114.034964), new Waypoint("HerDr",50.98914,-114.027708), new Waypoint("18St",50.980675,-114.015799), new Waypoint("OgdRd",50.979108,-113.998845), new Waypoint("31St",50.979113,-113.98854), new Waypoint("BarTrl",50.979181,-113.981786), new Waypoint("71St",53.517524,-113.436539), new Waypoint("ArgRd",53.515948,-113.431086), new Waypoint("50St",53.514328,-113.418378), new Waypoint("34St",53.517008,-113.393841), new Waypoint("17St",53.51714,-113.369273), new Waypoint("*76Ave",53.51469,-113.354676), new Waypoint("AB216",53.512982,-113.344644), new Waypoint("192St",49.181026,-122.690317), new Waypoint("199ASt",49.183178,-122.667074), new Waypoint("113BAve",49.208831,-122.668678), new Waypoint("HamRd",49.216552,-122.668377), new Waypoint("BC7",49.223081,-122.669069), new Waypoint("WesHwy",49.17022,-123.07444), new Waypoint("BC91",49.177653,-123.074479), new Waypoint("BriRd",49.191992,-123.077451), new Waypoint("MitRd",49.205304,-123.077479), new Waypoint("MarDr",49.211049,-123.077146), new Waypoint("NS101/1",44.749457,-63.661249), new Waypoint("CobRd",44.748732,-63.657701), new Waypoint("+X1",44.736522,-63.643627), new Waypoint("NS7",44.724494,-63.640902), new Waypoint("EglAve",43.698829,-79.435776), new Waypoint("LawAve",43.716132,-79.444242), new Waypoint("YorRd",43.725708,-79.447922), new Waypoint("ON401",43.729922,-79.4488), new Waypoint("TraRd",43.741794,-79.454284), new Waypoint("GarExpy",43.65,-79.34964), new Waypoint("LakeShoBlvd",43.653578,-79.349087), new Waypoint("1",43.656732,-79.352507), new Waypoint("QueSt",43.658005,-79.35371), new Waypoint("DunSt",43.661781,-79.355063), new Waypoint("+X00",43.669734,-79.357418), new Waypoint("RoyDr",43.673286,-79.360406), new Waypoint("+X01",43.678235,-79.36222), new Waypoint("3",43.6828,-79.362187), new Waypoint("+X02",43.691107,-79.359419), new Waypoint("+X03",43.697848,-79.35045), new Waypoint("+X04",43.697444,-79.342988), new Waypoint("7",43.700192,-79.337752), new Waypoint("+X05",43.70318,-79.332442), new Waypoint("+X06",43.708074,-79.330865), new Waypoint("+X07",43.7147,-79.325286), new Waypoint("10",43.723145,-79.3302), new Waypoint("11",43.726756,-79.330449), new Waypoint("12",43.739463,-79.332182), new Waypoint("14",43.75829,-79.335733), new Waypoint("ON401/404",43.767584,-79.338034), new Waypoint("HowAve",42.250901,-82.996795), new Waypoint("SixConRd",42.24695,-82.979447), new Waypoint("ON401",42.244754,-82.968943), new Waypoint("OjiPkwy",42.274165,-83.078667), new Waypoint("MatRd",42.275157,-83.071736), new Waypoint("ON401",42.273213,-83.065556), new Waypoint("ON3",42.270886,-83.047639), new Waypoint("DomBlvd",42.274086,-83.029454), new Waypoint("DouAve",42.27615,-83.015989), new Waypoint("HowAve",42.277444,-83.007277), new Waypoint("WalRd",42.283445,-82.982225), new Waypoint("CenAve",42.284921,-82.970198), new Waypoint("JefBlvd",42.290429,-82.939246), new Waypoint("LauPkwy",42.293477,-82.925781), new Waypoint("+X00",42.297961,-82.904677), new Waypoint("BanRd",42.301381,-82.899077), new Waypoint("139",43.61349,-79.549357), new Waypoint("141",43.617947,-79.525767), new Waypoint("141A",43.619118,-79.519791), new Waypoint("142",43.620427,-79.51311), new Waypoint("144",43.626296,-79.486714), new Waypoint("146",43.628314,-79.480339), new Waypoint("145",43.633043,-79.473488), new Waypoint("146A",43.634351,-79.471208), new Waypoint("+X00",43.638839,-79.458232), new Waypoint("+X01",43.638653,-79.451108), new Waypoint("149",43.632868,-79.434374), new Waypoint("149A",43.63248,-79.430983), new Waypoint("+X02",43.637391,-79.411958), new Waypoint("153",43.638678,-79.392335), new Waypoint("154",43.6416,-79.380949), new Waypoint("154A",43.644216,-79.375843), new Waypoint("155",43.645786,-79.369875), new Waypoint("155A",43.646584,-79.366184), new Waypoint("+X03",43.6491,-79.356565), new Waypoint("+X04",43.64906,-79.35207), new Waypoint("157",43.65,-79.34964), new Waypoint("ON401",42.936502,-81.179287), new Waypoint("BraAve",42.944969,-81.184663), new Waypoint("ComRd",42.963018,-81.189963), new Waypoint("PowSt",42.975049,-81.192763), new Waypoint("LawRd",43.783322,-79.167159), new Waypoint("ON401",43.79575,-79.149483), new Waypoint("ON403",43.232224,-79.950702), new Waypoint("GolfLinRd",43.230336,-79.93573), new Waypoint("GarSt",43.223551,-79.905142), new Waypoint("UppJamSt",43.218758,-79.885958), new Waypoint("UppWenSt",43.213848,-79.86596), new Waypoint("UppGageAve",43.209172,-79.847023), new Waypoint("+X00",43.205629,-79.83372), new Waypoint("RedHillPkwy",43.202693,-79.830292), new Waypoint("BurSt",43.260054,-79.80958), new Waypoint("KenAve",43.257856,-79.802445), new Waypoint("StrAve",43.256762,-79.792553), new Waypoint("ParAve",43.256795,-79.783501), new Waypoint("WooAve",43.258862,-79.773005), new Waypoint("QEW",43.258932,-79.768376), new Waypoint("LinAlePkwy",43.202693,-79.830292), new Waypoint("DarRd",43.199044,-79.826767), new Waypoint("+X00",43.196526,-79.820062), new Waypoint("UppRHVPkwy",43.198012,-79.814236), new Waypoint("GreAve",43.218039,-79.80045), new Waypoint("+X01",43.223871,-79.79589), new Waypoint("KingSt",43.226185,-79.790107), new Waypoint("QueRd",43.232338,-79.784528), new Waypoint("BarSt",43.240295,-79.772898), new Waypoint("+X02",43.246101,-79.768606), new Waypoint("QEW",43.248583,-79.761067), new Waypoint("ON417",45.423365,-75.619272), new Waypoint("RR27",45.431768,-75.605657), new Waypoint("*TraWay",45.435736,-75.598018), new Waypoint("RR34",45.451401,-75.583599), new Waypoint("+X00",45.455751,-75.579704), new Waypoint("RR55",45.469062,-75.54593), new Waypoint("ChaSt",45.479873,-75.51796), new Waypoint("RR47",45.485846,-75.502542), new Waypoint("RR57",45.493977,-75.484791), new Waypoint("RR55/57",45.496744,-75.479518), new Waypoint("SK1/11",50.396671,-104.708406), new Waypoint("LewDr",50.396764,-104.643944), new Waypoint("SK6_S",50.396754,-104.618123), new Waypoint("+X27(1)",50.397357,-104.60186), new Waypoint("WasPkwy",50.407962,-104.589553), new Waypoint("AssAve",50.42617,-104.57369), new Waypoint("SK33",50.437174,-104.563494), new Waypoint("VicAve",50.447105,-104.563542), new Waypoint("DewAve",50.455178,-104.56358), new Waypoint("RossAve",50.465815,-104.567184), new Waypoint("SK46",50.474574,-104.579415), new Waypoint("WinSt",50.482949,-104.594948), new Waypoint("SK6_N",50.486549,-104.618377), new Waypoint("ArgSt",50.48514,-104.63269), new Waypoint("PasSt",50.48434,-104.641176) ]; traveler = 'duke87'; segments = [ 73683, 73684, 73685, 73686, 73687, 73688, 73689, 73690, 73691, 73692, 73693, 73694, 73695, 73696, 73697, 73698, 73699, 73700, 73701, 73702, 73703, 73704, 73705, 73706, 73707, 73708, 73709, 73710, 73711, 73712, 73713, 73714, 73715, 73716, 73717, 73718, 73719, 73720, 73721, 73722, 73723, 73724, 73725, 73726, 73727, 73728, 73729, 73730, 73731, 73732, 73733, 73734, 73735, 73736, 73737, 73738, 73739, 73740, 73741, 73742, 73743, 73744, 73745, 73746, 73747, 73748, 73749, 73750, 73751, 73752, 73753, 73754, 73755, 73756, 73757, 73758, 73759, 73760, 73761, 73762, 73763, 73764, 73765, 73766, 73767, 73768, 73769, 73770, 73771, 73772, 73773, 73774, 73775, 73776, 73777, 73778, 73779, 73780, 73781, 73782, 73783, 73784, 73785, 73786, 73787, 73788, 73789, 73790, 73791, 73792, 73793, 73794, 73795, 73796, 73797, 73798, 73799, 73800, 73801, 73802, 73803, 73804, 73805, 73806, 73807, 73808, 73809, 73810, 73811, 73812, 73813, 73823, 73824, 73825, 73826, 73827, 73828, 73829, 73830, 73831, 73832, 73814, 73815, 73816, 73817, 73818, 73819, 73820, 73821, 73822, 73833, 73834, 73835, 73836, 73837, 73838, 73839, 73840, 73841, 73842, 73843, 73844, 73845, 73846 ]; clinched = [ 73740, 73741, 73742, 73743, 73778, 73779, 73780, 73781, 73782, 73783, 73784, 73785, 73786, 73787, 73788, 73789, 73790, 73833, 73834, 73835, 73836, 73837, 73838, 73839 ]; mapClinched = true; mapStatus = mapStates.MAPVIEW; genEdges = true; }