Zip code

I have a database of zipcodes with latitude and longitude. I also have the
method of calculating the distance between two zipcodes. What I want to
know is if there is an efficient algorithm for obtaining the zip codes
within a specified distance of the first zipcode without having to retrieve
and calculate for every record in the database.

Shelly


.

Relevant Pages

  • Re: Zip code
    ... >>I have a database of zipcodes with latitude and longitude. ... >>method of calculating the distance between two zipcodes. ... have you looked at a zip code map for Manhattan? ...
    (comp.lang.php)
  • Split Data within a column.
    ... I have a database with 146,000 records. ... contains zipcodes with and without zip+4. ... All the records with a zip4 have a hypen. ... and one column zip4 with the digits past the hypen. ...
    (microsoft.public.access.queries)
  • Re: Obtain distances using zip codes?
    ... I don't know if this newsgroup will let me attach, but here is a database ... with all of the zipcodes and the distances from 01923. ... determine driving distance between my office address versus each employee ...
    (microsoft.public.access.macros)
  • Re: zip code from latitude-longitude?
    ... the Drupal project has a location module which contains a database table for zipcodes as well as data for US and Germany... ...
    (sci.geo.satellite-nav)
  • US Zipcode API for Ruby?
    ... Does anyone know of API (and database) for Ruby to provide information ... Also helpful would be zipcodes within a given ... If something doesn't exist natively for Ruby I might utilize a web service. ...
    (comp.lang.ruby)