function waypointsFromSQL() { routeInfo[0] = { firstWaypoint: 0, root: "esppv.a124", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A124" }; routeInfo[1] = { firstWaypoint: 9, root: "esppv.a124lab", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A124Lab" }; routeInfo[2] = { firstWaypoint: 13, root: "esppv.a126", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A126" }; routeInfo[3] = { firstWaypoint: 18, root: "esppv.a126san", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A126San" }; routeInfo[4] = { firstWaypoint: 20, root: "esppv.a132", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A132" }; routeInfo[5] = { firstWaypoint: 33, root: "esppv.a623", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A623" }; routeInfo[6] = { firstWaypoint: 36, root: "esppv.a624", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A624" }; routeInfo[7] = { firstWaypoint: 49, root: "esppv.a625", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A625" }; routeInfo[8] = { firstWaypoint: 63, root: "esppv.a627", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV A627" }; routeInfo[9] = { firstWaypoint: 67, root: "esppv.bi604", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI604" }; routeInfo[10] = { firstWaypoint: 73, root: "esppv.bi623", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI623" }; routeInfo[11] = { firstWaypoint: 83, root: "esppv.bi624", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI624" }; routeInfo[12] = { firstWaypoint: 88, root: "esppv.bi625", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI625" }; routeInfo[13] = { firstWaypoint: 101, root: "esppv.bi625urd", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI625Urd" }; routeInfo[14] = { firstWaypoint: 104, root: "esppv.bi626", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI626" }; routeInfo[15] = { firstWaypoint: 108, root: "esppv.bi627", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI627" }; routeInfo[16] = { firstWaypoint: 113, root: "esppv.bi629", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI629" }; routeInfo[17] = { firstWaypoint: 115, root: "esppv.bi630", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI630" }; routeInfo[18] = { firstWaypoint: 121, root: "esppv.bi630amb", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI630Amb" }; routeInfo[19] = { firstWaypoint: 126, root: "esppv.bi631", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI631" }; routeInfo[20] = { firstWaypoint: 157, root: "esppv.bi633", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI633" }; routeInfo[21] = { firstWaypoint: 167, root: "esppv.bi635", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI635" }; routeInfo[22] = { firstWaypoint: 178, root: "esppv.bi636", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI636" }; routeInfo[23] = { firstWaypoint: 195, root: "esppv.bi637", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI637" }; routeInfo[24] = { firstWaypoint: 204, root: "esppv.bi638", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV BI638" }; routeInfo[25] = { firstWaypoint: 206, root: "esppv.gi011", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV GI11" }; routeInfo[26] = { firstWaypoint: 209, root: "esppv.gi020", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV GI20" }; routeInfo[27] = { firstWaypoint: 220, root: "esppv.gi040", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV GI40" }; routeInfo[28] = { firstWaypoint: 228, root: "esppv.gi041", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV GI41" }; routeInfo[29] = { firstWaypoint: 231, root: "esppv.gi627", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV GI627" }; routeInfo[30] = { firstWaypoint: 254, root: "esppv.gi631", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV GI631" }; routeInfo[31] = { firstWaypoint: 270, root: "esppv.gi636", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV GI636" }; routeInfo[32] = { firstWaypoint: 288, root: "esppv.gi638", tier: 5, color: "TMyellow", system: "esppv", label: "ESP-PV GI638" }; waypoints = [ new Waypoint("RI/PV",42.487527,-2.476537), new Waypoint("A3226",42.501276,-2.494798), new Waypoint("A3220",42.52032,-2.510934), new Waypoint("A3218",42.516145,-2.52265), new Waypoint("+X764839",42.53452,-2.548957), new Waypoint("A3210",42.548085,-2.5805), new Waypoint("A3228",42.55817,-2.586143), new Waypoint("A2124",42.577497,-2.644787), new Waypoint("PV/RI",42.566483,-2.687187), new Waypoint("RI/PV",42.580088,-2.779498), new Waypoint("A3202_E",42.588557,-2.78969), new Waypoint("A3202_W",42.589931,-2.795548), new Waypoint("PV/RI",42.601967,-2.8231), new Waypoint("NC/PV",42.627233,-2.464864), new Waypoint("A3136",42.636544,-2.481934), new Waypoint("A2126",42.628054,-2.494519), new Waypoint("A3130",42.627549,-2.507426), new Waypoint("PV/CL",42.64354,-2.526003), new Waypoint("A132",42.670257,-2.357662), new Waypoint("PV/NC",42.656198,-2.384741), new Waypoint("N104",42.849635,-2.645774), new Waypoint("A2130",42.840211,-2.616398), new Waypoint("A4159",42.8383,-2.586105), new Waypoint("A3112",42.810546,-2.538099), new Waypoint("+X566403",42.791559,-2.528014), new Waypoint("+X813557",42.789744,-2.510167), new Waypoint("A4122",42.75222,-2.475572), new Waypoint("A4124",42.738278,-2.447049), new Waypoint("+X507436",42.736599,-2.436073), new Waypoint("+X924334",42.677987,-2.387767), new Waypoint("A126",42.670257,-2.357662), new Waypoint("A2128",42.673822,-2.345855), new Waypoint("PV/NC",42.682317,-2.314929), new Waypoint("N240",42.9826,-2.645935), new Waypoint("+X779819",43.005997,-2.643757), new Waypoint("Ara/Biz",43.029235,-2.652018), new Waypoint("N622",42.962955,-2.852057), new Waypoint("+X777803",42.982109,-2.868204), new Waypoint("AP68",43.01596,-2.91047), new Waypoint("A2522",43.019584,-2.914153), new Waypoint("A3616",43.026698,-2.958219), new Waypoint("A625",43.047691,-2.992165), new Waypoint("LanKal",43.054896,-3.000051), new Waypoint("A4610",43.059591,-3.02506), new Waypoint("A3622",43.075753,-3.041453), new Waypoint("A4620",43.094864,-3.071355), new Waypoint("A2604",43.123602,-3.12119), new Waypoint("A2602",43.121848,-3.130932), new Waypoint("PV/CL",43.14338,-3.162045), new Waypoint("Biz/Ara",43.146053,-2.939959), new Waypoint("A2522",43.14446,-2.946095), new Waypoint("LarKal",43.138698,-2.953691), new Waypoint("A3638",43.132748,-2.963519), new Waypoint("TxiKal",43.117447,-2.984247), new Waypoint("Lui_N",43.102393,-2.999182), new Waypoint("Lui_S",43.095186,-3.00386), new Waypoint("A3622",43.08464,-3.003109), new Waypoint("UriKal",43.074562,-3.000083), new Waypoint("LanKal",43.064279,-2.996736), new Waypoint("A624",43.047691,-2.992165), new Waypoint("+X429940",43.038031,-2.991221), new Waypoint("+X339427",43.021027,-3.012636), new Waypoint("Ara/Biz",43.013269,-3.006574), new Waypoint("N240",42.949881,-2.63733), new Waypoint("A3006",42.960882,-2.613201), new Waypoint("A3002",42.962217,-2.59007), new Waypoint("Ara/Gip",42.968521,-2.584877), new Waypoint("JulUrqKal",43.26821,-2.954013), new Waypoint("IbaKal",43.274503,-2.954228), new Waypoint("BI3741",43.289858,-2.960901), new Waypoint("5",43.295512,-2.953262), new Waypoint("N637",43.298947,-2.953649), new Waypoint("BI704/735",43.303226,-2.946889), new Waypoint("Ara/Biz",43.029235,-2.652018), new Waypoint("BI2543",43.04675,-2.656395), new Waypoint("+X589969",43.079954,-2.662168), new Waypoint("Urk",43.100897,-2.646267), new Waypoint("+X109369",43.111847,-2.644958), new Waypoint("BI4336",43.135527,-2.662135), new Waypoint("ArrKal",43.161965,-2.633371), new Waypoint("BI4331",43.170471,-2.645034), new Waypoint("N634",43.176238,-2.643473), new Waypoint("AP8",43.17977,-2.642555), new Waypoint("BI636",43.185293,-3.204167), new Waypoint("AveEnc",43.185904,-3.203588), new Waypoint("CalCal",43.185591,-3.202622), new Waypoint("+X206992",43.17923,-3.20657), new Waypoint("PV/CL",43.170193,-3.194404), new Waypoint("Biz/Ara",43.146053,-2.939959), new Waypoint("AtxKal",43.150628,-2.940849), new Waypoint("AP68(2)",43.15813,-2.935538), new Waypoint("+X653038",43.18006,-2.913233), new Waypoint("BI3524",43.178362,-2.905412), new Waypoint("BI712",43.203017,-2.89597), new Waypoint("AP68(1)",43.203142,-2.892666), new Waypoint("BI3702",43.208054,-2.884769), new Waypoint("BI3701",43.215904,-2.882795), new Waypoint("CalLap",43.221893,-2.875135), new Waypoint("CalArt",43.229242,-2.877624), new Waypoint("A8",43.231603,-2.87653), new Waypoint("N634",43.235816,-2.869663), new Waypoint("Ara/Biz",43.013269,-3.006574), new Waypoint("BI2521",42.993379,-3.004804), new Waypoint("BI2625",42.988294,-3.008602), new Waypoint("MazZum",43.267784,-2.933006), new Waypoint("BI629",43.270409,-2.931236), new Waypoint("BI627_S",43.283696,-2.933929), new Waypoint("N637",43.287093,-2.937706), new Waypoint("AgiLehEto",43.271343,-2.941643), new Waypoint("UgaAuz",43.272893,-2.940677), new Waypoint("BI629",43.273886,-2.939862), new Waypoint("BI626_S",43.283696,-2.933929), new Waypoint("N637",43.287093,-2.937706), new Waypoint("BI627",43.273886,-2.939862), new Waypoint("BI626",43.270409,-2.931236), new Waypoint("CB/PV",43.244257,-3.254507), new Waypoint("BI3614",43.242045,-3.213544), new Waypoint("BI2701",43.213991,-3.176366), new Waypoint("+X925451",43.206537,-3.175757), new Waypoint("CalTor",43.196385,-3.191786), new Waypoint("BI636",43.197355,-3.185284), new Waypoint("CB/PV",43.252705,-3.391771), new Waypoint("BI4678",43.249266,-3.37364), new Waypoint("BI4675",43.233543,-3.349226), new Waypoint("BI4671",43.24321,-3.30369), new Waypoint("PV/CB",43.237325,-3.293281), new Waypoint("AP8",43.243765,-2.930474), new Waypoint("GerLorKal",43.247641,-2.926086), new Waypoint("MirEto",43.245441,-2.918828), new Waypoint("BI712",43.247004,-2.909864), new Waypoint("N634_E",43.250611,-2.901313), new Waypoint("CamAzk",43.25442,-2.898754), new Waypoint("ArbZeh",43.261773,-2.896802), new Waypoint("BI3750",43.265406,-2.904945), new Waypoint("AvrAuz",43.264749,-2.907338), new Waypoint("BI3741",43.269816,-2.906377), new Waypoint("BI3715_S",43.280595,-2.898513), new Waypoint("9",43.285438,-2.890863), new Waypoint("10",43.289186,-2.880628), new Waypoint("11",43.307474,-2.880006), new Waypoint("13",43.320338,-2.875157), new Waypoint("BI3715_N",43.33203,-2.869556), new Waypoint("LarBid",43.339709,-2.864213), new Waypoint("18",43.358199,-2.856059), new Waypoint("19",43.360414,-2.843957), new Waypoint("BI2121",43.357169,-2.837434), new Waypoint("BI2101",43.373237,-2.801342), new Waypoint("+X817310",43.388162,-2.780957), new Waypoint("+X493885",43.381838,-2.774579), new Waypoint("+X741064",43.397673,-2.760165), new Waypoint("BI4207",43.404888,-2.760401), new Waypoint("+X887097",43.41041,-2.762954), new Waypoint("+X179552",43.409112,-2.755728), new Waypoint("+X874423",43.418048,-2.747569), new Waypoint("BI2235_W",43.419501,-2.734131), new Waypoint("+X981472",43.413995,-2.726862), new Waypoint("BI2235_E",43.416844,-2.714551), new Waypoint("N634",43.165901,-2.604607), new Waypoint("AP8",43.168221,-2.602129), new Waypoint("LeaMar",43.176617,-2.58183), new Waypoint("BI2301",43.21178,-2.543453), new Waypoint("BI2224",43.252892,-2.526684), new Waypoint("BI3448",43.265144,-2.506685), new Waypoint("+X638186",43.287718,-2.491729), new Waypoint("BI2405",43.297011,-2.475464), new Waypoint("+X394957",43.319589,-2.454929), new Waypoint("BI638",43.319425,-2.422872), new Waypoint("BI3334",43.218641,-2.73109), new Waypoint("N634",43.222222,-2.727136), new Waypoint("AP8",43.224106,-2.728472), new Waypoint("KarKal",43.22649,-2.730596), new Waypoint("Kat",43.236418,-2.724416), new Waypoint("BI3231",43.255401,-2.690883), new Waypoint("BI2121",43.289046,-2.689183), new Waypoint("JuanCalKal",43.301165,-2.684569), new Waypoint("TxaInd",43.304694,-2.676866), new Waypoint("BI2224",43.320011,-2.667618), new Waypoint("BI2238",43.322586,-2.668777), new Waypoint("A8",43.267925,-2.964571), new Waypoint("5",43.269175,-2.971222), new Waypoint("6",43.25583,-2.969956), new Waypoint("7",43.246422,-2.979741), new Waypoint("10",43.234964,-3.007164), new Waypoint("15",43.20602,-3.042569), new Waypoint("16",43.193632,-3.047075), new Waypoint("19",43.197902,-3.077481), new Waypoint("22",43.208304,-3.105204), new Waypoint("BI3621",43.207475,-3.110161), new Waypoint("BI3602",43.205567,-3.122681), new Waypoint("+X264373",43.197418,-3.155415), new Waypoint("BI3651",43.202986,-3.174427), new Waypoint("BI630",43.197355,-3.185284), new Waypoint("Ins",43.191442,-3.190407), new Waypoint("BI624",43.185293,-3.204167), new Waypoint("PV/CL",43.172384,-3.223457), new Waypoint("SopSai",43.374843,-2.996435), new Waypoint("BI3737",43.362989,-3.002551), new Waypoint("BI3738",43.342533,-2.996392), new Waypoint("GobKal",43.333013,-3.001885), new Waypoint("BI2731",43.325572,-2.987101), new Waypoint("CalKan",43.322141,-2.98032), new Waypoint("BI747",43.315874,-2.968476), new Waypoint("9",43.310054,-2.962489), new Waypoint("N637",43.301993,-2.962639), new Waypoint("Gip/Biz",43.320737,-2.41313), new Waypoint("BI633",43.319425,-2.422872), new Waypoint("0",43.276643,-2.015959), new Waypoint("1",43.282204,-2.018523), new Waypoint("2",43.289378,-2.018968), new Waypoint("AP1/8_E",43.304468,-1.89483), new Waypoint("4",43.308816,-1.917586), new Waypoint("5a",43.313641,-1.944301), new Waypoint("5b",43.31521,-1.94531), new Waypoint("7",43.313173,-1.96784), new Waypoint("9B",43.297807,-1.973784), new Waypoint("9A",43.298354,-1.982582), new Waypoint("10",43.295824,-1.996636), new Waypoint("12",43.298698,-2.00803), new Waypoint("13",43.289378,-2.018968), new Waypoint("AP1/8_W",43.28928,-2.036752), new Waypoint("GI20_E",43.313641,-1.944301), new Waypoint("OtxPas",43.310448,-1.948045), new Waypoint("UbaBid",43.303156,-1.952407), new Waypoint("SarPas",43.302188,-1.952616), new Waypoint("GI2137",43.301532,-1.956671), new Waypoint("GI41",43.301071,-1.959343), new Waypoint("3",43.295395,-1.967561), new Waypoint("GI20_W",43.297807,-1.973784), new Waypoint("0",43.288577,-1.956189), new Waypoint("GI40",43.301071,-1.959343), new Waypoint("LoiErrPas",43.307364,-1.973441), new Waypoint("Ara/Gip",42.968521,-2.584877), new Waypoint("GI3310_S",42.974763,-2.574942), new Waypoint("+X101434",42.979346,-2.56211), new Waypoint("+X758668",42.99214,-2.561639), new Waypoint("GI3310_N",43.013261,-2.536576), new Waypoint("+X587340",43.016117,-2.524838), new Waypoint("AP1(123)",43.021835,-2.520569), new Waypoint("GI3131",43.031412,-2.501964), new Waypoint("BabPol",43.034329,-2.502286), new Waypoint("GI2620",43.046969,-2.499733), new Waypoint("GI3554",43.056487,-2.491708), new Waypoint("N636",43.075942,-2.462718), new Waypoint("GI2630",43.080361,-2.448449), new Waypoint("A636",43.099181,-2.429631), new Waypoint("GI3360",43.109286,-2.418258), new Waypoint("+X743072",43.116022,-2.417142), new Waypoint("AP1(8)",43.123101,-2.426498), new Waypoint("GI2632",43.126954,-2.425382), new Waypoint("OsiAuzDis",43.148155,-2.411821), new Waypoint("OsiAuzHer",43.162478,-2.400084), new Waypoint("SerAtxKal",43.169106,-2.407594), new Waypoint("GI3331",43.177892,-2.420232), new Waypoint("N630",43.1931,-2.437731), new Waypoint("N634",43.280275,-2.267239), new Waypoint("AP1/8",43.268581,-2.27108), new Waypoint("GI2633",43.251892,-2.260952), new Waypoint("GI3272",43.219016,-2.256864), new Waypoint("+X381315",43.206458,-2.25091), new Waypoint("GI2634_E",43.178424,-2.259922), new Waypoint("GI2435",43.177368,-2.262003), new Waypoint("GI2634_W",43.174106,-2.320218), new Waypoint("+X327964",43.152319,-2.344744), new Waypoint("+X775819",43.125889,-2.35013), new Waypoint("+X124239",43.111683,-2.332814), new Waypoint("GI3803",43.108321,-2.318775), new Waypoint("MatKal",43.098695,-2.317107), new Waypoint("OkeKal",43.091648,-2.311748), new Waypoint("GI2632",43.086104,-2.310165), new Waypoint("A636",43.078768,-2.307867), new Waypoint("GI20",43.308816,-1.917586), new Waypoint("SorKal",43.317169,-1.912522), new Waypoint("NafEto",43.319011,-1.906965), new Waypoint("GI2638_W",43.318262,-1.901965), new Waypoint("GI2132",43.311315,-1.880593), new Waypoint("GI3632",43.32019,-1.867472), new Waypoint("GI2638_E",43.329829,-1.851583), new Waypoint("JaiAuz",43.331437,-1.840392), new Waypoint("JaiHir",43.328815,-1.831369), new Waypoint("ToAP1/8",43.329907,-1.827593), new Waypoint("GI2134",43.331133,-1.8249), new Waypoint("N638",43.347491,-1.812015), new Waypoint("LetHir",43.345678,-1.800299), new Waypoint("PieLotiKal",43.344929,-1.79619), new Waypoint("IpaHir",43.343953,-1.788615), new Waypoint("AveJTL",43.340618,-1.780601), new Waypoint("N121A",43.342455,-1.760055), new Waypoint("ESP/FRA",43.344199,-1.761187), new Waypoint("N634",43.290998,-2.363617), new Waypoint("+X989188",43.299182,-2.356364), new Waypoint("+X942895",43.308473,-2.372725), new Waypoint("GI3230",43.306911,-2.38781), new Waypoint("+X947136",43.309394,-2.407486), new Waypoint("Gip/Biz",43.320737,-2.41313) ]; traveler = 'michih'; segments = [ 246794, 246795, 246796, 246797, 246798, 246799, 246800, 246801, 246802, 246803, 246804, 246806, 246807, 246808, 246809, 246805, 246810, 246811, 246812, 246813, 246814, 246815, 246816, 246817, 246818, 246819, 246820, 246821, 246822, 246823, 246824, 246825, 246826, 246827, 246828, 246829, 246830, 246831, 246832, 246833, 246834, 246835, 246836, 246837, 246838, 246839, 246840, 246841, 246842, 246843, 246844, 246845, 246846, 246847, 246848, 246849, 246850, 246851, 246852, 246853, 246854, 246855, 246856, 246857, 246858, 246859, 246860, 246861, 246862, 246863, 246864, 246865, 246866, 246867, 246868, 246869, 246870, 246871, 246872, 246873, 246874, 246875, 246876, 246877, 246878, 246879, 246880, 246881, 246882, 246883, 246884, 246885, 246886, 246887, 246888, 246889, 246890, 246891, 246896, 246897, 246898, 246899, 246900, 246892, 246893, 246894, 246895, 246901, 246902, 246903, 246904, 246905, 246906, 246907, 246908, 246909, 246910, 246911, 246912, 246913, 246914, 246915, 246916, 246917, 246918, 246919, 246920, 246921, 246922, 246923, 246924, 246925, 246926, 246927, 246928, 246929, 246930, 246931, 246932, 246933, 246934, 246935, 246936, 246937, 246938, 246939, 246940, 246941, 246942, 246943, 246944, 246945, 246946, 246947, 246948, 246949, 246950, 246951, 246952, 246953, 246954, 246955, 246956, 246957, 246958, 246959, 246960, 246961, 246962, 246963, 246964, 246965, 246966, 246967, 246968, 246969, 246970, 246971, 246972, 246973, 246974, 246975, 246976, 246977, 246978, 246979, 246980, 246981, 246982, 246983, 246984, 246985, 246986, 246987, 246988, 246989, 246990, 246991, 246992, 246993, 246994, 246995, 246996, 246997, 246998, 246999, 247000, 247001, 247002, 247003, 247004, 247005, 247006, 247007, 247008, 247009, 247010, 247011, 247012, 247013, 247014, 247015, 247016, 247017, 247018, 247019, 247020, 247021, 247022, 247023, 247024, 247025, 247026, 247027, 247028, 247029, 247030, 247031, 247032, 247033, 247034, 247035, 247036, 247037, 247038, 247039, 247040, 247041, 247042, 247043, 247044, 247045, 247046, 247047, 247048, 247049, 247050, 247051, 247052, 247053, 247054 ]; clinched = [ 246975, 246976, 246977, 246978, 246979, 246980, 246981, 246982, 246983, 246984, 246985, 246986, 246992, 246993, 246994 ]; mapClinched = true; mapStatus = mapStates.MAPVIEW; genEdges = true; }