Re: Zip code



In article <11ei85f8c660b49@xxxxxxxxxxxxxxxxxx>,
Gordon Burditt <gordonb.haqjl@xxxxxxxxxxx> wrote:
>>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.
>
>It depends on what you are doing, and how accurate you need to be.
>Is that distance supposed to be DRIVING distance or distance as
>the missile flies?
>
>Precomputing some of this can be used to advantage.
>



have you looked at a zip code map for Manhattan?

--
a d y k e s @ p a n i x . c o m

Don't blame me. I voted for Gore.
.



Relevant Pages

  • Re: Zip code
    ... >> I have a database of zipcodes with latitude and longitude. ... >> method of calculating the distance between two zipcodes. ... Imagine a circle of the specified range centred on the target zip code. ...
    (comp.lang.php)
  • Re: Zip code
    ... > I have a database of zipcodes with latitude and longitude. ... > method of calculating the distance between two zipcodes. ... Indexing latitude and longitude might help. ...
    (comp.lang.php)
  • Zip code
    ... I have a database of zipcodes with latitude and longitude. ... method of calculating the distance between two zipcodes. ...
    (comp.lang.php)
  • Re: formula of findinf a distance between two zip codes
    ... In the formula you reference, you aren't getting the distance between two ... Trying to get the distance between two zipcodes as you asked is meaningless ...
    (microsoft.public.access.gettingstarted)
  • Re: DBRW generating ADODB.Command error 800a0cc1
    ... Source: Microsoft JET Database Engine ... My guess the Distance variable is causing the problem. ... When I verify the query it says it was verified with the database ... I have 2 text boxes on the form, EnterZip and Distance, and I have the ...
    (microsoft.public.frontpage.programming)