Thread: Download States and Capitals Database

Dear all,

I  googled a lot  and find  data  of all countries ,  cities  , location etc from  Geo Spatial websites but I am able to find the data that shows all states & their respective capitals in world.
Please let me know if anyone as prior information about this ?


Thanks

On Tue, 2011-09-27 at 12:18 +0530, Adarsh Sharma wrote:

Dear all,

I  googled a lot  and find  data  of all countries ,  cities  , location etc from  Geo Spatial websites but I am able to find the data that shows all states & their respective capitals in world.
Please let me know if anyone as prior information about this ?


Thanks

Try this link from Wikipedia http://en.wikipedia.org/wiki/World_capital_cities_by_country . I just searched for world capitals by country.

-- Jay Lozier jslozier@gmail.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.


Thanks

planas wrote:

On Tue, 2011-09-27 at 12:18 +0530, Adarsh Sharma wrote:

Dear all,

I  googled a lot  and find  data  of all countries ,  cities  , location etc from  Geo Spatial websites but I am able to find the data that shows all states & their respective capitals in world.
Please let me know if anyone as prior information about this ?


Thanks

Try this link from Wikipedia http://en.wikipedia.org/wiki/World_capital_cities_by_country . I just searched for world capitals by country.

-- Jay Lozier jslozier@gmail.com

On Wed, 2011-09-28 at 09:39 +0530, Adarsh Sharma wrote:

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.


Thanks

planas wrote:

On Tue, 2011-09-27 at 12:18 +0530, Adarsh Sharma wrote:

Dear all,

I  googled a lot  and find  data  of all countries ,  cities  , location etc from  Geo Spatial websites but I am able to find the data that shows all states & their respective capitals in world.
Please let me know if anyone as prior information about this ?


Thanks

Try this link from Wikipedia http://en.wikipedia.org/wiki/World_capital_cities_by_country . I just searched for world capitals by country.

-- Jay Lozier jslozier@gmail.com

I would try Wikipedia and search for lists of states, cantons, provinces, etc of each country. The lists I have needed have had the capitals listed for each state, etc. Tedious but if you have to google for list it might be easier.

-- Jay Lozier jslozier@gmail.com

----- 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

On 28/09/11 13:43, Johan De Meersman wrote:
>
> ----- 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 :) 

Australia has states, as does India.

I won't be shocked to hear that there's somewhere with more than two
levels, eg country->state->province->provincial capital .

BTW, Adarsh, you seem to have cross-posted to the MySQL mailing list.
Cross posting is rude enough when you're cross-posting to several Pg
lists, but intermingling mysql and Pg mailing list replies is just going
to get messy. PLEASE DO NOT POST MESSAGES TO MORE THAN ONE MAILING LIST
IN THE SAME MESSAGE.

--
Craig Ringer

Craig Ringer wrote:

On 28/09/11 13:43, Johan De Meersman wrote: 

----- 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 geopolitical knowledge about the whole world :)   

Australia has states, as does India.

I won't be shocked to hear that there's somewhere with more than two
levels, eg country->state->province->provincial capital .

BTW, Adarsh, you seem to have cross-posted to the MySQL mailing list.
Cross posting is rude enough when you're cross-posting to several Pg
lists, but intermingling mysql and Pg mailing list replies is just going
to get messy. PLEASE DO NOT POST MESSAGES TO MORE THAN ONE MAILING LIST
IN THE SAME MESSAGE. 

Really Apologies my mistake and fell sorry for that.
I will take care about this in future.


Thanks