Re: Off topic : world database
От | Vernon |
---|---|
Тема | Re: Off topic : world database |
Дата | |
Msg-id | YSTQC0UP4WHCYWQUPVRRO7683ROVPHB.3e862c05@kimiko обсуждение исходный текст |
Ответ на | Re: Off topic : world database (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: Off topic : world database
|
Список | 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@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 >
В списке pgsql-sql по дате отправления: