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.