Re: Download States and Capitals Database

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(at)gmail(dot)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(at)gmail(dot)com