Hello,
I need to create an Internet based, asp.net webform where a user can select
multiple cities in a state.
as you know the number of cities in a state can be very large.
What is the best way of designing such thing.
I need to give the user the best experience possible
Should I use a Tree control with check boxes
check boxes on one page or multiple pages alphabetized lists
I can add select all cities, clear all cities.
Also is there a way of Shift Click to select a block of cites all at once.
Should I use list boxes instead of checkboxes, like select a city from one
list box (left) to move to the selected cites list box (right) etc...
Example sites, new Ideas are welcome.
If you have done this what worked for you and what would you do differently
now.
Is it a good candidate for AJAX?
Thank you,
Lit
20  1652 
"Lit" <sq**********@hotmail.comwrote in message
news:O4**************@TK2MSFTNGP03.phx.gbl...
I need to create an Internet based, asp.net webform where a user can
select multiple cities in a state.
OK.
as you know the number of cities in a state can be very large.
How large is very large...?
What is the best way of designing such thing.
I'd use a DropDownList for the states and a multi-select listbox for the
cities.
I can add select all cities, clear all cities.
No problem - you can do that with client-side JavaScript.
Also is there a way of Shift Click to select a block of cites all at once.
Yes.
Should I use list boxes instead of checkboxes, like select a city from
one list box (left) to move to the selected cites list box (right) etc...
I'd use a multi-select listbox...
Is it a good candidate for AJAX?
Yes.
--
Mark Rae
ASP.NET MVP http://www.markrae.net
Hi Mark,
The number of Cities Max that I know is 2284, but could be down to 1914
cities.
Where do you see AJAX in the scenario?
How do you go about doing the Shift select a block?
Have you done this before and Is there a website that I can see it running
to see the look and feel?
Thank you for all your input and help.
Lit.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:un**************@TK2MSFTNGP03.phx.gbl...
"Lit" <sq**********@hotmail.comwrote in message
news:O4**************@TK2MSFTNGP03.phx.gbl...
>I need to create an Internet based, asp.net webform where a user can
select multiple cities in a state.
OK.
>as you know the number of cities in a state can be very large.
How large is very large...?
>What is the best way of designing such thing.
I'd use a DropDownList for the states and a multi-select listbox for the
cities.
>I can add select all cities, clear all cities.
No problem - you can do that with client-side JavaScript.
>Also is there a way of Shift Click to select a block of cites all at
once.
Yes.
>Should I use list boxes instead of checkboxes, like select a city from
one list box (left) to move to the selected cites list box (right)
etc...
I'd use a multi-select listbox...
>Is it a good candidate for AJAX?
Yes.
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
I haven't done this before, myself, but in answer to your question - on a
listbox, just set it's select mode to multiple
--
David Wier
MVP/ASPInsider http://aspnet101.com http://iWritePro.com
"Lit" <sq**********@hotmail.comwrote in message
news:OX**************@TK2MSFTNGP06.phx.gbl...
Hi Mark,
The number of Cities Max that I know is 2284, but could be down to 1914
cities.
Where do you see AJAX in the scenario?
How do you go about doing the Shift select a block?
Have you done this before and Is there a website that I can see it running
to see the look and feel?
Thank you for all your input and help.
Lit.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:un**************@TK2MSFTNGP03.phx.gbl...
>"Lit" <sq**********@hotmail.comwrote in message
news:O4**************@TK2MSFTNGP03.phx.gbl...
>>I need to create an Internet based, asp.net webform where a user can
select multiple cities in a state.
OK.
>>as you know the number of cities in a state can be very large.
How large is very large...?
>>What is the best way of designing such thing.
I'd use a DropDownList for the states and a multi-select listbox for the
cities.
>>I can add select all cities, clear all cities.
No problem - you can do that with client-side JavaScript.
>>Also is there a way of Shift Click to select a block of cites all at
once.
Yes.
>>Should I use list boxes instead of checkboxes, like select a city from
one list box (left) to move to the selected cites list box (right)
etc...
I'd use a multi-select listbox...
>>Is it a good candidate for AJAX?
Yes.
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
"Lit" <sq**********@hotmail.comwrote in message
news:OX**************@TK2MSFTNGP06.phx.gbl...
The number of Cities Max that I know is 2284, but could be down to 1914
cities.
Wow! Which state is that...?
Where do you see AJAX in the scenario?
To repopulate the cities when you change state...
How do you go about doing the Shift select a block?
Set the listbox's Select mode to Multiple...
Have you done this before
Yes...
is there a website that I can see it running to see the look and feel?
No. I've never done it on a public Internet site, only on corporate
intranets...
--
Mark Rae
ASP.NET MVP http://www.markrae.net
Ajax would significantly enhance the user experience.
I have done something similar with continents and countries... while
not as big a list as with cities in a state, the amount of data that
would be transferred when clicking a state with 2000 cities is quite
small in Ajax terms.
To Ajaxify this approach, I would put a dropdown list and a listbox
with multiselect on the form, then wrap the two up in an Ajax
UpdatePanel (don't forget to also add an Ajax ScriptManager control).
Hope this helps.
-- Hans
On Jul 24, 7:15 pm, "David Wier" <davidw...@davidwier.nospam.com>
wrote:
I haven't done this before, myself, but in answer to your question - on a
listbox, just set it's select mode to multiple
--
David Wier
MVP/ASPInsiderhttp://aspnet101.comhttp://iWritePro.com
"Lit" <sql_agent...@hotmail.comwrote in message
news:OX**************@TK2MSFTNGP06.phx.gbl...
Hi Mark,
The number of Cities Max that I know is 2284, but could be down to 1914
cities.
Where do you see AJAX in the scenario?
How do you go about doing the Shift select a block?
Have you done this before and Is there a website that I can see it running
to see the look and feel?
Thank you for all your input and help.
Lit.
"Mark Rae [MVP]" <m...@markNOSPAMrae.netwrote in message
news:un**************@TK2MSFTNGP03.phx.gbl...
"Lit" <sql_agent...@hotmail.comwrote in message
news:O4**************@TK2MSFTNGP03.phx.gbl...
>I need to create an Internet based, asp.net webform where a user can
select multiple cities in a state.
OK.
>as you know the number of cities in a state can be very large.
How large is very large...?
>What is the best way of designing such thing.
I'd use a DropDownList for the states and a multi-select listbox for the
cities.
>I can add select all cities, clear all cities.
No problem - you can do that with client-side JavaScript.
>Also is there a way of Shift Click to select a block of cites all at
once.
Yes.
>Should I use list boxes instead of checkboxes, like select a city from
one list box (left) to move to the selected cites list box (right)
etc...
I'd use a multi-select listbox...
>Is it a good candidate for AJAX?
Yes.
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
One possible benefit of using two multi-select list boxes with "Add to List"
and "Remove from List" buttons is that you could allow the user to work with
more than one state at a time (if that would be necessary).
For example, the user could select California from the drop-down list,
select Sacramento, Los Angeles, and San Diego, then click "Add to List". The
user could then choose New York from the state list, which would AJAXically
re-populate the cities list (leaving your selections unchanged).
I don't know how you would pull that off using any other selection method
without seriously complicating the interface.
"Lit" <sq**********@hotmail.comwrote in message
news:OX**************@TK2MSFTNGP06.phx.gbl...
Hi Mark,
The number of Cities Max that I know is 2284, but could be down to 1914
cities.
Where do you see AJAX in the scenario?
How do you go about doing the Shift select a block?
Have you done this before and Is there a website that I can see it running
to see the look and feel?
Thank you for all your input and help.
Lit.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:un**************@TK2MSFTNGP03.phx.gbl...
>"Lit" <sq**********@hotmail.comwrote in message
news:O4**************@TK2MSFTNGP03.phx.gbl...
>>I need to create an Internet based, asp.net webform where a user can
select multiple cities in a state.
OK.
>>as you know the number of cities in a state can be very large.
How large is very large...?
>>What is the best way of designing such thing.
I'd use a DropDownList for the states and a multi-select listbox for the
cities.
>>I can add select all cities, clear all cities.
No problem - you can do that with client-side JavaScript.
>>Also is there a way of Shift Click to select a block of cites all at
once.
Yes.
>>Should I use list boxes instead of checkboxes, like select a city from
one list box (left) to move to the selected cites list box (right)
etc...
I'd use a multi-select listbox...
>>Is it a good candidate for AJAX?
Yes.
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Hi Mark,
1914 State name is Pennsylvania, USA
The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes Data.
I know it is not one of what you call contenental USA.
I will double check all of that but I am dealing with but I have to thing
of the MAX and test what if I have a list of 3000 or 5000
What solution would be best. Think about paging Grids and how good that
is.
If you have to do this all over again would you do the same thing on your
IntraNet Solution and what do you do differently for the Internet???
Thank you Mark for all your input
Lit
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:ul**************@TK2MSFTNGP05.phx.gbl...
"Lit" <sq**********@hotmail.comwrote in message
news:OX**************@TK2MSFTNGP06.phx.gbl...
>The number of Cities Max that I know is 2284, but could be down to 1914
cities.
Wow! Which state is that...?
>Where do you see AJAX in the scenario?
To repopulate the cities when you change state...
>How do you go about doing the Shift select a block?
Set the listbox's Select mode to Multiple...
>Have you done this before
Yes...
>is there a website that I can see it running to see the look and feel?
No. I've never done it on a public Internet site, only on corporate
intranets...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Hans,
I am trying to compile all the good ideas you and others given me so far and
see what I can come up with.
I might have more questions, once I look into some prototypes.
Many thanks for your input...
Lit
"Froefel" <ha************@gmail.comwrote in message
news:11**********************@k79g2000hse.googlegr oups.com...
Ajax would significantly enhance the user experience.
I have done something similar with continents and countries... while
not as big a list as with cities in a state, the amount of data that
would be transferred when clicking a state with 2000 cities is quite
small in Ajax terms.
To Ajaxify this approach, I would put a dropdown list and a listbox
with multiselect on the form, then wrap the two up in an Ajax
UpdatePanel (don't forget to also add an Ajax ScriptManager control).
Hope this helps.
-- Hans
On Jul 24, 7:15 pm, "David Wier" <davidw...@davidwier.nospam.com>
wrote:
>I haven't done this before, myself, but in answer to your question - on a
listbox, just set it's select mode to multiple
--
David Wier
MVP/ASPInsiderhttp://aspnet101.comhttp://iWritePro.com
"Lit" <sql_agent...@hotmail.comwrote in message
news:OX**************@TK2MSFTNGP06.phx.gbl...
Hi Mark,
The number of Cities Max that I know is 2284, but could be down to
1914
cities.
Where do you see AJAX in the scenario?
How do you go about doing the Shift select a block?
Have you done this before and Is there a website that I can see it
running
to see the look and feel?
Thank you for all your input and help.
Lit.
"Mark Rae [MVP]" <m...@markNOSPAMrae.netwrote in message
news:un**************@TK2MSFTNGP03.phx.gbl...
"Lit" <sql_agent...@hotmail.comwrote in message
news:O4**************@TK2MSFTNGP03.phx.gbl...
>>I need to create an Internet based, asp.net webform where a user can
select multiple cities in a state.
>OK.
>>as you know the number of cities in a state can be very large.
>How large is very large...?
>>What is the best way of designing such thing.
>I'd use a DropDownList for the states and a multi-select listbox for
the
cities.
>>I can add select all cities, clear all cities.
>No problem - you can do that with client-side JavaScript.
>>Also is there a way of Shift Click to select a block of cites all at
once.
>Yes.
>>Should I use list boxes instead of checkboxes, like select a city
from
one list box (left) to move to the selected cites list box (right)
etc...
>I'd use a multi-select listbox...
>>Is it a good candidate for AJAX?
>Yes.
>--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Brandon,
Good thoughts, It could be a needed possibility ( Multiple Cities from
Multiple States), but not sure at this time.
I agree with you and I like to keep the interface simple but affective.
I also can shorten the list by County.!!
Thank you for your input.
Lit
"Brandon Gano" <bg***@inocompany.comwrote in message
news:E8**********************************@microsof t.com...
One possible benefit of using two multi-select list boxes with "Add to
List" and "Remove from List" buttons is that you could allow the user to
work with more than one state at a time (if that would be necessary).
For example, the user could select California from the drop-down list,
select Sacramento, Los Angeles, and San Diego, then click "Add to List".
The user could then choose New York from the state list, which would
AJAXically re-populate the cities list (leaving your selections
unchanged).
I don't know how you would pull that off using any other selection method
without seriously complicating the interface.
"Lit" <sq**********@hotmail.comwrote in message
news:OX**************@TK2MSFTNGP06.phx.gbl...
>Hi Mark,
The number of Cities Max that I know is 2284, but could be down to 1914
cities.
Where do you see AJAX in the scenario?
How do you go about doing the Shift select a block?
Have you done this before and Is there a website that I can see it
running to see the look and feel?
Thank you for all your input and help.
Lit.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:un**************@TK2MSFTNGP03.phx.gbl...
>>"Lit" <sq**********@hotmail.comwrote in message
news:O4**************@TK2MSFTNGP03.phx.gbl...
I need to create an Internet based, asp.net webform where a user can
select multiple cities in a state.
OK.
as you know the number of cities in a state can be very large.
How large is very large...?
What is the best way of designing such thing.
I'd use a DropDownList for the states and a multi-select listbox for the
cities.
I can add select all cities, clear all cities.
No problem - you can do that with client-side JavaScript.
Also is there a way of Shift Click to select a block of cites all at
once.
Yes.
Should I use list boxes instead of checkboxes, like select a city from
one list box (left) to move to the selected cites list box (right)
etc...
I'd use a multi-select listbox...
Is it a good candidate for AJAX?
Yes.
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Hi Mark,
Can anybody else verify this if you have the USPS data????
The USPS database tables have city names listed as Preferred name ,
Acceptable city names etc..
This accounts to the large numbers I have.
I meet some people that would like to use a city name that describes their
City section or area ( in this case a rich areas in a city that gives itself
a slightly different name, yet it is acceptable by the USPS).
I personally can not rely on Wikipedia 100%, it is edited by anyone. but the
57 count you found could be true.!
I was surprised by the number 1914. but that's what I have, and will check
again.
Thank you for your good input,
Lit.
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:e2****************@TK2MSFTNGP04.phx.gbl...
"Lit" <sq**********@hotmail.comwrote in message
news:e8**************@TK2MSFTNGP04.phx.gbl...
>1914 State name is Pennsylvania, USA
I guess it depends how you define "city"...
http://en.wikipedia.org/wiki/List_of...n_Pennsylvania
I count 57...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Mark,
FYI:
Texas has 254 Counties and 1515 Cities, But http://www.texasalmanac.com/facts said, 1210 cities and the difference
accounts to the acceptable city names.
So my thinking is assume 2000-3000 max... then what is the best way of
dealing with it.
Thank You,
Lit
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:e2****************@TK2MSFTNGP04.phx.gbl...
"Lit" <sq**********@hotmail.comwrote in message
news:e8**************@TK2MSFTNGP04.phx.gbl...
>1914 State name is Pennsylvania, USA
I guess it depends how you define "city"...
http://en.wikipedia.org/wiki/List_of...n_Pennsylvania
I count 57...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
re:
!The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes Data.
That must be a mistake.
Puerto Rico only has 78 towns/cities ( municipios ). http://factfinder.census.gov/servlet...U&-format=ST-2
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message news:e8**************@TK2MSFTNGP04.phx.gbl...
Hi Mark,
1914 State name is Pennsylvania, USA
The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes Data. I know it is not one of what you call
contenental USA.
I will double check all of that but I am dealing with but I have to thing of the MAX and test what if I have a list
of 3000 or 5000
What solution would be best. Think about paging Grids and how good that is.
If you have to do this all over again would you do the same thing on your IntraNet Solution and what do you do
differently for the Internet???
Thank you Mark for all your input
Lit
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message news:ul**************@TK2MSFTNGP05.phx.gbl...
>"Lit" <sq**********@hotmail.comwrote in message news:OX**************@TK2MSFTNGP06.phx.gbl...
>>The number of Cities Max that I know is 2284, but could be down to 1914 cities.
Wow! Which state is that...?
>>Where do you see AJAX in the scenario?
To repopulate the cities when you change state...
>>How do you go about doing the Shift select a block?
Set the listbox's Select mode to Multiple...
>>Have you done this before
Yes...
>>is there a website that I can see it running to see the look and feel?
No. I've never done it on a public Internet site, only on corporate intranets...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Juan,
Not to dwell on this one but.
USPS database has 78 Counties for Puerto Rico ( they call them counties -
may be cities ???) it matches your 78 count via the link you provided.
and 2284 Cities ( may be villages ) ??? with different name spellings (
Preferred and Acceptable etc... )
So for Puerto Rico I might have to use the counties as the cities. but who
knows?
Thank you for your input,
Lit
"Juan T. Llibre" <no***********@nowhere.comwrote in message
news:e7**************@TK2MSFTNGP03.phx.gbl...
re:
!The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes
Data.
That must be a mistake.
Puerto Rico only has 78 towns/cities ( municipios ).
http://factfinder.census.gov/servlet...U&-format=ST-2
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message
news:e8**************@TK2MSFTNGP04.phx.gbl...
>Hi Mark,
1914 State name is Pennsylvania, USA
The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes
Data. I know it is not one of what you call contenental USA.
I will double check all of that but I am dealing with but I have to
thing of the MAX and test what if I have a list of 3000 or 5000
What solution would be best. Think about paging Grids and how good that
is.
If you have to do this all over again would you do the same thing on your
IntraNet Solution and what do you do differently for the Internet???
Thank you Mark for all your input
Lit
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:ul**************@TK2MSFTNGP05.phx.gbl...
>>"Lit" <sq**********@hotmail.comwrote in message
news:OX**************@TK2MSFTNGP06.phx.gbl...
The number of Cities Max that I know is 2284, but could be down to
1914 cities.
Wow! Which state is that...?
Where do you see AJAX in the scenario?
To repopulate the cities when you change state...
How do you go about doing the Shift select a block?
Set the listbox's Select mode to Multiple...
Have you done this before
Yes...
is there a website that I can see it running to see the look and feel?
No. I've never done it on a public Internet site, only on corporate
intranets...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
re:
!it matches your 78 count via the link you provided
Indeed.
Having lived in Puerto Rico for 15 years, I know, very well. :-)
re:
!and 2284 Cities ( may be villages ) ??? with different name spellings
That's impossible.
Puerto Rico has only 3,435 square miles of territory.
The whole island is only 100 miles by 35 miles, and some of it is pretty mountainous.
There's no way that 2284 cities/villages, whatever they're called, can exist in that land.
The USPS database is, simply put, mistaken, if it states that.
All told, there's 174 zip codes in 78 municipalities for all of Puerto Rico.
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message news:u8**************@TK2MSFTNGP04.phx.gbl...
Juan,
Not to dwell on this one but.
USPS database has 78 Counties for Puerto Rico ( they call them counties - may be cities ???) it matches your 78 count
via the link you provided.
and 2284 Cities ( may be villages ) ??? with different name spellings ( Preferred and Acceptable etc... )
So for Puerto Rico I might have to use the counties as the cities. but who knows?
Thank you for your input,
Lit
"Juan T. Llibre" <no***********@nowhere.comwrote in message news:e7**************@TK2MSFTNGP03.phx.gbl...
>re:
!The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes Data.
That must be a mistake.
Puerto Rico only has 78 towns/cities ( municipios ).
http://factfinder.census.gov/servlet...U&-format=ST-2
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message news:e8**************@TK2MSFTNGP04.phx.gbl...
>>Hi Mark,
1914 State name is Pennsylvania, USA
The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes Data. I know it is not one of what you call
contenental USA.
I will double check all of that but I am dealing with but I have to thing of the MAX and test what if I have a list
of 3000 or 5000
What solution would be best. Think about paging Grids and how good that is.
If you have to do this all over again would you do the same thing on your IntraNet Solution and what do you do
differently for the Internet???
Thank you Mark for all your input
Lit
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message news:ul**************@TK2MSFTNGP05.phx.gbl...
"Lit" <sq**********@hotmail.comwrote in message news:OX**************@TK2MSFTNGP06.phx.gbl...
The number of Cities Max that I know is 2284, but could be down to 1914 cities.
Wow! Which state is that...?
Where do you see AJAX in the scenario?
To repopulate the cities when you change state...
How do you go about doing the Shift select a block?
Set the listbox's Select mode to Multiple...
Have you done this before
Yes...
is there a website that I can see it running to see the look and feel?
No. I've never done it on a public Internet site, only on corporate intranets...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
Heh...
Those are "barrios", "barriadas", "urbanizaciones", "altos", etc.
They are *not* towns and they are not postal subdivisions.
Some of those might be all of one block square, and correspond to arbitrary
divisions in housing development projects, not to townships, villages, etc.
If you want that kind of granularity, fine, but when you say
"as listed in the USPS Zipcodes Data", remember that
there's only 178 zip codes in all of Puerto Rico.
What you are saying is that there's 2284/178 = 12.8 "towns" per zip code,
roughly equivalent to 3435/2240 = 1.5 square miles per "town", including
all the mountainous areas, beaches and lakes in Puerto Rico.
It, simply, isn't so.
btw, wouldn't a link to the housing development data numbers have sufficed ?
I snipped the list...
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message news:%2****************@TK2MSFTNGP05.phx.gbl...
Juan,
There are 177 zipcodes in PR.
However I have to go by what the database gives me.
Municipalities could be like counties.
The USPS trying to be very granular.
the "City" names are massive and here is a sample.
Adjuntas
Aguada
Aguadilla
Aguas Buenas
Aguirre
Aibonito
Alt De Algarrobo
Alt De Berwind
Alt De Borinquen
>
"Juan T. Llibre" <no***********@nowhere.comwrote in message news:uX**************@TK2MSFTNGP03.phx.gbl...
>re:
!it matches your 78 count via the link you provided
Indeed.
Having lived in Puerto Rico for 15 years, I know, very well. :-)
re:
!and 2284 Cities ( may be villages ) ??? with different name spellings
That's impossible.
Puerto Rico has only 3,435 square miles of territory.
The whole island is only 100 miles by 35 miles, and some of it is pretty mountainous.
There's no way that 2284 cities/villages, whatever they're called, can exist in that land.
The USPS database is, simply put, mistaken, if it states that.
All told, there's 174 zip codes in 78 municipalities for all of Puerto Rico.
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message news:u8**************@TK2MSFTNGP04.phx.gbl...
>>Juan,
Not to dwell on this one but.
USPS database has 78 Counties for Puerto Rico ( they call them counties - may be cities ???) it matches your 78
count via the link you provided.
and 2284 Cities ( may be villages ) ??? with different name spellings ( Preferred and Acceptable etc... )
So for Puerto Rico I might have to use the counties as the cities. but who knows?
Thank you for your input,
Lit
"Juan T. Llibre" <no***********@nowhere.comwrote in message news:e7**************@TK2MSFTNGP03.phx.gbl...
re:
!The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes Data.
That must be a mistake.
Puerto Rico only has 78 towns/cities ( municipios ).
http://factfinder.census.gov/servlet...U&-format=ST-2
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message news:e8**************@TK2MSFTNGP04.phx.gbl...
Hi Mark,
>
1914 State name is Pennsylvania, USA
>
The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes Data. I know it is not one of what you call
contenental USA.
>
I will double check all of that but I am dealing with but I have to thing of the MAX and test what if I have a
list of 3000 or 5000
>
What solution would be best. Think about paging Grids and how good that is.
>
If you have to do this all over again would you do the same thing on your IntraNet Solution and what do you do
differently for the Internet???
>
Thank you Mark for all your input
>
Lit
>
>
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message news:ul**************@TK2MSFTNGP05.phx.gbl...
>"Lit" <sq**********@hotmail.comwrote in message news:OX**************@TK2MSFTNGP06.phx.gbl...
>>
>>The number of Cities Max that I know is 2284, but could be down to 1914 cities.
>>
>Wow! Which state is that...?
>>
>>Where do you see AJAX in the scenario?
>>
>To repopulate the cities when you change state...
>>
>>How do you go about doing the Shift select a block?
>>
>Set the listbox's Select mode to Multiple...
>>
>>Have you done this before
>>
>Yes...
>>
>>is there a website that I can see it running to see the look and feel?
>>
>No. I've never done it on a public Internet site, only on corporate intranets...
>>
>>
>--
>Mark Rae
>ASP.NET MVP
>http://www.markrae.net
>
>
"Lit" <sq**********@hotmail.comwrote in message
news:O2*************@TK2MSFTNGP05.phx.gbl...
So my thinking is assume 2000-3000 max... then what is the best way of
dealing with it.
3,000 cities in a state? I doubt very much whether there are even 3,000
cities in the entire US!
If you ask a good ol' Texan boy to pick the city he lives in, he will not
expect to have to wade through 3,000 items to get to Wichita Falls...
At the 2000 census, there were 601 municipalities in the US with a
population greater than 50,000 ( http://www.demographia.com/db-uscity98.htm),
yet you reckon there are 2,284 "cities" in Puerto Rico!!!
I think you really to find out what the word "city" actually means,
otherwise you risk making your site look ridiculous...
--
Mark Rae
ASP.NET MVP http://www.markrae.net
Juan,
We do need the granularity available. whether used a lot or not that is a
different story.
I might even have the user select by zipcode, that could be a possible
requirement, I hope not.
If selecting by Zipcode do you have a good idea as a solution???
I am looking for a solution that will handle lets say 2000 to 3000, that way
I cover everything at this time down to the city level.
I guess the user can select the entire county and 78 will cover them all
(barrios, barriadas, urbanizaciones, altos etc..) if need be.
If the user wants to go more granular then let it be.
I am only trying to define my upper limits at this time.
Thanks for your help.
Lit
"Juan T. Llibre" <no***********@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
Heh...
Those are "barrios", "barriadas", "urbanizaciones", "altos", etc.
They are *not* towns and they are not postal subdivisions.
Some of those might be all of one block square, and correspond to
arbitrary
divisions in housing development projects, not to townships, villages,
etc.
If you want that kind of granularity, fine, but when you say
"as listed in the USPS Zipcodes Data", remember that
there's only 178 zip codes in all of Puerto Rico.
What you are saying is that there's 2284/178 = 12.8 "towns" per zip code,
roughly equivalent to 3435/2240 = 1.5 square miles per "town", including
all the mountainous areas, beaches and lakes in Puerto Rico.
It, simply, isn't so.
btw, wouldn't a link to the housing development data numbers have sufficed
?
I snipped the list...
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
>Juan,
There are 177 zipcodes in PR.
However I have to go by what the database gives me.
Municipalities could be like counties.
The USPS trying to be very granular.
the "City" names are massive and here is a sample.
Adjuntas
Aguada
Aguadilla
Aguas Buenas
Aguirre
Aibonito
Alt De Algarrobo
Alt De Berwind
Alt De Borinquen
>>
"Juan T. Llibre" <no***********@nowhere.comwrote in message
news:uX**************@TK2MSFTNGP03.phx.gbl...
>>re:
!it matches your 78 count via the link you provided
Indeed.
Having lived in Puerto Rico for 15 years, I know, very well. :-)
re:
!and 2284 Cities ( may be villages ) ??? with different name
spellings
That's impossible.
Puerto Rico has only 3,435 square miles of territory.
The whole island is only 100 miles by 35 miles, and some of it is pretty
mountainous.
There's no way that 2284 cities/villages, whatever they're called, can
exist in that land.
The USPS database is, simply put, mistaken, if it states that.
All told, there's 174 zip codes in 78 municipalities for all of Puerto
Rico.
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message
news:u8**************@TK2MSFTNGP04.phx.gbl...
Juan,
Not to dwell on this one but.
USPS database has 78 Counties for Puerto Rico ( they call them
counties - may be cities ???) it matches your 78 count via the link you
provided.
and 2284 Cities ( may be villages ) ??? with different name spellings
( Preferred and Acceptable etc... )
So for Puerto Rico I might have to use the counties as the cities. but
who knows?
Thank you for your input,
Lit
"Juan T. Llibre" <no***********@nowhere.comwrote in message
news:e7**************@TK2MSFTNGP03.phx.gbl...
re:
!The Other big one is Puerto Rico 2284 as listed in the USPS
Zipcodes Data.
>
That must be a mistake.
Puerto Rico only has 78 towns/cities ( municipios ).
>
http://factfinder.census.gov/servlet...U&-format=ST-2
>
>
>
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message
news:e8**************@TK2MSFTNGP04.phx.gbl.. .
>Hi Mark,
>>
>1914 State name is Pennsylvania, USA
>>
>The Other big one is Puerto Rico 2284 as listed in the USPS Zipcodes
>Data. I know it is not one of what you call contenental USA.
>>
>I will double check all of that but I am dealing with but I have to
>thing of the MAX and test what if I have a list of 3000 or 5000
>>
>What solution would be best. Think about paging Grids and how good
>that is.
>>
>If you have to do this all over again would you do the same thing on
>your IntraNet Solution and what do you do differently for the
>Internet???
>>
>Thank you Mark for all your input
>>
>Lit
>>
>>
>"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
>news:ul**************@TK2MSFTNGP05.phx.gbl. ..
>>"Lit" <sq**********@hotmail.comwrote in message
>>news:OX**************@TK2MSFTNGP06.phx.gbl.. .
>>>
>>>The number of Cities Max that I know is 2284, but could be down
>>>to 1914 cities.
>>>
>>Wow! Which state is that...?
>>>
>>>Where do you see AJAX in the scenario?
>>>
>>To repopulate the cities when you change state...
>>>
>>>How do you go about doing the Shift select a block?
>>>
>>Set the listbox's Select mode to Multiple...
>>>
>>>Have you done this before
>>>
>>Yes...
>>>
>>>is there a website that I can see it running to see the look and
>>>feel?
>>>
>>No. I've never done it on a public Internet site, only on corporate
>>intranets...
>>>
>>>
>>--
>>Mark Rae
>>ASP.NET MVP
>>http://www.markrae.net
>>
>>
>
>
Hi Mark,
Check this out for yourself:
Texas has 254 Counties and 1515 Cities, But http://www.texasalmanac.com/facts said, 1210 cities and the difference
accounts to the acceptable city names.
My requirements might even go down to the zipcode level, I don't make the
requirements.
Granularity is necessary, ridiculous or not. I don't make up the rules.
thanks again for your input.
Lit
"Lit" <sq**********@hotmail.comwrote in message
news:O2*************@TK2MSFTNGP05.phx.gbl...
Mark,
FYI:
Texas has 254 Counties and 1515 Cities, But
http://www.texasalmanac.com/facts said, 1210 cities and the difference
accounts to the acceptable city names.
So my thinking is assume 2000-3000 max... then what is the best way of
dealing with it.
Thank You,
Lit
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:e2****************@TK2MSFTNGP04.phx.gbl...
>"Lit" <sq**********@hotmail.comwrote in message
news:e8**************@TK2MSFTNGP04.phx.gbl...
>>1914 State name is Pennsylvania, USA
I guess it depends how you define "city"...
http://en.wikipedia.org/wiki/List_of...n_Pennsylvania
I count 57...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net
If you are needing an arbitrary level of granularity, I think a recursive
database/interface is going to be the best solution.
CREATE TABLE Regions (
ID INT,
ParentRegionID,
Name NVARCHAR(150),
)
Regions could be as broad or as granular as you need them. In an extreme
case, you could have a hierarchy such as:
Earth
North America
United States
Washington
King County
Seattle
Capital Hill
2000 Block
2014 W 16th St
Suite G
The way the interface could work as a series of drop-down lists to filter
results and a two multi-select list boxes (one to show region options and
one to hold selected regions).
The first drop-down list would use "SELECT * Regions WHERE ParentRegionID IS
NULL". Selecting an item would utilize AJAX to create and populate another
drop-down list with sub-regions. Each time a region is selected, the list
box would be filtered accordingly.
Of course, you would need to require a certain level of filtering before
displaying options in the list box. For example, you wouldn't want to try to
show all cities in the US.
"Lit" <sq**********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...
Juan,
We do need the granularity available. whether used a lot or not that is a
different story.
I might even have the user select by zipcode, that could be a possible
requirement, I hope not.
If selecting by Zipcode do you have a good idea as a solution???
I am looking for a solution that will handle lets say 2000 to 3000, that
way I cover everything at this time down to the city level.
I guess the user can select the entire county and 78 will cover them all
(barrios, barriadas, urbanizaciones, altos etc..) if need be.
If the user wants to go more granular then let it be.
I am only trying to define my upper limits at this time.
Thanks for your help.
Lit
"Juan T. Llibre" <no***********@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
>Heh...
Those are "barrios", "barriadas", "urbanizaciones", "altos", etc.
They are *not* towns and they are not postal subdivisions.
Some of those might be all of one block square, and correspond to
arbitrary
divisions in housing development projects, not to townships, villages,
etc.
If you want that kind of granularity, fine, but when you say
"as listed in the USPS Zipcodes Data", remember that
there's only 178 zip codes in all of Puerto Rico.
What you are saying is that there's 2284/178 = 12.8 "towns" per zip code,
roughly equivalent to 3435/2240 = 1.5 square miles per "town", including
all the mountainous areas, beaches and lakes in Puerto Rico.
It, simply, isn't so.
btw, wouldn't a link to the housing development data numbers have
sufficed ?
I snipped the list...
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
>>Juan,
There are 177 zipcodes in PR.
However I have to go by what the database gives me.
Municipalities could be like counties.
The USPS trying to be very granular.
the "City" names are massive and here is a sample.
Adjuntas
Aguada
Aguadilla
Aguas Buenas
Aguirre
Aibonito
Alt De Algarrobo
Alt De Berwind
Alt De Borinquen
>>>
"Juan T. Llibre" <no***********@nowhere.comwrote in message
news:uX**************@TK2MSFTNGP03.phx.gbl...
re:
!it matches your 78 count via the link you provided
Indeed.
Having lived in Puerto Rico for 15 years, I know, very well. :-)
re:
!and 2284 Cities ( may be villages ) ??? with different name
spellings
That's impossible.
Puerto Rico has only 3,435 square miles of territory.
The whole island is only 100 miles by 35 miles, and some of it is
pretty mountainous.
There's no way that 2284 cities/villages, whatever they're called, can
exist in that land.
The USPS database is, simply put, mistaken, if it states that.
All told, there's 174 zip codes in 78 municipalities for all of Puerto
Rico.
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Lit" <sq**********@hotmail.comwrote in message
news:u8**************@TK2MSFTNGP04.phx.gbl...
Juan,
>
Not to dwell on this one but.
>
USPS database has 78 Counties for Puerto Rico ( they call them
counties - may be cities ???) it matches your 78 count via the link
you provided.
and 2284 Cities ( may be villages ) ??? with different name spellings
( Preferred and Acceptable etc... )
>
So for Puerto Rico I might have to use the counties as the cities. but
who knows?
>
Thank you for your input,
>
Lit
>
>
"Juan T. Llibre" <no***********@nowhere.comwrote in message
news:e7**************@TK2MSFTNGP03.phx.gbl.. .
>re:
>!The Other big one is Puerto Rico 2284 as listed in the USPS
>Zipcodes Data.
>>
>That must be a mistake.
>Puerto Rico only has 78 towns/cities ( municipios ).
>>
>http://factfinder.census.gov/servlet...U&-format=ST-2
>>
>>
>>
>Juan T. Llibre, asp.net MVP
>asp.net faq : http://asp.net.do/faq/
>foros de asp.net, en español : http://asp.net.do/foros/
>======================================
>"Lit" <sq**********@hotmail.comwrote in message
>news:e8**************@TK2MSFTNGP04.phx.gbl. ..
>>Hi Mark,
>>>
>>1914 State name is Pennsylvania, USA
>>>
>>The Other big one is Puerto Rico 2284 as listed in the USPS
>>Zipcodes Data. I know it is not one of what you call contenental
>>USA.
>>>
>>I will double check all of that but I am dealing with but I have to
>>thing of the MAX and test what if I have a list of 3000 or 5000
>>>
>>What solution would be best. Think about paging Grids and how good
>>that is.
>>>
>>If you have to do this all over again would you do the same thing on
>>your IntraNet Solution and what do you do differently for the
>>Internet???
>>>
>>Thank you Mark for all your input
>>>
>>Lit
>>>
>>>
>>"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
>>news:ul**************@TK2MSFTNGP05.phx.gbl.. .
>>>"Lit" <sq**********@hotmail.comwrote in message
>>>news:OX**************@TK2MSFTNGP06.phx.gbl. ..
>>>>
>>>>The number of Cities Max that I know is 2284, but could be down
>>>>to 1914 cities.
>>>>
>>>Wow! Which state is that...?
>>>>
>>>>Where do you see AJAX in the scenario?
>>>>
>>>To repopulate the cities when you change state...
>>>>
>>>>How do you go about doing the Shift select a block?
>>>>
>>>Set the listbox's Select mode to Multiple...
>>>>
>>>>Have you done this before
>>>>
>>>Yes...
>>>>
>>>>is there a website that I can see it running to see the look and
>>>>feel?
>>>>
>>>No. I've never done it on a public Internet site, only on corporate
>>>intranets...
>>>>
>>>>
>>>--
>>>Mark Rae
>>>ASP.NET MVP
>>>http://www.markrae.net
>>>
>>>
>>
>>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jamie Meredith |
last post by:
We are a small graphic design firm who is fighting a growth spurt which
has resulted in an overload in our handling of email and proofing.
We are looking for a pre-built, open source PHP/MYSQL...
|
by: Andrea Griffini |
last post by:
I did it.
I proposed python as the main language for our next CAD/CAM
software because I think that it has all the potential needed
for it. I'm not sure yet if the decision will get through, but...
|
by: Jeff Levinson [mcsd] |
last post by:
I'm an architect for a very large fortune 100 company and
we still struggle with the best balance. However, I use a
couple of simple guidelines that have worked very well
for me in almost all...
|
by: Kymert persson |
last post by:
Hi.
I was wondering if there are any more C++ books along the lines of
"Large scale C++ software design" by Lakos, J. I.e. concerning larger
design issues in close relation to C++. I have made a...
|
by: Neil |
last post by:
I am using SQL 7 with an MS Access 2000 MDB front end, using bound forms
with ODBC linked tables. In one form, the user needs to be able to check a
box to select one or more records. This is...
|
by: Joe |
last post by:
I have 2 multi-list boxes, 1 displays course categories based on a
table called CATEGORIES. This table has 2 fields CATEGORY_ID,
CATEGORY_NAME
The other multi-list box displays courses based on...
|
by: Craig B. |
last post by:
I am relativly new to access 2000 and am having some trouble with a
report. I am not sure what I want to do is something I can do in
access. I want to be able to choose from a combo box multiple...
|
by: YellowFin Announcements |
last post by:
Introduction
Usability and relevance have been identified as the major factors
preventing mass adoption of
Business Intelligence applications. What we have today are traditional
BI tools that...
|
by: roN |
last post by:
Hi,
I'm creating a Website with divs and i do have some troubles, to make it
looking the same way in Firefox and IE (tested with IE7). I checked it with
the e3c validator and it says: "
This...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
|
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...
| |
