<!-- /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: "dc.beadr", tier: 4, color: "TMbrown", system: "usanp", label: "DC BeaDr" };
routeInfo[1] = { firstWaypoint: 7, root: "dc.clabarpkwy", tier: 4, color: "TMbrown", system: "usanp", label: "DC ClaBarPkwy" };
routeInfo[2] = { firstWaypoint: 9, root: "dc.dc295", tier: 4, color: "TMbrown", system: "usadc", label: "DC DC295" };
routeInfo[3] = { firstWaypoint: 16, root: "dc.gwmempkwy", tier: 4, color: "TMbrown", system: "usanp", label: "DC GWMemPkwy" };
routeInfo[4] = { firstWaypoint: 21, root: "dc.rockcrkpkwy", tier: 4, color: "TMbrown", system: "usanp", label: "DC RockCrkPkwy" };
routeInfo[5] = { firstWaypoint: 34, root: "dc.suipkwy", tier: 4, color: "TMbrown", system: "usanp", label: "DC SuiPkwy" };
routeInfo[6] = { firstWaypoint: 40, root: "dc.us001altwas", tier: 3, color: "TMmagenta", system: "usausb", label: "DC US1AltWas" };
routeInfo[7] = { firstWaypoint: 47, root: "dc.us001", tier: 2, color: "TMred", system: "usaus", label: "DC US1" };
routeInfo[8] = { firstWaypoint: 58, root: "dc.us029", tier: 2, color: "TMred", system: "usaus", label: "DC US29" };
routeInfo[9] = { firstWaypoint: 74, root: "dc.us050", tier: 2, color: "TMred", system: "usaus", label: "DC US50" };
routeInfo[10] = { firstWaypoint: 89, root: "dc.i066", tier: 1, color: "TMblue", system: "usai", label: "DC I-66" };
routeInfo[11] = { firstWaypoint: 94, root: "dc.i095", tier: 1, color: "TMblue", system: "usai", label: "DC I-95" };
routeInfo[12] = { firstWaypoint: 96, root: "dc.i295", tier: 1, color: "TMblue", system: "usai", label: "DC I-295" };
routeInfo[13] = { firstWaypoint: 101, root: "dc.i395", tier: 1, color: "TMblue", system: "usai", label: "DC I-395" };
routeInfo[14] = { firstWaypoint: 112, root: "dc.i495", tier: 1, color: "TMblue", system: "usai", label: "DC I-495" };
routeInfo[15] = { firstWaypoint: 114, root: "dc.i695", tier: 1, color: "TMblue", system: "usai", label: "DC I-695" };
waypoints = [
new Waypoint("RockCrkPkwy",38.920742,-77.051406),
new Waypoint("HarSt",38.928025,-77.043836),
new Waypoint("PorSt",38.933984,-77.048471),
new Waypoint("PinBraPkwy",38.935027,-77.04772),
new Waypoint("TilSt",38.939484,-77.05126),
new Waypoint("BlaAve",38.943356,-77.049565),
new Waypoint("BroBraRd",38.94419,-77.04963),
new Waypoint("MD/DC",38.936897,-77.116706),
new Waypoint("ChaBriRd",38.930354,-77.111793),
new Waypoint("1A",38.869618,-76.987634),
new Waypoint("1B",38.875198,-76.974592),
new Waypoint("ECapSt",38.889764,-76.958477),
new Waypoint("BenRd",38.895575,-76.95204),
new Waypoint("NHBurAve",38.902397,-76.943741),
new Waypoint("NashSt",38.907536,-76.938238),
new Waypoint("DC/MD",38.912265,-76.934123),
new Waypoint("VA/DC",38.875265,-77.04699),
new Waypoint("WasBlvd",38.882982,-77.057934),
new Waypoint("ArlMemBr",38.885738,-77.059865),
new Waypoint("US50",38.889279,-77.063835),
new Waypoint("DC/VA",38.88978,-77.064328),
new Waypoint("LinMemCir",38.889667,-77.051282),
new Waypoint("OhioDr",38.892223,-77.054914),
new Waypoint("FSt",38.897675,-77.0564),
new Waypoint("VirAve",38.900919,-77.057183),
new Waypoint("US29",38.902543,-77.056915),
new Waypoint("PenAve",38.904643,-77.05626),
new Waypoint("PSt",38.909636,-77.050424),
new Waypoint("WatDr_S",38.913059,-77.054393),
new Waypoint("+X954875",38.916815,-77.058449),
new Waypoint("WatDr_N",38.918702,-77.055337),
new Waypoint("BeaDr",38.920742,-77.051406),
new Waypoint("CatAve",38.921815,-77.05125),
new Waypoint("CalSt",38.923476,-77.052612),
new Waypoint("SouCapSt",38.865475,-77.002165),
new Waypoint("I-295",38.863011,-76.99936),
new Waypoint("MLKAve",38.860596,-76.994312),
new Waypoint("StaRd",38.853261,-76.983283),
new Waypoint("AlaAve",38.851189,-76.972747),
new Waypoint("DC/MD",38.849067,-76.965601),
new Waypoint("US1_S",38.903583,-77.0199),
new Waypoint("I-395",38.90491,-77.016081),
new Waypoint("NorCapSt",38.907348,-77.009056),
new Waypoint("MouOliRd",38.913601,-76.991125),
new Waypoint("US50_E",38.917335,-76.972468),
new Waypoint("SouDakAve",38.925177,-76.965145),
new Waypoint("DC/MD",38.930737,-76.957747),
new Waypoint("VA/DC",38.873929,-77.043343),
new Waypoint("I-395(1)",38.879249,-77.036197),
new Waypoint("MaiAve",38.883508,-77.03216),
new Waypoint("US50_W",38.8921,-77.032858),
new Waypoint("ConAve_E",38.892072,-77.019911),
new Waypoint("US50_E",38.903583,-77.0199),
new Waypoint("RhoIslAve_W",38.913023,-77.0199),
new Waypoint("NorCapSt",38.916792,-77.009045),
new Waypoint("MonAve",38.924568,-76.985605),
new Waypoint("SouDakAve",38.931278,-76.971569),
new Waypoint("DC/MD",38.935182,-76.963407),
new Waypoint("VA/DC",38.901153,-77.070508),
new Waypoint("MSt",38.904159,-77.069027),
new Waypoint("I-66",38.902543,-77.056915),
new Waypoint("NewHamAve_S",38.902539,-77.050123),
new Waypoint("17thSt",38.902539,-77.039426),
new Waypoint("15thSt",38.902531,-77.033643),
new Waypoint("11thSt_S",38.902522,-77.027045),
new Waypoint("11thSt_N",38.910537,-77.027056),
new Waypoint("RhoIslAve_E",38.912687,-77.020874),
new Waypoint("FloAve",38.916264,-77.021901),
new Waypoint("ColRd",38.927691,-77.023033),
new Waypoint("NewHamAve_N",38.936346,-77.024291),
new Waypoint("ArkAve",38.951533,-77.027389),
new Waypoint("MisAve",38.961129,-77.028024),
new Waypoint("PinBraRd",38.967526,-77.027486),
new Waypoint("DC/MD",38.98455,-77.026625),
new Waypoint("VA/DC",38.891751,-77.064532),
new Waypoint("I-66_W",38.891751,-77.062998),
new Waypoint("I-66_E",38.893471,-77.053385),
new Waypoint("23rdSt",38.892087,-77.050166),
new Waypoint("17thSt",38.892098,-77.039483),
new Waypoint("US1_S",38.8921,-77.032858),
new Waypoint("ConAve_E",38.892072,-77.019911),
new Waypoint("US1_N",38.903583,-77.0199),
new Waypoint("I-395",38.90491,-77.016081),
new Waypoint("NorCapSt",38.907348,-77.009056),
new Waypoint("MouOliRd",38.913601,-76.991125),
new Waypoint("US1Alt_N",38.917335,-76.972468),
new Waypoint("36thPl",38.916928,-76.957968),
new Waypoint("SouDakAve",38.918265,-76.954985),
new Waypoint("DC/MD",38.918103,-76.941395),
new Waypoint("VA/DC",38.89175,-77.064531),
new Waypoint("US50_W",38.891751,-77.062998),
new Waypoint("US50_E",38.893471,-77.053385),
new Waypoint("EStExpy",38.895909,-77.053256),
new Waypoint("US29",38.902543,-77.056915),
new Waypoint("VA/DC",38.792671,-77.038968),
new Waypoint("DC/MD",38.792685,-77.037579),
new Waypoint("MD/DC",38.804592,-77.022362),
new Waypoint("1",38.825901,-77.016692),
new Waypoint("2",38.845073,-77.007374),
new Waypoint("3",38.863011,-76.99936),
new Waypoint("5",38.869618,-76.987634),
new Waypoint("VA/DC",38.873929,-77.043343),
new Waypoint("1",38.879249,-77.036197),
new Waypoint("2",38.880068,-77.031402),
new Waypoint("3",38.882239,-77.02785),
new Waypoint("4",38.882402,-77.024009),
new Waypoint("5",38.882482,-77.021901),
new Waypoint("7",38.882386,-77.01247),
new Waypoint("8",38.885003,-77.012502),
new Waypoint("9",38.894799,-77.014144),
new Waypoint("10",38.899466,-77.014166),
new Waypoint("US50",38.90491,-77.016081),
new Waypoint("VA/DC",38.792671,-77.038968),
new Waypoint("DC/MD",38.792685,-77.037579),
new Waypoint("I-395",38.882386,-77.01247),
new Waypoint("1A",38.881617,-77.009102),
new Waypoint("1B",38.879604,-76.998742),
new Waypoint("1C",38.877892,-76.991539),
new Waypoint("2",38.876497,-76.990873),
new Waypoint("2A",38.869618,-76.987634)
];
traveler = 'mapcat';
segments = [
588734,
588735,
588736,
588737,
588738,
588739,
587918,
607743,
607744,
607745,
607746,
607747,
607748,
588193,
588194,
588195,
588196,
588740,
588741,
588742,
588743,
588744,
588745,
588746,
588747,
588748,
588749,
588750,
588751,
588837,
588838,
588839,
588840,
588841,
580387,
580388,
580389,
580390,
580391,
580392,
508356,
508357,
508358,
508359,
508360,
508361,
508362,
508363,
508364,
508365,
525420,
525421,
525422,
525423,
525424,
525425,
525426,
525427,
525428,
525429,
525430,
525431,
525432,
525433,
525434,
534841,
534842,
534843,
534844,
534845,
534846,
534847,
534848,
534849,
534850,
534851,
534852,
534853,
534854,
490148,
490149,
490150,
490151,
499262,
501650,
501651,
501652,
501653,
502097,
502098,
502099,
502100,
502101,
502102,
502103,
502104,
502105,
502106,
502867,
503837,
503838,
503839,
503840,
503841
];
clinched = [
588734,
588735,
588736,
588737,
588738,
588739,
587918,
607743,
607744,
607745,
607746,
607747,
607748,
588193,
588194,
588195,
588196,
588740,
588741,
588742,
588743,
588744,
588745,
588746,
588747,
588748,
588749,
588750,
588751,
588837,
588838,
588839,
588840,
588841,
580387,
580388,
580389,
580390,
580391,
580392,
508356,
508357,
508358,
508359,
508360,
508361,
508362,
508363,
508364,
508365,
525420,
525421,
525422,
525423,
525424,
525425,
525426,
525427,
525428,
525429,
525430,
525431,
525432,
525433,
525434,
534841,
534842,
534843,
534844,
534845,
534846,
534847,
534848,
534849,
534850,
534851,
534852,
534853,
534854,
490148,
490149,
490150,
490151,
499262,
501650,
501651,
501652,
501653,
502097,
502098,
502099,
502100,
502101,
502102,
502103,
502104,
502105,
502106,
502867,
503837,
503838,
503839,
503840,
503841
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}