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. 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.
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.
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.
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.
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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);...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |