From: | Rudi Starcevic <rudi(at)oasis(dot)net(dot)au> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Off topic : world database |
Date: | 2003-03-27 00:06:08 |
Message-ID: | 3E824070.7070207@oasis.net.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I have a slightly off SQL topic question which I don't think is too
inappropriate,
if it is please let me know and I'll not push my luck again of my
*favorite email list*.
I'd like to build a Postgresql database of Countries,States and Cities
of the world.
I would like to use 'earthdistance' module so distance queries are possible.
I plan to expose this data as an SOAP webservice via xmethods.com for
others to
access as well.
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.
Thank you kindly,
Again if this is too off topic let me know and I'll keep all my
questions strictly to SQL.
Regards
Rudi.
From | Date | Subject | |
---|---|---|---|
Next Message | Tamir Halperin | 2003-03-27 01:33:21 | Re: Off topic : world database |
Previous Message | fabio | 2003-03-26 23:04:48 | Re: Executing SQL commands via triggers without the use of procedures |