<!-- /lib/tmphpfuncs.php: common PHP functionality for Travel Mapping -->
<!-- mysqli connecting to database TravelMapping on localhost -->
<!-- /lib/tmphpfuncs.php END -->

function waypointsFromSQL() {
    routeInfo[0] = { firstWaypoint: 0, root: "ab.crotrl", tier: 3, color: "TMteal", system: "cansf", label: "AB CroTrl" };
routeInfo[1] = { firstWaypoint: 26, root: "ab.sheparkfwy", tier: 3, color: "TMteal", system: "cansf", label: "AB SheParkFwy" };
routeInfo[2] = { firstWaypoint: 33, root: "bc.golearsway", tier: 3, color: "TMteal", system: "cansf", label: "BC GolEarsWay" };
routeInfo[3] = { firstWaypoint: 38, root: "bc.knist", tier: 3, color: "TMteal", system: "cansf", label: "BC KniSt" };
routeInfo[4] = { firstWaypoint: 43, root: "ns.bedbyp", tier: 3, color: "TMteal", system: "cansf", label: "NS BedByp" };
routeInfo[5] = { firstWaypoint: 47, root: "on.allrd", tier: 3, color: "TMteal", system: "cansf", label: "ON AllRd" };
routeInfo[6] = { firstWaypoint: 52, root: "on.donvalpkwy", tier: 3, color: "TMteal", system: "cansf", label: "ON DonValPkwy" };
routeInfo[7] = { firstWaypoint: 73, root: "on.doupkwy", tier: 3, color: "TMteal", system: "cansf", label: "ON DouPkwy" };
routeInfo[8] = { firstWaypoint: 76, root: "on.ecrowexpy", tier: 3, color: "TMteal", system: "cansf", label: "ON ECRowExpy" };
routeInfo[9] = { firstWaypoint: 89, root: "on.garexpy", tier: 3, color: "TMteal", system: "cansf", label: "ON GarExpy" };
routeInfo[10] = { firstWaypoint: 110, root: "on.higave", tier: 3, color: "TMteal", system: "cansf", label: "ON HigAve" };
routeInfo[11] = { firstWaypoint: 114, root: "on.hwy2a", tier: 3, color: "TMteal", system: "cansf", label: "ON Hwy2A" };
routeInfo[12] = { firstWaypoint: 116, root: "on.linalepkwy", tier: 3, color: "TMteal", system: "cansf", label: "ON LinAlePkwy" };
routeInfo[13] = { firstWaypoint: 124, root: "on.niktesblvd", tier: 3, color: "TMteal", system: "cansf", label: "ON NikTesBlvd" };
routeInfo[14] = { firstWaypoint: 130, root: "on.redhillpkwy", tier: 3, color: "TMteal", system: "cansf", label: "ON RedHillPkwy" };
routeInfo[15] = { firstWaypoint: 141, root: "on.rr174", tier: 3, color: "TMteal", system: "cansf", label: "ON RR174" };
routeInfo[16] = { firstWaypoint: 151, 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("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 = 'webny99';
segments = [
60827,
60828,
60829,
60830,
60831,
60832,
60833,
60834,
60835,
60836,
60837,
60838,
60839,
60840,
60841,
60842,
60843,
60844,
60845,
60846,
60847,
60848,
60849,
60850,
60851,
60852,
60853,
60854,
60855,
60856,
60857,
60858,
60859,
60860,
60861,
60862,
60863,
60864,
60865,
60866,
60867,
60868,
60869,
60870,
60871,
60872,
60873,
60874,
60875,
60876,
60877,
60878,
60879,
60880,
60881,
60882,
60883,
60884,
60885,
60886,
60887,
60888,
60889,
60890,
60891,
60892,
60893,
60894,
60895,
60896,
60897,
60898,
60899,
60900,
60901,
60902,
60903,
60904,
60905,
60906,
60907,
60908,
60909,
60910,
60911,
60912,
60913,
60914,
60915,
60916,
60917,
60918,
60919,
60920,
60921,
60922,
60923,
60924,
60925,
60926,
60927,
60928,
60929,
60930,
60931,
60932,
60933,
60934,
60935,
60936,
60937,
60938,
60939,
60940,
60941,
60942,
60952,
60953,
60954,
60955,
60956,
60957,
60958,
60959,
60960,
60961,
60943,
60944,
60945,
60946,
60947,
60948,
60949,
60950,
60951,
60962,
60963,
60964,
60965,
60966,
60967,
60968,
60969,
60970,
60971,
60972,
60973,
60974,
60975
];
clinched = [
60907,
60908,
60909,
60910,
60911,
60912,
60913,
60914,
60915,
60916,
60917,
60918,
60919,
60920,
60927,
60928,
60929,
60931,
60932,
60933,
60934,
60935,
60936,
60937,
60952,
60953,
60954,
60955,
60956,
60957,
60958,
60959,
60960,
60961
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}