[AccessD] Distance between zip codes

[Stuart McLachlan]

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
>