<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Sql tables for all countries States and...
25 posts, Page 1 of 3
1
2
3
»
»»
Sql tables for all countries States and Cities
Rate Topic
Display Mode
Topic Options
Author
Message
manaprime
manaprime
Posted Monday, June 09, 2008 11:29 PM
Forum Newbie
Group: General Forum Members
Last Login: Saturday, August 23, 2008 11:59 PM
Points: 8,
Visits: 41
I need Sql tables for all countries States and Cities
Post #514155
ChiragNS
ChiragNS
Posted Monday, June 09, 2008 11:39 PM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365,
Visits: 1,825
If you mean designing the tables then you may want 3 tables
one each for country,state and city. Try designing them and then come to us for doubts/suggestions.
"Keep Trying"
Post #514158
manaprime
manaprime
Posted Tuesday, June 10, 2008 12:56 AM
Forum Newbie
Group: General Forum Members
Last Login: Saturday, August 23, 2008 11:59 PM
Points: 8,
Visits: 41
I need data for all countries and their states and then their cities. I want to build a web form where in dropdown i give user option to select a country then states for that country are loaded then by selecting state he can select the city. I can do that all if i got the data.
List of all countries , states and cities.
Post #514188
peter-775355
peter-775355
Posted Wednesday, June 11, 2008 12:30 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, March 09, 2010 2:32 AM
Points: 1,
Visits: 5
manaprime (6/10/2008)
I need data for all countries and their states and then their cities. I want to build a web form where in dropdown i give user option to select a country then states for that country are loaded then by selecting state he can select the city. I can do that all if i got the data.
Best to have a read about ISO 3166-2 and buy the database.
http://www.iso.org/iso/country_codes/iso_3166_databases/iso_3166-2_database.htm
and consider which languages these dropdowns will be displayed in for non-english counties.
Also “State” is not the correct heading – they are called subdivisions. Eg: Province, County, island, state, etc
Cities is elsewhere on the web, but I can't remember the link.
Post #514951
Peter Lavelle
Peter Lavelle
Posted Wednesday, June 11, 2008 12:41 AM
Valued Member
Group: General Forum Members
Last Login: Wednesday, September 29, 2010 8:03 PM
Points: 54,
Visits: 1,497
See also another link http://www.dak-tek.dakotta.com/Country_City_State_List.htm to buy from.
Not all countries use the concept of 'State'. If you are trying to capture an address then you may also need to allow for a ZIP/Postcode column in your database and the format of this varies widely Something like NVARCHAR(20) will probably be ok.
This information also changes from time to time. How will you know when it changes?
You might need to think about DateValidFrom and DateValidTo columns to preserve old values.
Post #514959
gazmanic
gazmanic
Posted Thursday, April 09, 2009 12:16 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, December 15, 2011 9:17 PM
Points: 3,
Visits: 31
http://27.org/isocountrylist/
download the http://27.org/isocountrylist/iso_country_list.sql
load into vim editor and save
fire this at your sql database and your off
currently looking for regions (subdivisions) and cities sql tables?
Post #693758
Edward Boyle-478467
Edward Boyle-478467
Posted Saturday, April 11, 2009 11:59 AM
Valued Member
Group: General Forum Members
Last Login: Saturday, May 18, 2013 1:47 PM
Points: 51,
Visits: 773
Free download at the US Census Bureau web site
http://www.census.gov/tiger/tms/gazetteer/places2k.txt
Post #695281
gazmanic
gazmanic
Posted Sunday, April 12, 2009 5:26 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, December 15, 2011 9:17 PM
Points: 3,
Visits: 31
Thanks for reply. So we have a list of all cities and positional data (guessing) which is helpful.
Not wanting to redo a wheel that must have been done many times before; ER diagramaticaly this is what I am after.
country -< region -< city
http://www.gefeg.com/edifact/d03a/s3/codes/cl1h.htm
I now have the ISO regions as per this link with the matching ISO country 2 char code. Which is easy to translate (using vim or your favourite editor) into an SQL table.
Understandably city is a big job and may not exist in 'ISO land'.
Post #695513
gazmanic
gazmanic
Posted Monday, April 13, 2009 6:33 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, December 15, 2011 9:17 PM
Points: 3,
Visits: 31
Even better we have ISO related codes down to city level ... and download-able in different formats.
http://www.unece.org/cefact/locode/
Same and as MySQL download but regions in 2 char alpha-numerics.
http://www.iplocationtools.com/sql_database.php
MySQL download but country -< cities only.
http://drupal.org/node/19983
Post #696258
hexahow
hexahow
Posted Tuesday, July 14, 2009 11:53 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, July 14, 2009 11:50 PM
Points: 1,
Visits: 0
Maybe this
http://www.geodatasource.com/world-major-cities.html
will help. It even has sample codes in ASP, .NET and PHP.
Post #753171
« Prev Topic
|
Next Topic »
25 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
