473,320 Members | 2,162 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Country and county drop down lists for data-entry.

Hi guys,

[Apologies if this post is a little off topic. Please let me know if
there is a more suitable place to post this question.]

I'm designing a web-site that will allow users to look up other people,
based on certain criteria. The most important criterion is geographical
location. I've managed to find a really comprehensive country list
(which is great), but I'm a little stuck as to what to do for the
next level down in the hierarchy.

At the moment, I've just got a free text box that the user can type
their area into, but as I expected, this is being misused. Some people
are typing their city, while others are entering their county. This is
a problem, because it relies on users that are trying to find them
second-guessing what was typed into the area box.

It would be great if I could get hold of a list of
counties/states/districts below each country, and maybe even a list
cities/sub-divisions below that. I know these lists exist because
dating sites, for instance, expose them. (I don't fancy sitting there
and ripping off pages of lists from dating sites; this probably isn't
legal anyway!)

Can anyone suggest a good way to provide the user with a list of
counties etc...

Thanks in advance,

Steve.

Dec 17 '06 #1
4 1953
You're going to have to build your own database or buy one. Maybe this helps
you start:

http://www.census.gov/datamap/fipslist/AllSt.txt

<st*************@hotmail.comwrote in message
news:11*********************@n67g2000cwd.googlegro ups.com...
Hi guys,

[Apologies if this post is a little off topic. Please let me know if
there is a more suitable place to post this question.]

I'm designing a web-site that will allow users to look up other people,
based on certain criteria. The most important criterion is geographical
location. I've managed to find a really comprehensive country list
(which is great), but I'm a little stuck as to what to do for the
next level down in the hierarchy.

At the moment, I've just got a free text box that the user can type
their area into, but as I expected, this is being misused. Some people
are typing their city, while others are entering their county. This is
a problem, because it relies on users that are trying to find them
second-guessing what was typed into the area box.

It would be great if I could get hold of a list of
counties/states/districts below each country, and maybe even a list
cities/sub-divisions below that. I know these lists exist because
dating sites, for instance, expose them. (I don't fancy sitting there
and ripping off pages of lists from dating sites; this probably isn't
legal anyway!)

Can anyone suggest a good way to provide the user with a list of
counties etc...

Thanks in advance,

Steve.

Dec 17 '06 #2
ISO-standard country and subdivision lists are available from the ISO
organization. You can buy the ISO-3166-1 (country codes) and ISO 3166-2
(country subdivision codes) lists either as PDF files or as Access 2000
databases.

Go here:
http://www.iso.org/iso/en/prods-serv...6ma/index.html

HTH,
Tom Dacon
Dacon Software Consulting
<st*************@hotmail.comwrote in message
news:11*********************@n67g2000cwd.googlegro ups.com...
Hi guys,

[Apologies if this post is a little off topic. Please let me know if
there is a more suitable place to post this question.]

I'm designing a web-site that will allow users to look up other people,
based on certain criteria. The most important criterion is geographical
location. I've managed to find a really comprehensive country list
(which is great), but I'm a little stuck as to what to do for the
next level down in the hierarchy.

At the moment, I've just got a free text box that the user can type
their area into, but as I expected, this is being misused. Some people
are typing their city, while others are entering their county. This is
a problem, because it relies on users that are trying to find them
second-guessing what was typed into the area box.

It would be great if I could get hold of a list of
counties/states/districts below each country, and maybe even a list
cities/sub-divisions below that. I know these lists exist because
dating sites, for instance, expose them. (I don't fancy sitting there
and ripping off pages of lists from dating sites; this probably isn't
legal anyway!)

Can anyone suggest a good way to provide the user with a list of
counties etc...

Thanks in advance,

Steve.


Dec 17 '06 #3
Thanks for your help Tom!

That ISO link was exactly what I was looking for, and at £150, it's a
fair bit cheaper than I thought it would be. Once my site has made
£150, I'll consider some reinvestment!

All the best,

Steve.

Tom Dacon wrote:
ISO-standard country and subdivision lists are available from the ISO
organization. You can buy the ISO-3166-1 (country codes) and ISO 3166-2
(country subdivision codes) lists either as PDF files or as Access 2000
databases.

Go here:
http://www.iso.org/iso/en/prods-serv...6ma/index.html

HTH,
Tom Dacon
Dacon Software Consulting
<st*************@hotmail.comwrote in message
news:11*********************@n67g2000cwd.googlegro ups.com...
Hi guys,

[Apologies if this post is a little off topic. Please let me know if
there is a more suitable place to post this question.]

I'm designing a web-site that will allow users to look up other people,
based on certain criteria. The most important criterion is geographical
location. I've managed to find a really comprehensive country list
(which is great), but I'm a little stuck as to what to do for the
next level down in the hierarchy.

