[AccessD] Distance between zip codes

[Stuart McLachlan]

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
>