Date: Sat, 29 Mar 2003 15:28:05 -0800
From: Vernon <vernonw@gatewaytech.com>
Subject: Re: Off topic : world database
In-reply-to: <20030327170321.GA28903@wolff.to>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-sql@postgresql.org
Reply-To: vernonw@gatewaytech.com
Message-id: <YSTQC0UP4WHCYWQUPVRRO7683ROVPHB.3e862c05@kimiko>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT


I have a related question: how to find out all postal codes within a distance, say 500 km, or 1000 km, of a giving postal 
code. Where I can get the data of US and Canada?

Thanks,

Vernon

27/03/2003 9:03:21 AM, Bruno Wolff III <bruno@wolff.to> wrote:

>On Thu, Mar 27, 2003 at 10:06:08 +1000,
>  Rudi Starcevic <rudi@oasis.net.au> wrote:
>> 
>> I've been searching for a source for this data without joy so far and 
>> would like to
>> ask if someone on this list could point me to or help with a source for 
>> this info.
>> Ideally I'd like Country,States,and Cities with Longitude and Latitude 
>> coordinates.
>
>You can get data for the US for free. With a combination of Tiger and FIPS
>data you can get Latitude and Longitude coordinates for street addresses.
>There was an entry related to this in last year's Google contest. Finding
>that entry will provide you with instructions for getting the data (unless
>the government has decided it is too dangerous because of possible terrorism
>since last summer). The project has some software for doing street address
>to to Latitude and Longitude conversion. You will need to decide what point
>in a city you will want to use.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>