- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No Results in Closest Lookup
I have a closest lookup configured and it is not pulling results at all. The locations are mapping without any issue, but cannot seem to find anything during the closest operation. What i need is closest within 1500 miles, by truck.
this is the start data set
Load * Inline [
DEST_ID,DEST_LOC
1499,"ALEXANDRIA,KY,US"
31,"ATHENS,OH,US"
2404,"BATAVIA,OH,US"
2748,"BEAVERCREEK,OH,US"
2781,"BELLEFONTAINE,OH,US"
1321,"BOTKINS,OH,US"
657,"CANAL WINCHESTER,OH,US"
2537,"CEDARVILLE,OH,US"
489,"CINCINNATI,OH,US"
1335,"CIRCLEVILLE,OH,US"
680,"COLUMBUS,OH,US"
2604,"DELAWARE,OH,US"
2457,"ETNA,OH,US"
843,"FAIRFIELD,OH,US"
2420,"FORT WRIGHT,KY,US"
2808,"FRANKLIN,OH,US"
3238,"GAHANNA,OH,US"
2163,"GALLIPOLIS,OH,US"
1358,"GROVE CITY,OH,US"
3001,"HAMILTON,OH,US"
1527,"HEATH,OH,US"
1927,"HILLIARD,OH,US"
1177,"LANCASTER,OH,US"
1117,"MAYSVILLE,KY,US"
2877,"MOUNT ORAB,OH,US"
442,"NEW BOSTON,OH,US"
2876,"NEWARK,OH,US"
2526,"PIQUA,OH,US"
2067,"PLAIN CITY,OH,US"
564,"REYNOLDSBURG,OH,US"
153,"SHARONVILLE,OH,US"
1077,"SIDNEY,OH,US"
223,"TIPP CITY,OH,US"
3014,"URBANA,OH,US"
1283,"WAVERLY,OH,US"
2174,"WEST JEFFERSON,OH,US"
2156,"WESTERVILLE,OH,US"
2855,"WHITEHALL,OH,US"
];
this is the set of points to which i want to find the closest 1:
load * Inline [
ORIGIN_ID,ORIGIN_LOC
1,"COMPTON,CA,US"
3,"WILMER,TX,US"
6,"CARLISLE,PA,US"
10,"PLEASANT PRAIRIE,WI,US"
13,"MCDONOUGH,GA,US"
];
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Thanks running QGA and sorry for the trouble. The QGA operation Closest has an upper limit of route distance, that depends on the number road links. And that is what happens in this case the routes becomes too long to run at the same time. Unfortunately there is no error message today, we will fix that in coming releases.
The workaround is to use QGA Operation Routes instead and calculate all possible routes and after that select the shortest.
See my example, note that I moved the the server call inside the first loop to make 100 calls at the time. That is best practice also if you have your own QGA Server.
Thanks,
Patric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the locations in the longer list are all within 1500 miles of the locations in the shorter list, i need to know which of the locations in the short list is closest.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
These are all subsets of a larger dataset. the _LOC fields are a Location Named Point (a US City,State). these location named points work for about 70% of the overall dataset. this subset SHOULD be getting a result for closest, but are not getting one no matter what type of lookup is performed. The named point also plots itself on a map, which verifies that geoanalytics knows where the location is.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Thanks running QGA and sorry for the trouble. The QGA operation Closest has an upper limit of route distance, that depends on the number road links. And that is what happens in this case the routes becomes too long to run at the same time. Unfortunately there is no error message today, we will fix that in coming releases.
The workaround is to use QGA Operation Routes instead and calculate all possible routes and after that select the shortest.
See my example, note that I moved the the server call inside the first loop to make 100 calls at the time. That is best practice also if you have your own QGA Server.
Thanks,
Patric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Patric! this worked out really well. i was able to incorporate the solution into the larger dataset and make it work as needed.