X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 753C847632B
	for <pgsql-sql@postgresql.org>; Wed, 26 Mar 2003 19:02:56 -0500 (EST)
Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2])
	by postgresql.org (Postfix) with ESMTP id 1449D47631F
	for <pgsql-sql@postgresql.org>; Wed, 26 Mar 2003 19:02:55 -0500 (EST)
Received: from oasis.net.au (guardian [210.8.139.5])
	by water.oasis.net.au (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id
	KAA03587
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2003 10:03:58 +1000
X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5]
	claimed to be oasis.net.au
Message-ID: <3E824070.7070207@oasis.net.au>
Date: Thu, 27 Mar 2003 10:06:08 +1000
From: Rudi Starcevic <rudi@oasis.net.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Off topic : world database
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-14.3 required=5.0
	tests=BAYES_01,USER_AGENT_MOZILLA_UA,X_AUTH_WARNING
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200303/593
X-Sequence-Number: 12631

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.