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"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:O4We63gzHHA.5476@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
I need to create an Internet based, asp.net webform where a user can
select multiple cities in a state.
OK.
Quote:
Originally Posted by
as you know the number of cities in a state can be very large.
How large is very large...?
Quote:
Originally Posted by
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.
Quote:
Originally Posted by
I can add select all cities, clear all cities.
No problem - you can do that with client-side JavaScript.
Quote:
Originally Posted by
Also is there a way of Shift Click to select a block of cites all at once.
Yes.
Quote:
Originally Posted by
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...
Quote:
Originally Posted by
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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
news:unMvaLhzHHA.3328@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:O4We63gzHHA.5476@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
>
Quote:
Originally Posted by
>I need to create an Internet based, asp.net webform where a user can
>select multiple cities in a state.
>
OK.
>
Quote:
Originally Posted by
>as you know the number of cities in a state can be very large.
>
How large is very large...?
>
Quote:
Originally Posted by
>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.
>
Quote:
Originally Posted by
>I can add select all cities, clear all cities.
>
No problem - you can do that with client-side JavaScript.
>
Quote:
Originally Posted by
>Also is there a way of Shift Click to select a block of cites all at
>once.
>
Yes.
>
Quote:
Originally Posted by
>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...
>
Quote:
Originally Posted by
>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" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:OXxTjThzHHA.3536@dotnet.itags.org.TK2MSFTNGP06.phx.gbl...
Quote:
Originally Posted by
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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
news:unMvaLhzHHA.3328@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>news:O4We63gzHHA.5476@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
>>
Quote:
Originally Posted by
>>I need to create an Internet based, asp.net webform where a user can
>>select multiple cities in a state.
>>
>OK.
>>
Quote:
Originally Posted by
>>as you know the number of cities in a state can be very large.
>>
>How large is very large...?
>>
Quote:
Originally Posted by
>>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.
>>
Quote:
Originally Posted by
>>I can add select all cities, clear all cities.
>>
>No problem - you can do that with client-side JavaScript.
>>
Quote:
Originally Posted by
>>Also is there a way of Shift Click to select a block of cites all at
>>once.
>>
>Yes.
>>
Quote:
Originally Posted by
>>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...
>>
Quote:
Originally Posted by
>>Is it a good candidate for AJAX?
>>
>Yes.
>>
>>
>--
>Mark Rae
>ASP.NET MVP
>http://www.markrae.net
>
>
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:OXxTjThzHHA.3536@dotnet.itags.org.TK2MSFTNGP06.phx.gbl...
Quote:
Originally Posted by
The number of Cities Max that I know is 2284, but could be down to 1914
cities.
Wow! Which state is that...?
Quote:
Originally Posted by
Where do you see AJAX in the scenario?
To repopulate the cities when you change state...
Quote:
Originally Posted by
How do you go about doing the Shift select a block?
Set the listbox's Select mode to Multiple...
Quote:
Originally Posted by
Have you done this before
Yes...
Quote:
Originally Posted by
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...@dotnet.itags.org.davidwier.nospam.com>
wrote:
Quote:
Originally Posted by
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...@dotnet.itags.org.hotmail.comwrote in message
>
news:OXxTjThzHHA.3536@dotnet.itags.org.TK2MSFTNGP06.phx.gbl...
>
Quote:
Originally Posted by
Hi Mark,
>
Quote:
Originally Posted by
The number of Cities Max that I know is 2284, but could be down to 1914
cities.
>
Quote:
Originally Posted by
Where do you see AJAX in the scenario?
>
Quote:
Originally Posted by
How do you go about doing the Shift select a block?
>
Quote:
Originally Posted by
Have you done this before and Is there a website that I can see it running
to see the look and feel?
>
Quote:
Originally Posted by
Thank you for all your input and help.
>
Quote:
Originally Posted by
Lit.
>
Quote:
Originally Posted by
"Mark Rae [MVP]" <m...@dotnet.itags.org.markNOSPAMrae.netwrote in message
news:unMvaLhzHHA.3328@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
"Lit" <sql_agent...@dotnet.itags.org.hotmail.comwrote in message
>news:O4We63gzHHA.5476@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
>
Quote:
Originally Posted by
Quote:
Originally Posted by
>I need to create an Internet based, asp.net webform where a user can
>select multiple cities in a state.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
OK.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
>as you know the number of cities in a state can be very large.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
How large is very large...?
>
Quote:
Originally Posted by
Quote:
Originally Posted by
>What is the best way of designing such thing.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
I'd use a DropDownList for the states and a multi-select listbox for the
cities.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
>I can add select all cities, clear all cities.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
No problem - you can do that with client-side JavaScript.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
>Also is there a way of Shift Click to select a block of cites all at
>once.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
Yes.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
>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...
>
Quote:
Originally Posted by
Quote:
Originally Posted by
I'd use a multi-select listbox...
>
Quote:
Originally Posted by
Quote:
Originally Posted by
>Is it a good candidate for AJAX?
>
Quote:
Originally Posted by
Quote:
Originally Posted by
Yes.
>
Quote:
Originally Posted by
Quote:
Originally Posted by
--
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" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:OXxTjThzHHA.3536@dotnet.itags.org.TK2MSFTNGP06.phx.gbl...
Quote:
Originally Posted by
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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
news:unMvaLhzHHA.3328@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>news:O4We63gzHHA.5476@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
>>
Quote:
Originally Posted by
>>I need to create an Internet based, asp.net webform where a user can
>>select multiple cities in a state.
>>
>OK.
>>
Quote:
Originally Posted by
>>as you know the number of cities in a state can be very large.
>>
>How large is very large...?
>>
Quote:
Originally Posted by
>>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.
>>
Quote:
Originally Posted by
>>I can add select all cities, clear all cities.
>>
>No problem - you can do that with client-side JavaScript.
>>
Quote:
Originally Posted by
>>Also is there a way of Shift Click to select a block of cites all at
>>once.
>>
>Yes.
>>
Quote:
Originally Posted by
>>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...
>>
Quote:
Originally Posted by
>>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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
news:ulu2lfhzHHA.4276@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
Quote:
Originally Posted by
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:OXxTjThzHHA.3536@dotnet.itags.org.TK2MSFTNGP06.phx.gbl...
>
Quote:
Originally Posted by
>The number of Cities Max that I know is 2284, but could be down to 1914
>cities.
>
Wow! Which state is that...?
>
Quote:
Originally Posted by
>Where do you see AJAX in the scenario?
>
To repopulate the cities when you change state...
>
Quote:
Originally Posted by
>How do you go about doing the Shift select a block?
>
Set the listbox's Select mode to Multiple...
>
Quote:
Originally Posted by
>Have you done this before
>
Yes...
>
Quote:
Originally Posted by
>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" <hansdeschryver@dotnet.itags.org.gmail.comwrote in message
news:1185298962.367078.181320@dotnet.itags.org.k79g2000hse.googlegr oups.com...
Quote:
Originally Posted by
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...@dotnet.itags.org.davidwier.nospam.com>
wrote:
Quote:
Originally Posted by
>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...@dotnet.itags.org.hotmail.comwrote in message
>>
>news:OXxTjThzHHA.3536@dotnet.itags.org.TK2MSFTNGP06.phx.gbl...
>>
Quote:
Originally Posted by
Hi Mark,
>>
Quote:
Originally Posted by
The number of Cities Max that I know is 2284, but could be down to
1914
cities.
>>
Quote:
Originally Posted by
Where do you see AJAX in the scenario?
>>
Quote:
Originally Posted by
How do you go about doing the Shift select a block?
>>
Quote:
Originally Posted by
Have you done this before and Is there a website that I can see it
running
to see the look and feel?
>>
Quote:
Originally Posted by
Thank you for all your input and help.
>>
Quote:
Originally Posted by
Lit.
>>
Quote:
Originally Posted by
"Mark Rae [MVP]" <m...@dotnet.itags.org.markNOSPAMrae.netwrote in message
>news:unMvaLhzHHA.3328@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
>"Lit" <sql_agent...@dotnet.itags.org.hotmail.comwrote in message
>>news:O4We63gzHHA.5476@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
>>
Quote:
Originally Posted by
>>I need to create an Internet based, asp.net webform where a user can
>>select multiple cities in a state.
>>
Quote:
Originally Posted by
>OK.
>>
Quote:
Originally Posted by
>>as you know the number of cities in a state can be very large.
>>
Quote:
Originally Posted by
>How large is very large...?
>>
Quote:
Originally Posted by
>>What is the best way of designing such thing.
>>
Quote:
Originally Posted by
>I'd use a DropDownList for the states and a multi-select listbox for
>the
>cities.
>>
Quote:
Originally Posted by
>>I can add select all cities, clear all cities.
>>
Quote:
Originally Posted by
>No problem - you can do that with client-side JavaScript.
>>
Quote:
Originally Posted by
>>Also is there a way of Shift Click to select a block of cites all at
>>once.
>>
Quote:
Originally Posted by
>Yes.
>>
Quote:
Originally Posted by
>>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...
>>
Quote:
Originally Posted by
>I'd use a multi-select listbox...
>>
Quote:
Originally Posted by
>>Is it a good candidate for AJAX?
>>
Quote:
Originally Posted by
>Yes.
>>
Quote:
Originally Posted by
>--
>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" <bgano@dotnet.itags.org.inocompany.comwrote in message
news:E89A97BE-B033-43CF-9FED-454DD12912F9@dotnet.itags.org.microsoft.com...
Quote:
Originally Posted by
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" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:OXxTjThzHHA.3536@dotnet.itags.org.TK2MSFTNGP06.phx.gbl...
Quote:
Originally Posted by
>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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
>news:unMvaLhzHHA.3328@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>>news:O4We63gzHHA.5476@dotnet.itags.org.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" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:e8iMOshzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
1914 State name is Pennsylvania, USA
I guess it depends how you define "city"...
http://en.wikipedia.org/wiki/List_o...in_Pennsylvania
I count 57...
--
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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
news:e2%230w0hzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:e8iMOshzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
>
Quote:
Originally Posted by
>1914 State name is Pennsylvania, USA
>
I guess it depends how you define "city"...
http://en.wikipedia.org/wiki/List_o...in_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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
news:e2%230w0hzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:e8iMOshzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
>
Quote:
Originally Posted by
>1914 State name is Pennsylvania, USA
>
I guess it depends how you define "city"...
http://en.wikipedia.org/wiki/List_o...in_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/servle..._U&-format=ST-2
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
======================================
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:e8iMOshzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message news:ulu2lfhzHHA.4276@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
Quote:
Originally Posted by
>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:OXxTjThzHHA.3536@dotnet.itags.org.TK2MSFTNGP06.phx.gbl...
>>
Quote:
Originally Posted by
>>The number of Cities Max that I know is 2284, but could be down to 1914 cities.
>>
>Wow! Which state is that...?
>>
Quote:
Originally Posted by
>>Where do you see AJAX in the scenario?
>>
>To repopulate the cities when you change state...
>>
Quote:
Originally Posted by
>>How do you go about doing the Shift select a block?
>>
>Set the listbox's Select mode to Multiple...
>>
Quote:
Originally Posted by
>>Have you done this before
>>
>Yes...
>>
Quote:
Originally Posted by
>>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" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
news:e7DJkKizHHA.1204@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
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/servle..._U&-format=ST-2
>
>
>
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
======================================
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:e8iMOshzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
>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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
>news:ulu2lfhzHHA.4276@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
Quote:
Originally Posted by
>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>>news:OXxTjThzHHA.3536@dotnet.itags.org.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 espaol : http://asp.net.do/foros/
======================================
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:u8FXnVizHHA.5092@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
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" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message news:e7DJkKizHHA.1204@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
>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/servle..._U&-format=ST-2
>>
>>
>>
>Juan T. Llibre, asp.net MVP
>asp.net faq : http://asp.net.do/faq/
>foros de asp.net, en espaol : http://asp.net.do/foros/
>======================================
>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:e8iMOshzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
>>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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message news:ulu2lfhzHHA.4276@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
>>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:OXxTjThzHHA.3536@dotnet.itags.org.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 espaol : http://asp.net.do/foros/
======================================
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:%237LDGpizHHA.5160@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
Quote:
Originally Posted by
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
Quote:
Originally Posted by
>
>
"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message news:uX4fphizHHA.4916@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
>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 espaol : http://asp.net.do/foros/
>======================================
>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:u8FXnVizHHA.5092@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
>>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" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message news:e7DJkKizHHA.1204@dotnet.itags.org.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/servle..._U&-format=ST-2
>>
>>
>>
>>>Juan T. Llibre, asp.net MVP
>>>asp.net faq : http://asp.net.do/faq/
>>>foros de asp.net, en espaol : http://asp.net.do/foros/
>>>======================================
>>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:e8iMOshzHHA.4816@dotnet.itags.org.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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message news:ulu2lfhzHHA.4276@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message news:OXxTjThzHHA.3536@dotnet.itags.org.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" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:O28cIJizHHA.600@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
Quote:
Originally Posted by
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" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
news:%23qIVz0izHHA.1204@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
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 espaol : http://asp.net.do/foros/
======================================
"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:%237LDGpizHHA.5160@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
Quote:
Originally Posted by
>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
>
>
Quote:
Originally Posted by
>>
>>
>"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
>news:uX4fphizHHA.4916@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
>>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 espaol : http://asp.net.do/foros/
>>======================================
>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>>news:u8FXnVizHHA.5092@dotnet.itags.org.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" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
>>>news:e7DJkKizHHA.1204@dotnet.itags.org.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/servle..._U&-format=ST-2
>>
>>
>>
>>Juan T. Llibre, asp.net MVP
>>asp.net faq : http://asp.net.do/faq/
>>foros de asp.net, en espaol : http://asp.net.do/foros/
>>======================================
>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>>news:e8iMOshzHHA.4816@dotnet.itags.org.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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
>>news:ulu2lfhzHHA.4276@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
>>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>>>news:OXxTjThzHHA.3536@dotnet.itags.org.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" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:O28cIJizHHA.600@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
Quote:
Originally Posted by
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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
news:e2%230w0hzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>news:e8iMOshzHHA.4816@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
>>
Quote:
Originally Posted by
>>1914 State name is Pennsylvania, USA
>>
>I guess it depends how you define "city"...
>http://en.wikipedia.org/wiki/List_o...in_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" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
news:%23GuEuEjzHHA.5092@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...
Quote:
Originally Posted by
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" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
news:%23qIVz0izHHA.1204@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...
Quote:
Originally Posted by
>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 espaol : http://asp.net.do/foros/
>======================================
>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>news:%237LDGpizHHA.5160@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
Quote:
Originally Posted by
>>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
>>
>>
Quote:
Originally Posted by
>>>
>>>
>>"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
>>news:uX4fphizHHA.4916@dotnet.itags.org.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 espaol : http://asp.net.do/foros/
>>>======================================
>>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>>>news:u8FXnVizHHA.5092@dotnet.itags.org.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" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
>>news:e7DJkKizHHA.1204@dotnet.itags.org.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/servle..._U&-format=ST-2
>>>
>>>
>>>
>>Juan T. Llibre, asp.net MVP
>>asp.net faq : http://asp.net.do/faq/
>>foros de asp.net, en espaol : http://asp.net.do/foros/
>>======================================
>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>>news:e8iMOshzHHA.4816@dotnet.itags.org.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]" <mark@dotnet.itags.org.markNOSPAMrae.netwrote in message
>>>news:ulu2lfhzHHA.4276@dotnet.itags.org.TK2MSFTNGP05.phx.gbl...
>>"Lit" <sql_agentman@dotnet.itags.org.hotmail.comwrote in message
>>news:OXxTjThzHHA.3536@dotnet.itags.org.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
>>
>>
>>>
>>>
>>
>>
>>
>>
>>>
>>>
>>
>>
>
>
0 comments:
Post a Comment