Re: Download States and Capitals Database - Mailing list pgsql-general

From Johan De Meersman
Subject Re: Download States and Capitals Database
Date
Msg-id 67934d65-7db7-4186-9992-17d58408945f@zimbra
Whole thread Raw
In response to Re: Download States and Capitals Database  (Adarsh Sharma <adarsh.sharma@orkash.com>)
Responses Re: Download States and Capitals Database  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
----- Original Message -----
> From: "Adarsh Sharma" <adarsh.sharma@orkash.com>
>
> This Link gives the capitals of all countries but I need the states
> and their capitals in all these countries too..
> But I think this is not possible because very few countries are
> divided into states and some into cantons, county etc.

Yep. The only one I can think of off the top of my head is the USA, although I can't exactly claim accurate
geopoliticalknowledge about the whole world :) 

Here in Belgium, we have a bunch of provinces. France has departements. It varies a lot. I suppose you could build a
hierarchyof geographical subdivisions, but you'd still have to save the appropriate naming schemes per-country. 



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

pgsql-general by date:

Previous
From: planas
Date:
Subject: Re: Download States and Capitals Database
Next
From: Guillaume Lelarge
Date:
Subject: Re: Identifying old/unused views and table