state county drop down

Thread view:

Enable EMail Alerts

Start New Thread

SCforester@gmail.com - 31 Oct 2007 19:25 GMT

I am looking for a US state then has another drop down for list of
counties per state. Anyone know of one?
george

Reply to this Message

Roedy Green - 31 Oct 2007 21:43 GMT

>I am looking for a US state then has another drop down for list of
>counties per state. Anyone know of one?

see http://mindprod.com/products2.html#AMERICANTAX

It has such drop downs, but the county tables are incomplete.

It works by installing a different set of county tables when you
change states.

If you can get a list of counties for each state, it would be fairly
easy to plug that in.

Signature

Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Reply to this Message

Jim Korman - 01 Nov 2007 00:46 GMT

>>I am looking for a US state then has another drop down for list of
>>counties per state. Anyone know of one?
[quoted text clipped - 8 lines]
>If you can get a list of counties for each state, it would be fairly
>easy to plug that in.

This could work to complete the list...

http://en.wikipedia.org/wiki/List_of_U.S._counties_in_alphabetical_order

But, Virginia has independent cities, they are directly under the
state, so you'd want to include these in your county list.

Jim

Reply to this Message

Lew - 01 Nov 2007 01:52 GMT

> This could work to complete the list...
>
> http://en.wikipedia.org/wiki/List_of_U.S._counties_in_alphabetical_order
>
> But, Virginia has independent cities, they are directly under the
> state, so you'd want to include these in your county list.

So does New York. Mostly. New York City comprises five counties. Cities are
not within county boundaries.

Signature

Lew

Reply to this Message

Tim Slattery - 01 Nov 2007 14:17 GMT

>> This could work to complete the list...
>>
[quoted text clipped - 5 lines]
>So does New York. Mostly. New York City comprises five counties. Cities are
>not within county boundaries.

There are a very few other exceptions. I think that St. Louis, MO;
Carson City, NV; and Baltimore, MD are not in counties. And San
Francisco city and county are "coterminous", which effectively means
that SF is not in a county.

Signature

Tim Slattery
Slattery_T@bls.gov
http://members.cox.net/slatteryt

Reply to this Message

John W. Kennedy - 01 Nov 2007 22:50 GMT

>>> This could work to complete the list...
>>>
[quoted text clipped - 9 lines]
> Francisco city and county are "coterminous", which effectively means
> that SF is not in a county.

The issue is not the boundary lines, but whether there is a county
government distinct from the city government. In New York City, for
example, there are five functioning State-of-New-York counties, each one
coterminous with a borough.

Borough of Manhattan New York County
Borough of the Bronx Bronx County
Borough of Brooklyn Kings County
Borough of Queens Queens County
Borough of Staten Island Richmond County

But, on the other hand, every city in Virginia is in no county, even if
it is surrounded by a county on all sides. Virginia city administrations
are expected to fulfill all the traditional county functions.

Signature

John W. Kennedy
"There are those who argue that everything breaks even in this old dump
of a world of ours. I suppose these ginks who argue that way hold that
because the rich man gets ice in the summer and the poor man gets it in
the winter things are breaking even for both. Maybe so, but I'll swear I
can't see it that way."
-- The last words of Bat Masterson

Reply to this Message

Lew - 01 Nov 2007 23:28 GMT

>>>> This could work to complete the list...
>>>>
[quoted text clipped - 24 lines]
> it is surrounded by a county on all sides. Virginia city administrations
> are expected to fulfill all the traditional county functions.

That's not entirely accurate. Cities in Maryland, such as Annapolis, have
their own government but can still be considered part of a county. For
example, Annapolis, Maryland, a city, is the county seat of Anne Arundel
County (as well as the State capital). It also has a mayor and a city council.

I seem to recall situations where a city can be the county seat but also not
part of the county. I don't remember an example, but I wouldn't rule it out.

Signature

Lew

Reply to this Message

John W. Kennedy - 02 Nov 2007 03:54 GMT

>>>>> This could work to complete the list...
>>>>>
[quoted text clipped - 31 lines]
> Arundel County (as well as the State capital). It also has a mayor and
> a city council.

That's the normal state of affairs, dating back to medieval England, and
found in most states. Virginia is unusual in that cities are not in a
county. There are about a dozen other anomalous cities outside of
Virginia, and counties have been suppressed altogether in Connecticut,
Rhode Island, and parts of Massachusetts, the former county services
being provided directly by the state. (The historic county boundaries
may delimit service zones.)

To top it off, Alaska has boroughs instead of counties, and Louisiana
has parishes.

Signature

John W. Kennedy
"Compact is becoming contract,
Man only earns and pays."
-- Charles Williams. "Bors to Elayne: On the King's Coins"

Reply to this Message

Tim Slattery - 02 Nov 2007 20:25 GMT

> Virginia is unusual in that cities are not in a county.

I live in Virginia, and I can verify that this is the case.
Alexandria, Fairfax City, Falls Church, Mannassas, Manassas Park, and
many more are not part of counties! It is possible for a city to be
surrounded by a county, but it's still not a part of it. For example,
Fairfax City is in the middle of Fairfax County, but is not part of
it. (It used to be, but many years ago it separated and became an
independent city.)

Signature

Tim Slattery
Slattery_T@bls.gov
http://members.cox.net/slatteryt

Reply to this Message

Lew - 02 Nov 2007 22:54 GMT

>> Virginia is unusual in that cities are not in a county.
>
[quoted text clipped - 5 lines]
> it. (It used to be, but many years ago it separated and became an
> independent city.)

That's the city I was trying to remember. While it's not in Fairfax County,
it is the county seat for Fairfax County.

Signature

Lew

Reply to this Message

John W. Kennedy - 04 Nov 2007 01:44 GMT

>>> Virginia is unusual in that cities are not in a county.
>>
[quoted text clipped - 8 lines]
> That's the city I was trying to remember. While it's not in Fairfax
> County, it is the county seat for Fairfax County.

Apparently that is only approximately true. The city is shaped like a
doughnut. Outside the doughnut is Fairfax County. The doughnut is
Fairfax City. The hole in the doughnut is another little bit of Fairfax
County, and /that/ is where the county seat is.

Signature

John W. Kennedy
"I want everybody to be smart. As smart as they can be. A world of
ignorant people is too dangerous to live in."
-- Garson Kanin. "Born Yesterday"

Reply to this Message

Lew - 04 Nov 2007 02:31 GMT

> Apparently that is only approximately true. The city is shaped like a
> doughnut. Outside the doughnut is Fairfax County. The doughnut is
> Fairfax City. The hole in the doughnut is another little bit of Fairfax
> County, and /that/ is where the county seat is.

That is truly fascinating, and I wonder how that impacts the OP's specifications.

Signature

Lew

Reply to this Message

Andrew Thompson - 04 Nov 2007 02:46 GMT

>> Apparently that is only approximately true. ...

>That is truly fascinating, and I wonder how that impacts the OP's specifications.

Dunno'. But it should impact the price of the quote. ;-)

Signature

Andrew Thompson
http://www.athompson.info/andrew/

Reply to this Message