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;
}