At the moment, I've just got a free text box that the user can type
their area into, but as I expected, this is being misused. Some people
are typing their city, while others are entering their county. This is
a problem, because it relies on users that are trying to find them
second-guessing what was typed into the area box.

It would be great if I could get hold of a list of
counties/states/districts below each country, and maybe even a list
cities/sub-divisions below that. I know these lists exist because
dating sites, for instance, expose them. (I don't fancy sitting there
and ripping off pages of lists from dating sites; this probably isn't
legal anyway!)

Can anyone suggest a good way to provide the user with a list of
counties etc...

Thanks in advance,

Steve.
Dec 17 '06 #4
Hi Steve,
I was also looking for the same information , before
buying i just needed an infor from ur side , Could u let me knw , how
the Subdivisions are maintained for india, just an example

Regards

Thomson
Bands-Online Steve wrote:
Thanks for your help Tom!

That ISO link was exactly what I was looking for, and at £150, it's a
fair bit cheaper than I thought it would be. Once my site has made
£150, I'll consider some reinvestment!

All the best,

Steve.

Tom Dacon wrote:
ISO-standard country and subdivision lists are available from the ISO
organization. You can buy the ISO-3166-1 (country codes) and ISO 3166-2
(country subdivision codes) lists either as PDF files or as Access 2000
databases.

Go here:
http://www.iso.org/iso/en/prods-serv...6ma/index.html

HTH,
Tom Dacon
Dacon Software Consulting
<st*************@hotmail.comwrote in message
news:11*********************@n67g2000cwd.googlegro ups.com...
Hi guys,
>
[Apologies if this post is a little off topic. Please let me know if
there is a more suitable place to post this question.]
>
I'm designing a web-site that will allow users to look up other people,
based on certain criteria. The most important criterion is geographical
location. I've managed to find a really comprehensive country list
(which is great), but I'm a little stuck as to what to do for the
next level down in the hierarchy.
>
At the moment, I've just got a free text box that the user can type
their area into, but as I expected, this is being misused. Some people
are typing their city, while others are entering their county. This is
a problem, because it relies on users that are trying to find them
second-guessing what was typed into the area box.
>
It would be great if I could get hold of a list of
counties/states/districts below each country, and maybe even a list
cities/sub-divisions below that. I know these lists exist because
dating sites, for instance, expose them. (I don't fancy sitting there
and ripping off pages of lists from dating sites; this probably isn't
legal anyway!)
>
Can anyone suggest a good way to provide the user with a list of
counties etc...
>
Thanks in advance,
>
Steve.
>
>
Dec 18 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Miguel Dias Moura | last post by:
Hello, i have an ASP.NET / VB page where i have a few 4 groups of Drop Down Lists. Each group of Drop Down Lists include 3 Drop Down Lists for date such as: DAY, MONTH, and YEAR. I don't want...
13
by: Leszek Taratuta | last post by:
Hello, I have several drop-down lists on my ASP.NET page. I need to keep data sources of these lists in Session State. What would be the most effective method to serialize this kind of data...
5
by: Vigneshwar Pilli via DotNetMonster.com | last post by:
string connectionString1 = "server=(local); user=sa;password=sa; database=sonic"; System.Data.SqlClient.SqlConnection dbConnection1 = new System.Data.SqlClient.SqlConnection(connectionString1);...
1
by: accyboy1981 | last post by:
Hi, I new to C# so please forgive me if this is simple. I've got 2 drop down lists the first is hard coded with data where as the second is populated from a database. The options that appear in...
10
by: somaskarthic | last post by:
Hi In my php page , there is a user registration form. Here the user has to select the country, state, city from the drop down box. How this can be handled in php? If a country is selected in a...
8
by: Ed Dror | last post by:
Hi there ASP.NET 2.0 VB & SQL Express Lest take Northwind Categories Products as example I create a table that hold these two together and I create a stored procedure like select ProductID,...
5
by: jakas | last post by:
Hi In my php page , there is a user registration form. Here the user has to select the country, state, city from the drop down box. How this can be handled in php? If a country is selected in a...
1
by: icepoint | last post by:
Hey everyone, Can anyone tell me how to make dynamice drop down lists for country and states? I have the models for country and states build and have the country drop down list worked, so how can I...
7
by: tokcy | last post by:
Hi everyone, I need the world database of country state and city. Actually i have three drop down option in my project in 1st drop down country name should come from database and 2nd drop down...
5
by: bennever | last post by:
Hi, I plan to use drop down lists to populate team results and will use the standard country/state drop down lists as the base code. The question: how can I populate multiple (5) states from...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.