Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download, /proc/kallsyms format, sqldatasource dal, wwwxxxenden

Links

XODOX
Impressum

#1: Download States and Capitals Database

Posted on 2011-09-27 08:48:59 by Adarsh Sharma

--------------040803070008040207000403
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------040803070008040207000403--

Report this message

#2: Re: Download States and Capitals Database

Posted on 2011-09-27 16:53:47 by planas

--=-tABgsKxdKrY0YEVRMplM
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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

--=-tABgsKxdKrY0YEVRMplM
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.32.2">
</HEAD>
<BODY TEXT="#000000" BGCOLOR="#ffffff">
On Tue, 2011-09-27 at 12:18 +0530, Adarsh Sharma wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
Dear all,<BR>
<BR>
I&nbsp; googled a lot&nbsp; and find&nbsp; data&nbsp; of all countries ,&nbsp; cities&nbsp; , location etc from&nbsp; Geo Spatial websites but I am able to find the data that shows all <B>states &amp; their respective capitals</B> in world.<BR>
Please let me know if anyone as prior information about this ?<BR>
<BR>
<BR>
Thanks<BR>
</BLOCKQUOTE>
<BR>
Try this link from Wikipedia <A HREF="http://en.wikipedia.org/wiki/World_capital_cities_by_country"> http://en.wikipedia.org/wiki/World_capital_cities_by_country</A> . I just searched for world capitals by country.<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
<FONT SIZE="4">Jay Lozier</FONT><BR>
<FONT SIZE="4">jslozier@gmail.com</FONT>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-tABgsKxdKrY0YEVRMplM--

Report this message

#3: Re: [GENERAL] Download States and Capitals Database

Posted on 2011-09-28 06:09:13 by Adarsh Sharma

--------------010101050008080900090506
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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
>


--------------010101050008080900090506--

Report this message

#4: Re: Download States and Capitals Database

Posted on 2011-09-28 06:27:28 by planas

--=-EfGQhWWFZNxOckoVC8pz
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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

--=-EfGQhWWFZNxOckoVC8pz
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.32.2">
</HEAD>
<BODY TEXT="#000000" BGCOLOR="#ffffff">
On Wed, 2011-09-28 at 09:39 +0530, Adarsh Sharma wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
This Link gives the capitals of all countries but I need the states and their capitals in all these countries too..<BR>
But I think this is not possible because very few countries are divided into states and some into cantons, county etc.<BR>
<BR>
<BR>
Thanks<BR>
<BR>
planas wrote: <BR>
<BLOCKQUOTE TYPE=CITE>
On Tue, 2011-09-27 at 12:18 +0530, Adarsh Sharma wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
Dear all,<BR>
<BR>
I&nbsp; googled a lot&nbsp; and find&nbsp; data&nbsp; of all countries ,&nbsp; cities&nbsp; , location etc from&nbsp; Geo Spatial websites but I am able to find the data that shows all <B>states &amp; their respective capitals</B> in world.<BR>
Please let me know if anyone as prior information about this ?<BR>
<BR>
<BR>
Thanks<BR>
</BLOCKQUOTE>
<BR>
Try this link from Wikipedia <A HREF="http://en.wikipedia.org/wiki/World_capital_cities_by_country"> http://en.wikipedia.org/wiki/World_capital_cities_by_country</A> . I just searched for world capitals by country.<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
<FONT SIZE="4">Jay Lozier</FONT><BR>
<FONT SIZE="4"><A HREF="mailto:jslozier@gmail.com">jslozier@gmail.com</A></FONT>
</TD>
</TR>
</TABLE>
</BLOCKQUOTE>
<BR>
</BLOCKQUOTE>
<BR>
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.<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
<FONT SIZE="4">Jay Lozier</FONT><BR>
<FONT SIZE="4">jslozier@gmail.com</FONT>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-EfGQhWWFZNxOckoVC8pz--

Report this message

#5: Re: [GENERAL] Download States and Capitals Database

Posted on 2011-09-28 07:43:10 by Johan De Meersman

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

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Report this message