function waypointsFromSQL() {
routeInfo[0] = { firstWaypoint: 0, root: "tx.re002", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE2" };
routeInfo[1] = { firstWaypoint: 3, root: "tx.re003", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE3" };
routeInfo[2] = { firstWaypoint: 6, root: "tx.re004", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE4" };
routeInfo[3] = { firstWaypoint: 10, root: "tx.re006", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE6" };
routeInfo[4] = { firstWaypoint: 12, root: "tx.re007", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE7" };
routeInfo[5] = { firstWaypoint: 14, root: "tx.re008", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE8" };
routeInfo[6] = { firstWaypoint: 16, root: "tx.re009", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE9" };
routeInfo[7] = { firstWaypoint: 18, root: "tx.re010", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE10" };
routeInfo[8] = { firstWaypoint: 20, root: "tx.re011", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE11" };
routeInfo[9] = { firstWaypoint: 24, root: "tx.re255", tier: 5, color: "TMyellow", system: "usatxre", label: "TX RE255" };
waypoints = [
new Waypoint("RouCanRA",29.57649,-100.975598),
new Waypoint("CamReal",29.587938,-100.965115),
new Waypoint("US277/377",29.606444,-100.866302),
new Waypoint("FM273",33.63277,-96.166023),
new Waypoint("LakeBonDr",33.642117,-96.136535),
new Waypoint("CR2610",33.642317,-96.135957),
new Waypoint("BigCrePark",30.332724,-96.582056),
new Waypoint("LakDr",30.350661,-96.614075),
new Waypoint("CR472",30.360379,-96.619142),
new Waypoint("FM60",30.362379,-96.617227),
new Waypoint("SowCrePark",31.989129,-98.45666),
new Waypoint("FM1476",31.993224,-98.454884),
new Waypoint("TX72",28.460137,-98.420033),
new Waypoint("End",28.469961,-98.382539),
new Waypoint("TX72",28.448704,-98.357699),
new Waypoint("ChoCanSP",28.463807,-98.355349),
new Waypoint("End",31.57657,-99.676326),
new Waypoint("FM2134",31.57312,-99.657308),
new Waypoint("FM1929",31.517882,-99.635332),
new Waypoint("End",31.530411,-99.640569),
new Waypoint("FM1929",31.50089,-99.721713),
new Waypoint("OldFM2134",31.529328,-99.720535),
new Waypoint("CR4763",31.542685,-99.703426),
new Waypoint("End",31.553738,-99.709365),
new Waypoint("US69",30.937279,-94.417129),
new Waypoint("CR3910",30.984469,-94.277839),
new Waypoint("CR23",30.982266,-94.205065),
new Waypoint("TX63",31.031125,-94.174247),
new Waypoint("CR49",31.056907,-94.129508),
new Waypoint("TwinDikPark",31.069677,-94.05616),
new Waypoint("FM1007",31.06358,-94.035154),
new Waypoint("US96",31.056284,-93.983295),
new Waypoint("CR200",31.057808,-93.965812),
new Waypoint("CR1053",31.055481,-93.837542),
new Waypoint("TX87",31.094433,-93.729295),
new Waypoint("+x55784-91",31.11034,-93.679789),
new Waypoint("FR196",31.126554,-93.664464),
new Waypoint("QuaDr",31.133109,-93.626564),
new Waypoint("FM692",31.161094,-93.5723)
];
traveler = 'duke87';
segments = [
794295,
794296,
794297,
794298,
794299,
794300,
794301,
794302,
794303,
794304,
794305,
794306,
794307,
794308,
794309,
794310,
794311,
794312,
794313,
794314,
794315,
794316,
794317,
794318,
794319,
794320,
794321,
794322,
794323
];
clinched = [
794304,
794313,
794314,
794315,
794316,
794317,
794318
];
mapClinched = true;
mapStatus = mapStates.MAPVIEW;
genEdges = true;
}