<!-- /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: "ky.audpkwy", tier: 2, color: "TMteal", system: "usakyp", label: "KY AudPkwy" };
routeInfo[1] = { firstWaypoint: 11, root: "ky.blupkwy", tier: 2, color: "TMteal", system: "usakyp", label: "KY BluPkwy" };
routeInfo[2] = { firstWaypoint: 41, root: "ky.commtnpkwy", tier: 2, color: "TMteal", system: "usakyp", label: "KY ComMtnPkwy" };
routeInfo[3] = { firstWaypoint: 89, root: "ky.cumpkwy", tier: 2, color: "TMteal", system: "usakyp", label: "KY CumPkwy" };
routeInfo[4] = { firstWaypoint: 119, root: "ky.halrogpkwy", tier: 2, color: "TMteal", system: "usakyp", label: "KY HalRogPkwy" };
routeInfo[5] = { firstWaypoint: 176, root: "ky.penpkwy", tier: 2, color: "TMteal", system: "usakyp", label: "KY PenPkwy" };
routeInfo[6] = { firstWaypoint: 192, root: "ky.purpkwy", tier: 2, color: "TMteal", system: "usakyp", label: "KY PurPkwy" };
routeInfo[7] = { firstWaypoint: 203, root: "ky.weskypkwy", tier: 2, color: "TMteal", system: "usakyp", label: "KY WesKYPkwy" };
waypoints = [
new Waypoint("1",37.809826,-87.563948),
new Waypoint("+X000(AudPkwy)",37.81025,-87.545312),
new Waypoint("5",37.786072,-87.471417),
new Waypoint("+X001(AudPkwy)",37.774043,-87.436109),
new Waypoint("+X002(AudPkwy)",37.755592,-87.407822),
new Waypoint("10",37.752453,-87.396015),
new Waypoint("+X003(AudPkwy)",37.763171,-87.30835),
new Waypoint("+X004(AudPkwy)",37.751329,-87.287192),
new Waypoint("18",37.756542,-87.260301),
new Waypoint("+X005(AudPkwy)",37.768416,-87.203057),
new Waypoint("24",37.765685,-87.163537),
new Waypoint("1",37.70282,-85.833655),
new Waypoint("+X000(BluPkwy)",37.715756,-85.795187),
new Waypoint("+X001(BluPkwy)",37.718696,-85.745072),
new Waypoint("8",37.737667,-85.699899),
new Waypoint("+X002(BluPkwy)",37.74663,-85.684009),
new Waypoint("10",37.748933,-85.674477),
new Waypoint("+X003(BluPkwy)",37.755168,-85.631298),
new Waypoint("+X004(BluPkwy)",37.761708,-85.61506),
new Waypoint("+X005(BluPkwy)",37.760499,-85.571083),
new Waypoint("+X006(BluPkwy)",37.780391,-85.535131),
new Waypoint("+X007(BluPkwy)",37.777584,-85.520883),
new Waypoint("21",37.785423,-85.489045),
new Waypoint("+X008(BluPkwy)",37.775269,-85.464771),
new Waypoint("25",37.797526,-85.429628),
new Waypoint("+X009(BluPkwy)",37.833624,-85.381193),
new Waypoint("34",37.871771,-85.30077),
new Waypoint("+X010(BluPkwy)",37.883339,-85.233157),
new Waypoint("42",37.870687,-85.158972),
new Waypoint("+X011(BluPkwy)",37.896547,-85.106626),
new Waypoint("+X012(BluPkwy)",37.901589,-85.064875),
new Waypoint("48",37.906283,-85.053277),
new Waypoint("+X013(BluPkwy)",37.951029,-84.905187),
new Waypoint("59",37.973035,-84.875055),
new Waypoint("+X014(BluPkwy)",37.980401,-84.864578),
new Waypoint("+X015(BluPkwy)",37.987707,-84.842471),
new Waypoint("+X016(BluPkwy)",37.984346,-84.816508),
new Waypoint("+X017(BluPkwy)",37.998991,-84.799513),
new Waypoint("68",38.02514,-84.72343),
new Waypoint("+X018(BluPkwy)",38.032222,-84.697026),
new Waypoint("72",38.046786,-84.680573),
new Waypoint("I-64",38.018987,-84.15029),
new Waypoint("+X000(ComMtnPkwy)",38.000686,-84.131976),
new Waypoint("+X001(ComMtnPkwy)",37.971428,-84.039005),
new Waypoint("10",37.936196,-84.000856),
new Waypoint("+X003(ComMtnPkwy)",37.927473,-83.985307),
new Waypoint("+X207354",37.905674,-83.967905),
new Waypoint("16",37.865961,-83.945224),
new Waypoint("18",37.846045,-83.918349),
new Waypoint("+X005(ComMtnPkwy)",37.830412,-83.885127),
new Waypoint("22",37.841241,-83.858321),
new Waypoint("+X006(ComMtnPkwy)",37.844897,-83.764578),
new Waypoint("+X007(ComMtnPkwy)",37.829908,-83.753747),
new Waypoint("+X008(ComMtnPkwy)",37.826141,-83.72892),
new Waypoint("+X263476",37.809903,-83.711979),
new Waypoint("33",37.796899,-83.703804),
new Waypoint("+X009(ComMtnPkwy)",37.793325,-83.682851),
new Waypoint("+X010(ComMtnPkwy)",37.80062,-83.658067),
new Waypoint("+X011(ComMtnPkwy)",37.782091,-83.647166),
new Waypoint("+X012(ComMtnPkwy)",37.768637,-83.613843),
new Waypoint("40",37.752937,-83.605657),
new Waypoint("42",37.741887,-83.578904),
new Waypoint("43",37.741569,-83.568165),
new Waypoint("+X013(ComMtnPkwy)",37.745493,-83.528618),
new Waypoint("46",37.742825,-83.505578),
new Waypoint("+X014(ComMtnPkwy)",37.753743,-83.489581),
new Waypoint("+X015(ComMtnPkwy)",37.734238,-83.462834),
new Waypoint("+X016(ComMtnPkwy)",37.735795,-83.437906),
new Waypoint("+X017(ComMtnPkwy)",37.746273,-83.426056),
new Waypoint("53",37.746685,-83.400993),
new Waypoint("+X018(ComMtnPkwy)",37.742774,-83.387893),
new Waypoint("+X019(ComMtnPkwy)",37.762038,-83.361281),
new Waypoint("57",37.765287,-83.344345),
new Waypoint("*OldExit57",37.765287,-83.341684),
new Waypoint("+X020(ComMtnPkwy)",37.757399,-83.319696),
new Waypoint("*OldExit60",37.755028,-83.299139),
new Waypoint("60",37.75289,-83.293093),
new Waypoint("*61",37.752101,-83.284349),
new Waypoint("+X022(ComMtnPkwy)",37.754167,-83.272011),
new Waypoint("+X023(ComMtnPkwy)",37.74447,-83.243601),
new Waypoint("*OldMtnPkwy_W",37.742023,-83.200434),
new Waypoint("*OldMtnPkwy_E",37.750299,-83.166322),
new Waypoint("70",37.737533,-83.127202),
new Waypoint("72",37.731523,-83.107238),
new Waypoint("+X034(ComMtnPkwy)",37.73042,-83.078399),
new Waypoint("+X035(ComMtnPkwy)",37.735783,-83.070996),
new Waypoint("75",37.736024,-83.063067),
new Waypoint("+X036(ComMtnPkwy)",37.741845,-83.054404),
new Waypoint("US460",37.741234,-83.05074),
new Waypoint("1",37.058388,-86.11194),
new Waypoint("+X000(CumPkwy)",37.043215,-86.069319),
new Waypoint("8",36.992361,-85.980318),
new Waypoint("11",36.978117,-85.934812),
new Waypoint("+X002(CumPkwy)",36.973407,-85.912517),
new Waypoint("14",36.983413,-85.89475),
new Waypoint("15",36.994395,-85.875278),
new Waypoint("27",36.996422,-85.658534),
new Waypoint("+X003(CumPkwy)",36.997202,-85.632479),
new Waypoint("29",37.000768,-85.616211),
new Waypoint("+X004(CumPkwy)",37.008876,-85.57862),
new Waypoint("+X005(CumPkwy)",37.026253,-85.549856),
new Waypoint("+X006(CumPkwy)",37.028111,-85.491067),
new Waypoint("+X007(CumPkwy)",37.043793,-85.449069),
new Waypoint("+X008(CumPkwy)",37.072432,-85.406669),
new Waypoint("46",37.073044,-85.339469),
new Waypoint("49",37.088481,-85.303125),
new Waypoint("+X009(CumPkwy)",37.088139,-85.270627),
new Waypoint("+X010(CumPkwy)",37.046392,-85.13862),
new Waypoint("+X011(CumPkwy)",37.044696,-85.100001),
new Waypoint("62",37.051452,-85.070132),
new Waypoint("+X012(CumPkwy)",37.069025,-85.038713),
new Waypoint("+X013(CumPkwy)",37.073691,-84.964077),
new Waypoint("+X014(CumPkwy)",37.087796,-84.916758),
new Waypoint("+X015(CumPkwy)",37.086607,-84.889657),
new Waypoint("+X016(CumPkwy)",37.10059,-84.859997),
new Waypoint("78",37.092645,-84.80087),
new Waypoint("*OldCumPkwy",37.099371,-84.676314),
new Waypoint("86",37.104698,-84.662645),
new Waypoint("88",37.12556,-84.636961),
new Waypoint("KY914",37.096812,-84.661074),
new Waypoint("KY3261",37.096368,-84.658992),
new Waypoint("TigWay",37.093355,-84.638371),
new Waypoint("KY3263",37.09336,-84.630116),
new Waypoint("US27",37.094925,-84.619617),
new Waypoint("KY1247",37.101159,-84.608846),
new Waypoint("KY39",37.102443,-84.603803),
new Waypoint("KY3260_W",37.100817,-84.58889),
new Waypoint("KY80Bus",37.100372,-84.581466),
new Waypoint("KY914_E",37.103829,-84.575071),
new Waypoint("KY3260_E",37.126723,-84.554429),
new Waypoint("KY1317",37.146635,-84.532456),
new Waypoint("*OldHRPkwy_W",37.157187,-84.506428),
new Waypoint("KY461",37.159872,-84.502995),
new Waypoint("*OldHRPkwy_E",37.15953,-84.497609),
new Waypoint("KY692",37.158367,-84.486494),
new Waypoint("KY1003",37.156691,-84.466667),
new Waypoint("KY1675",37.152894,-84.431605),
new Waypoint("HawkRd",37.165789,-84.392295),
new Waypoint("KY1956_W",37.156794,-84.323974),
new Waypoint("ChiRockRd",37.147866,-84.313202),
new Waypoint("RocRd",37.146908,-84.278998),
new Waypoint("+X666297",37.162916,-84.228444),
new Waypoint("KY1535",37.145711,-84.165187),
new Waypoint("KY1035",37.148824,-84.143),
new Waypoint("KY1956_E",37.150158,-84.12313),
new Waypoint("I-75",37.146481,-84.111151),
new Waypoint("KY3006",37.144488,-84.106554),
new Waypoint("US25",37.143184,-84.102402),
new Waypoint("KY1769",37.144358,-84.088452),
new Waypoint("KY30",37.144856,-84.082661),
new Waypoint("KY638",37.138886,-84.06462),
new Waypoint("KY472",37.131411,-84.054551),
new Waypoint("KY192",37.122754,-84.042878),
new Waypoint("WatRd",37.107063,-83.98755),
new Waypoint("+X877359",37.10575,-83.958786),
new Waypoint("UrbForkRd",37.129337,-83.868524),
new Waypoint("+X988665",37.143526,-83.809483),
new Waypoint("+X317527",37.133031,-83.796024),
new Waypoint("20",37.136167,-83.76895),
new Waypoint("+X223138",37.128297,-83.753082),
new Waypoint("KY1999",37.133459,-83.726287),
new Waypoint("+X902480",37.144574,-83.660309),
new Waypoint("KY873",37.149833,-83.655267),
new Waypoint("+X248866",37.164215,-83.633251),
new Waypoint("+X165105",37.182467,-83.633112),
new Waypoint("+X953607",37.188561,-83.609626),
new Waypoint("34",37.170649,-83.586586),
new Waypoint("+X548796",37.165421,-83.579553),
new Waypoint("+X798311",37.167567,-83.461236),
new Waypoint("44",37.185826,-83.425498),
new Waypoint("+X130787",37.220854,-83.379847),
new Waypoint("LewBraRd",37.219855,-83.353411),
new Waypoint("+X853842",37.246865,-83.311644),
new Waypoint("56",37.259777,-83.24815),
new Waypoint("KY3677",37.28292,-83.224595),
new Waypoint("59",37.288241,-83.220856),
new Waypoint("1",36.743901,-87.510974),
new Waypoint("5",36.810513,-87.488605),
new Waypoint("6",36.818042,-87.482688),
new Waypoint("7",36.83183,-87.473343),
new Waypoint("8",36.844594,-87.462512),
new Waypoint("9",36.861562,-87.472957),
new Waypoint("11",36.894711,-87.469019),
new Waypoint("+X000(PenPkwy)",36.911848,-87.474191),
new Waypoint("+X001(PenPkwy)",37.022355,-87.458301),
new Waypoint("23",37.050378,-87.464181),
new Waypoint("+X002(PenPkwy)",37.063319,-87.466643),
new Waypoint("+X003(PenPkwy)",37.129174,-87.456547),
new Waypoint("30",37.149807,-87.464857),
new Waypoint("33",37.192348,-87.441806),
new Waypoint("+X004(PenPkwy)",37.202048,-87.439386),
new Waypoint("34",37.212451,-87.441312),
new Waypoint("TN/KY",36.502332,-88.899254),
new Waypoint("0",36.507687,-88.899452),
new Waypoint("+X000(PurPkwy)",36.515427,-88.898347),
new Waypoint("1",36.517781,-88.890188),
new Waypoint("2",36.518975,-88.871251),
new Waypoint("+X001(PurPkwy)",36.523898,-88.857722),
new Waypoint("+X002(PurPkwy)",36.584808,-88.821056),
new Waypoint("14",36.645886,-88.753422),
new Waypoint("+X003(PurPkwy)",36.68648,-88.728724),
new Waypoint("+X004(PurPkwy)",36.725217,-88.679597),
new Waypoint("21",36.726614,-88.667414),
new Waypoint("38",37.212451,-87.441312),
new Waypoint("+X001(WKYPkwy)",37.212562,-87.40448),
new Waypoint("+X002(WKYPkwy)",37.229521,-87.37166),
new Waypoint("+X003(WKYPkwy)",37.236714,-87.326058),
new Waypoint("+X004(WKYPkwy)",37.231161,-87.290019),
new Waypoint("48",37.234416,-87.274414),
new Waypoint("53",37.253479,-87.198025),
new Waypoint("+X005(WKYPkwy)",37.256447,-87.180355),
new Waypoint("+X006(WKYPkwy)",37.272286,-87.15534),
new Waypoint("58",37.281903,-87.109206),
new Waypoint("+X007(WKYPkwy)",37.288817,-87.084895),
new Waypoint("+X008(WKYPkwy)",37.31506,-87.051474),
new Waypoint("+X009(WKYPkwy)",37.321758,-87.032635),
new Waypoint("+X010(WKYPkwy)",37.320085,-86.998072),
new Waypoint("+X011(WKYPkwy)",37.353648,-86.914183),
new Waypoint("+X012(WKYPkwy)",37.352224,-86.894281),
new Waypoint("75",37.367565,-86.842659),
new Waypoint("77",37.38457,-86.809099),
new Waypoint("+X013(WKYPkwy)",37.39266,-86.787626),
new Waypoint("+X014(WKYPkwy)",37.392915,-86.716461),
new Waypoint("+X015(WKYPkwy)",37.384105,-86.654486),
new Waypoint("+X016(WKYPkwy)",37.397382,-86.563602),
new Waypoint("+X017(WKYPkwy)",37.408956,-86.544344),
new Waypoint("94",37.413221,-86.502829),
new Waypoint("+X018(WKYPkwy)",37.408444,-86.462848),
new Waypoint("+X019(WKYPkwy)",37.418951,-86.400749),
new Waypoint("+X020(WKYPkwy)",37.442329,-86.366487),
new Waypoint("+X021(WKYPkwy)",37.452862,-86.321495),
new Waypoint("107",37.466105,-86.292372),
new Waypoint("+X022(WKYPkwy)",37.468659,-86.266724),
new Waypoint("112",37.489076,-86.208987),
new Waypoint("+X023(WKYPkwy)",37.499389,-86.167043),
new Waypoint("+X024(WKYPkwy)",37.549145,-86.119981),
new Waypoint("+X025(WKYPkwy)",37.553347,-86.088749),
new Waypoint("124",37.571522,-86.037455),
new Waypoint("+X026(WKYPkwy)",37.57613,-86.022847),
new Waypoint("+X027(WKYPkwy)",37.647679,-85.910565),
new Waypoint("133",37.654415,-85.889466),
new Waypoint("136",37.679375,-85.861303),
new Waypoint("+X030(WKYPkwy)",37.679159,-85.855891),
new Waypoint("137",37.673754,-85.850574),
new Waypoint("US31W",37.669877,-85.84646)
];
traveler = 'Echostatic';
segments = [
650138,
650139,
650140,
650141,
650142,
650143,
650144,
650145,
650146,
650147,
650195,
650196,
650197,
650198,
650199,
650200,
650201,
650202,
650203,
650204,
650205,
650206,
650207,
650208,
650209,
650210,
650211,
650212,
650213,
650214,
650215,
650216,
650217,
650218,
650219,
650220,
650221,
650222,
650223,
650148,
650149,
650150,
650151,
650152,
650153,
650154,
650155,
650156,
650157,
650158,
650159,
650160,
650161,
650162,
650163,
650164,
650165,
650166,
650167,
650168,
650169,
650170,
650171,
650172,
650173,
650174,
650175,
650176,
650177,
650178,
650179,
650180,
650181,
650182,
650183,
650184,
650185,
650186,
650187,
650188,
650189,
650190,
650191,
650192,
650193,
650194,
650224,
650225,
650226,
650227,
650228,
650229,
650230,
650231,
650232,
650233,
650234,
650235,
650236,
650237,
650238,
650239,
650240,
650241,
650242,
650243,
650244,
650245,
650246,
650247,
650248,
650249,
650250,
650251,
650252,
650253,
650254,
650255,
650256,
650257,
650258,
650259,
650260,
650261,
650262,
650263,
650264,
650265,
650266,
650267,
650268,
650269,
650270,
650271,
650272,
650273,
650274,
650275,
650276,
650277,
650278,
650279,
650280,
650281,
650282,
650283,
650284,
650285,
650286,
650287,
650288,
650289,
650290,
650291,
650292,
650293,
650294,
650295,
650296,
650297,
650298,
650299,
650300,
650301,
650302,
650303,
650304,
650305,
650306,
650307,
650308,
650309,
650310,
650311,
650312,
650313,
650314,
650315,
650316,
650317,
650318,
650319,
650320,
650321,
650322,
650323,
650324,
650325,
650326,
650327,
650328,
650329,
650330,
650331,
650332,
650333,
650334,
650335,
650336,
650337,
650338,
650339,
650340,
650341,
650342,
650343,
650344,
650345,
650346,
650347,
650348,
650349,
650350,
650351,
650352,
650353,
650354,
650355,
650356,
650357,
650358,
650359,
650360,
650361,
650362,
650363,
650364,
650365,
650366,
650367,
650368,
650369,
650370,
650371,
650372,
650373,
650374
];
clinched = [
650324,
650325,
650326,
650327,
650328,
650329,
650330,
650331,
650332,
650333
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}