From: | Vernon <vernonw(at)gatewaytech(dot)com> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Off topic : world database |
Date: | 2003-03-29 23:28:05 |
Message-ID: | YSTQC0UP4WHCYWQUPVRRO7683ROVPHB.3e862c05@kimiko |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)wolff(dot)to> wrote:
>On Thu, Mar 27, 2003 at 10:06:08 +1000,
> Rudi Starcevic <rudi(at)oasis(dot)net(dot)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(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tomasz Myrta | 2003-03-30 06:56:26 | Re: to_number |
Previous Message | Alain Gougeon | 2003-03-29 23:14:38 | Re: Off topic : world database |