So I've done some searching on google and found easy pages where I can basically seed the URL with the points and then screen-scrape the distance between the two points, like this: https://www.freemaptools.com/how-far-is-it-between-muhlenberg_-pa,-united-st...
At this point, this client has asked me to query for other locations near their target location where they have had business. So the City, State already exists, giving me the ability to search other locations using the 2 points between each other. HOWEVER, next challenge is the best, most efficient way to do this. I don't have that plan yet. I know my SEARCH city, state. I know other city/states on file in the database. The quick crude thought is to plot that custom URL with the OTHER city/state values where they've conducted business and then show those that are within X miles, defined in the UI (just like when you say "show me all the cars 50 miles within zip code 21117."
I know there's gotta be a better way but at this point I'm polling the list for how to do that EFFICIENTLY. Meanwhile, I'll keep searching google (including API) for alternative help.
Thanks in advance! --Mike
On 2017-03-15 03:32, Alan Bourke wrote:
Yeah, as much location data as you can get (address, Zip, lat & long) and the Google API. -- Alan Bourke alanpbourke (at) fastmail (dot) fm
On Wed, 15 Mar 2017, at 05:23 AM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
(to be done in VFP9SP2 existing app)
Customer need: to grab/query towns near a certain zip code or city name, akin to like when you use an app where you're looking for a car and say "show me matches within 50 miles." I'm thinking latitude/longitude and google somehow, but I thought I'd poll the community to see what you'd recommend.
Thanks! --Mike
[excessive quoting removed by server]