From: Rudi Starcevic <rudi@oasis.net.au>
To: pgsql-sql@postgresql.org
Subject: Off topic : world database
Date: Thu, 27 Mar 2003 10:06:08 +1000
Message-ID: <3E824070.7070207@oasis.net.au> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rudi@oasis.net.au
Subject: Re: Off topic : world database
In-Reply-To: <3E824070.7070207@oasis.net.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox