<!-- /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: "ny.baypkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY BayPkwy" };
routeInfo[1] = { firstWaypoint: 3, root: "ny.bearmtnpkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY BearMtnPkwy" };
routeInfo[2] = { firstWaypoint: 10, root: "ny.bearmtnpkwyyor", tier: 2, color: "TMteal", system: "usanyp", label: "NY BearMtnPkwyYor" };
routeInfo[3] = { firstWaypoint: 12, root: "ny.betstapkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY BetStaPkwy" };
routeInfo[4] = { firstWaypoint: 17, root: "ny.crobaypkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY CroBayPkwy" };
routeInfo[5] = { firstWaypoint: 19, root: "ny.jacrobpkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY JacRobPkwy" };
routeInfo[6] = { firstWaypoint: 27, root: "ny.korwarpkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY KorWarPkwy" };
routeInfo[7] = { firstWaypoint: 33, root: "ny.lakeontpkwysprcar", tier: 2, color: "TMteal", system: "usanyp", label: "NY LakeOntPkwySprCar" };
routeInfo[8] = { firstWaypoint: 36, root: "ny.lakeweldr", tier: 2, color: "TMteal", system: "usanyp", label: "NY LakeWelDr" };
routeInfo[9] = { firstWaypoint: 41, root: "ny.looppkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY LoopPkwy" };
routeInfo[10] = { firstWaypoint: 44, root: "ny.mospkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY MosPkwy" };
routeInfo[11] = { firstWaypoint: 49, root: "ny.niascepkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY NiaScePkwy" };
routeInfo[12] = { firstWaypoint: 61, root: "ny.niascepkwynia", tier: 2, color: "TMteal", system: "usanyp", label: "NY NiaScePkwyNia" };
routeInfo[13] = { firstWaypoint: 64, root: "ny.niascepkwysprpor", tier: 2, color: "TMteal", system: "usanyp", label: "NY NiaScePkwySprPor" };
routeInfo[14] = { firstWaypoint: 67, root: "ny.ocepkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY OcePkwy" };
routeInfo[15] = { firstWaypoint: 76, root: "ny.ocepkwybro", tier: 2, color: "TMteal", system: "usanyp", label: "NY OcePkwyBro" };
routeInfo[16] = { firstWaypoint: 85, root: "ny.pelpkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY PelPkwy" };
routeInfo[17] = { firstWaypoint: 90, root: "ny.promtnhwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY ProMtnHwy" };
routeInfo[18] = { firstWaypoint: 100, root: "ny.sevlakdr", tier: 2, color: "TMteal", system: "usanyp", label: "NY SevLakDr" };
routeInfo[19] = { firstWaypoint: 112, root: "ny.shofropkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY ShoFroPkwy" };
routeInfo[20] = { firstWaypoint: 115, root: "ny.soupkwy", tier: 2, color: "TMteal", system: "usanyp", label: "NY SouPkwy" };
waypoints = [
new Waypoint("OcePkwy",40.593621,-73.537931),
new Waypoint("+x1",40.597792,-73.531837),
new Waypoint("WanStaPkwy",40.600171,-73.50862),
new Waypoint("US6/9",41.295865,-73.933311),
new Waypoint("HigAve",41.302257,-73.920591),
new Waypoint("DivSt",41.301455,-73.915946),
new Waypoint("CarAve",41.298545,-73.906043),
new Waypoint("+X548092",41.303244,-73.890599),
new Waypoint("US6",41.29925,-73.885803),
new Waypoint("US202",41.293173,-73.870547),
new Waypoint("US202",41.290786,-73.835056),
new Waypoint("TacStaPkwy",41.298896,-73.822911),
new Waypoint("B1",40.705839,-73.45268),
new Waypoint("B2",40.716587,-73.458431),
new Waypoint("B3",40.72734,-73.468521),
new Waypoint("B4",40.735543,-73.469986),
new Waypoint("PlaRd",40.738051,-73.468924),
new Waypoint("ShoFroPkwy",40.583795,-73.815663),
new Waypoint("CroBayBri",40.587963,-73.818281),
new Waypoint("JamAve",40.678128,-73.89746),
new Waypoint("1",40.680418,-73.896709),
new Waypoint("2",40.689742,-73.890315),
new Waypoint("3",40.692174,-73.882472),
new Waypoint("4",40.699764,-73.868642),
new Waypoint("5",40.702525,-73.861068),
new Waypoint("6",40.708971,-73.841488),
new Waypoint("7",40.716428,-73.82628),
new Waypoint("NY440(1)",40.525609,-74.232774),
new Waypoint("NY440(2)",40.526392,-74.223504),
new Waypoint("MagAve",40.529866,-74.211037),
new Waypoint("HugAve",40.535007,-74.193351),
new Waypoint("ArdAve",40.546711,-74.180846),
new Waypoint("DruRd",40.559518,-74.173631),
new Waypoint("NY18",43.360653,-78.234715),
new Waypoint("LakeOntPkwy",43.363664,-78.234743),
new Waypoint("CampRd",43.367516,-78.237365),
new Waypoint("SevLakDr",41.213239,-74.122932),
new Waypoint("StJohRd",41.222629,-74.097285),
new Waypoint("WelBea",41.238625,-74.070296),
new Waypoint("TioBroRd",41.250701,-74.048774),
new Waypoint("PalIntPkwy",41.250096,-74.041264),
new Waypoint("LidoBlvd",40.592049,-73.587075),
new Waypoint("+x1",40.600812,-73.584782),
new Waypoint("MeaStaPkwy",40.610695,-73.548918),
new Waypoint("SouBlvd",40.867757,-73.879505),
new Waypoint("GraCon",40.879082,-73.884269),
new Waypoint("GunHillRd",40.884355,-73.887064),
new Waypoint("I-87",40.889882,-73.887391),
new Waypoint("HenHudPkwy",40.901447,-73.887906),
new Waypoint("FinDr",43.115994,-79.058738),
new Waypoint("*OldNiaPkwy",43.116911,-79.060696),
new Waypoint("WhiSP",43.119624,-79.062188),
new Waypoint("NY104",43.132916,-79.046996),
new Waypoint("UppMouRd",43.150519,-79.03985),
new Waypoint("+X499132",43.160971,-79.042425),
new Waypoint("NY18F/104",43.172815,-79.028842),
new Waypoint("PleRd",43.208359,-79.029041),
new Waypoint("NY93",43.253668,-79.030881),
new Waypoint("NiaScePkwySpr",43.262577,-79.033231),
new Waypoint("FourMileSP",43.271913,-78.996259),
new Waypoint("NY18",43.271288,-78.98994),
new Waypoint("LaSExpy",43.080414,-78.986673),
new Waypoint("I-190",43.074278,-78.990793),
new Waypoint("JohnDalyBlvd",43.080804,-79.050987),
new Waypoint("NiaScePkwy",43.262577,-79.033231),
new Waypoint("NY18F",43.264851,-79.046073),
new Waypoint("FortNiaSP",43.264468,-79.052188),
new Waypoint("MeaStaPkwy",40.593621,-73.537931),
new Waypoint("WanStaPkwy",40.596489,-73.508148),
new Waypoint("TobBea",40.609326,-73.43156),
new Waypoint("WGilBea",40.612877,-73.416143),
new Waypoint("GilBea",40.618733,-73.393832),
new Waypoint("CedBea",40.634583,-73.341433),
new Waypoint("OakBea",40.640653,-73.286029),
new Waypoint("RobMosCswy",40.639488,-73.263617),
new Waypoint("CapSP",40.640301,-73.2559),
new Waypoint("SeaBreAve",40.575259,-73.96892),
new Waypoint("BeltPkwy",40.583991,-73.966784),
new Waypoint("AveW",40.593332,-73.964623),
new Waypoint("AveU",40.597833,-73.965476),
new Waypoint("KinHwy",40.605656,-73.966951),
new Waypoint("AveP",40.609404,-73.96767),
new Waypoint("AveJ",40.624185,-73.97047),
new Waypoint("18thAve",40.633112,-73.972162),
new Waypoint("NY27",40.647792,-73.974938),
new Waypoint("US1",40.856969,-73.869077),
new Waypoint("WilRd",40.857342,-73.856277),
new Waypoint("EasRd",40.857497,-73.843644),
new Waypoint("HutRivPkwy",40.85602,-73.832846),
new Waypoint("I-95",40.856572,-73.826387),
new Waypoint("US9",43.411747,-73.711299),
new Waypoint("+X879093",43.406723,-73.728009),
new Waypoint("+X516149",43.416497,-73.737112),
new Waypoint("+X158525",43.433328,-73.730707),
new Waypoint("+X295472",43.435945,-73.746446),
new Waypoint("+X800273",43.423627,-73.747659),
new Waypoint("LakeGeoOve",43.42346,-73.746119),
new Waypoint("+X506749",43.425411,-73.743786),
new Waypoint("+X710636",43.425957,-73.744585),
new Waypoint("End",43.424519,-73.745931),
new Waypoint("JohRd",41.166796,-74.17939),
new Waypoint("PineMeaRd",41.20183,-74.124654),
new Waypoint("LakeWelDr",41.213239,-74.122932),
new Waypoint("KanRd",41.234143,-74.111302),
new Waypoint("TioBroRd",41.275557,-74.087956),
new Waypoint("+X647984",41.293886,-74.069014),
new Waypoint("PalIntPkwy(18)",41.305118,-74.034762),
new Waypoint("PalIntPkwy(19)",41.309373,-74.024591),
new Waypoint("PerMemDr",41.303091,-74.006602),
new Waypoint("*LemRd",41.300675,-73.991786),
new Waypoint("SouEntRd",41.309224,-73.990978),
new Waypoint("US9W/202",41.314648,-73.9885),
new Waypoint("Bea108thSt",40.580153,-73.828844),
new Waypoint("CroBayPkwy",40.583795,-73.815663),
new Waypoint("Bea73rdSt",40.586769,-73.800632),
new Waypoint("WestRivPkwy",42.96778,-78.95889),
new Waypoint("FixRd",42.984295,-78.959352),
new Waypoint("I-190",43.004961,-78.948226)
];
traveler = '7_8';
segments = [
1205438,
1205439,
1205440,
1205441,
1205442,
1205443,
1205444,
1205445,
1205446,
1205447,
1205448,
1205449,
1205450,
1205451,
1205452,
1205453,
1205454,
1205455,
1205456,
1205457,
1205458,
1205459,
1205460,
1205461,
1205462,
1205463,
1205464,
1205465,
1205466,
1205467,
1205468,
1205469,
1205470,
1205471,
1205472,
1205473,
1205474,
1205475,
1205476,
1205477,
1205478,
1205479,
1205480,
1205481,
1205482,
1205483,
1205484,
1205485,
1205486,
1205487,
1205488,
1205489,
1205490,
1205491,
1205492,
1205493,
1205494,
1205495,
1205496,
1205497,
1205498,
1205499,
1205500,
1205501,
1205502,
1205503,
1205504,
1205505,
1205506,
1205507,
1205508,
1205509,
1205510,
1205511,
1205512,
1205513,
1205514,
1205515,
1205516,
1205517,
1205518,
1205519,
1205520,
1205521,
1205522,
1205523,
1205524,
1205525,
1205526,
1205527,
1205528,
1205529,
1205530,
1205531,
1205532,
1205533,
1205534
];
clinched = [
1205488
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}