469,953 Members | 2,403 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,953 developers. It's quick & easy.

Web design with large selections ideas needed

Lit
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

Jul 24 '07 #1
20 1490
"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

Jul 24 '07 #2
Lit
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

Jul 24 '07 #3
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


Jul 24 '07 #4
"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

Jul 24 '07 #5
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

Jul 24 '07 #6
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

Jul 24 '07 #7
Lit
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

Jul 24 '07 #8
Lit
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


Jul 24 '07 #9
Lit
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


Jul 24 '07 #10
"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

Jul 24 '07 #11
Lit
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

Jul 24 '07 #12
Lit
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

Jul 24 '07 #13
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


Jul 24 '07 #14
Lit
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



Jul 24 '07 #15
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




Jul 24 '07 #16
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
>
>




Jul 24 '07 #17
"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

Jul 24 '07 #18
Lit
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
>>
>>
>
>




Jul 24 '07 #19
Lit
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


Jul 24 '07 #20
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
>>>
>>>
>>
>>
>
>



Jul 24 '07 #21

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jamie Meredith | last post: by
36 posts views Thread by Andrea Griffini | last post: by
reply views Thread by Jeff Levinson [mcsd] | last post: by
2 posts views Thread by Kymert persson | last post: by
2 posts views Thread by Craig B. | last post: by
reply views Thread by YellowFin Announcements | last post: by
17 posts views Thread by roN | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.