Message-ID: <3E82C5EA.6000808@klaster.net>
Date: Thu, 27 Mar 2003 10:35:38 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL;
 rv:1.3) Gecko/20030312
MIME-Version: 1.0
To: Rudi Starcevic <rudi@oasis.net.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Off topic : world database
References: <3E824070.7070207@oasis.net.au>
In-Reply-To: <3E824070.7070207@oasis.net.au>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

Uz.ytkownik Rudi Starcevic napisa?:
> Hi,
>=20
> I have a slightly off SQL topic question which I don't think is too=20
> inappropriate,
> if it is please let me know and I'll not push my luck again of my=20
> *favorite email list*.
>=20
> I'd like to build a Postgresql database of Countries,States and Cities=20
> of the world.
> I would like to use 'earthdistance' module so distance queries are=20
> possible.
> I plan to expose this data as an SOAP webservice via xmethods.com for=20
> others to
> access as well.
>=20
> I've been searching for a source for this data without joy so far and=20
> would like to
> ask if someone on this list could point me to or help with a source for=
=20
> this info.
> Ideally I'd like Country,States,and Cities with Longitude and Latitude=20
> coordinates.
>=20
> Thank you kindly,
> Again if this is too off topic let me know and I'll keep all my=20
> questions strictly to SQL.
> Regards
> Rudi.
Did you try to ask people related to PostGIS ? They work with maps, so=20
maybe they know where to get such list without license problems.

Regards,
Tomasz Myrta