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  1970 
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.comwr ote in message
news:11******** *************@n 67g2000cwd.goog legroups.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.comwr ote in message
news:11******** *************@n 67g2000cwd.goog legroups.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.comwr ote in message
news:11******** *************@n 67g2000cwd.goog legroups.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.comwr ote in message
news:11******** *************@n 67g2000cwd.goog legroups.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 to insert the values and text to each drop down list.
So i want to create a script that populates a certain Drop Down List with
certain values when page loads such as:
|
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
structures?
Thanks for any hints,
Leszek Taratuta
|
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);
System.Data.SqlClient.SqlCommand dbCommand1 = new
System.Data.SqlClient.SqlCommand();
|
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 the second should
be determined by what is selected in the first drop down list. When the
page loads it automatically populates the second list with the default
value via a proceedure:
public void popDDL(string dbName)
|
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 drop down box , its corresponding states should be
populated in the state drop down box. If a state is selected , its corresponding
cities should be populated in the city drop down box. Where all these data has to be stored and retrieved. What...
| | |
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, ProductName, CategoryID, from tblCategoryProducts
Where (CategoryID = @CategoryID)
|
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 drop down box , its corresponding states should be
populated in the state drop down box. If a state is selected , its corresponding
cities should be populated in the city drop down box. Where all these data has to be stored and retrieved. What type...
|
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 make the state list changes corressponding to the change of the country list? etc. Canada -> only canada provinces... Thanks
|
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 state name should come from database according to country and in 3rd drop down cities name should come from database according to states.
I have tried many search engine but i could not get any proper info regarding this i mean some time i get whole...
|
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 entering one country?
Here is the current code which works for one state...however if I add another "State" (class=td100) row identical to the one below neither state field offers the drop down list.
<form name="form1" action="">
<table...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
