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-states-and-owings-mills_-md,-united-states.htm

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,
[email protected] 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]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to