[AccessD] Distance between zip codes

[Rocky Smolin]

That is PRECISELY what I need - well, the client needs.  Thanks so much.  Is
that your work?  It's very fast.

Best,

Rocky


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Tuesday, May 23, 2017 7:14 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Distance between zip codes

Interesting little challenge, that didn't take nearly as long as I expected.
Check out:

http://www.camcopng.com/download/USZipCodeDistances.zip

Access database containing all 33,000+ US Zip codes from the link I posted
earlier.

Select ZIP  code from combobox. Enter maximum distance in text box, click
button.


17 seconds?    It takes this application about 1 second to find and  display
all  ZIPs within x 
miles of the selected ZIP..

:-)



On 23 May 2017 at 6:35, Rocky Smolin wrote:

> I've found a couple of zip/lat/long free downloads and fond some code 
> that calculates the distance.  So I think I may be covered. To take 
> one zip code and calculate the distance to all the others takes about
> 15 seconds on my i7 box with SSD.  
> 
> R
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Jim Dettman Sent: Tuesday, May 23, 2017 5:27 AM To: 'Access 
> Developers discussion and problem solving' Subject: Re: [AccessD] 
> Distance between zip codes
> 
> Rocky,
> 
>  I'm not aware of any tool, other than using a web browser control and  
> one of the mapping services (Google, Bing, or Mapquest)
> 
>  The problem with all the mapping services is that at some point, you  
> need to start paying to use it.  They only allow so many free calls a 
> day.
> 
>  But I do have code to do this more or less.   What I do is given a
>  list of
> lat/long's, a point, and a number of miles, figure out who in that 
> list is in the radius.
> 
>  In my case it is the location of people, but it could easily be zips.
>   All
> you'd need is a list of the lat/long for each.
> 
> Jim.
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Rocky Smolin Sent: Tuesday, May 23, 2017 07:37 AM To: 'Access 
> Developers discussion and problem solving' Subject: [AccessD] Distance 
> between zip codes
> 
> Dear List:
> 
> 
> 
> I have a client who wants to know all of the zip codes that lie within 
> a certain radius of a selected zip code.
> 
> 
> 
> I seem to recall some discussion about this on the list but it could 
> have been 15 years ago now.
> 
> 
> 
> Is there some tool available that can be dropped into and Access FE 
> (using 2010 now).
> 
> 
> 
> MTIA
> 
> 
> 
> 
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 760-683-5777
> 
>  <http://www.bchacc.com> www.bchacc.com
> 
>  <http://www.e-z-mrp.com> www.e-z-mrp.com
> 
> Skype: rocky.smolin
> 
> 
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com