[AccessD] Distance between zip codes

[Rocky Smolin]

Really nice stuff.

R


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

Yep, all my own work (apart from the data which came from the earlier link).

I already had the trig and distance functions in an old sailing application
which I wrote many years ago.  So I just had to built the tables, form and
the GetZipsWithinDistance function.

 

On 23 May 2017 at 7:40, Rocky Smolin wrote:

> 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
> 
> --
> 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