From: | Johan De Meersman <vegivamp(at)tuxera(dot)be> |
---|---|
To: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org>, mysql <mysql(at)lists(dot)mysql(dot)com> |
Subject: | Re: Download States and Capitals Database |
Date: | 2011-09-28 05:43:10 |
Message-ID: | 67934d65-7db7-4186-9992-17d58408945f@zimbra |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
----- Original Message -----
> From: "Adarsh Sharma" <adarsh(dot)sharma(at)orkash(dot)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 geopolitical knowledge 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 hierarchy of 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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-09-28 06:52:28 | Re: Identifying old/unused views and table |
Previous Message | planas | 2011-09-28 04:27:28 | Re: Download States and Capitals Database |