Back to file

Schema

County Subdivisions / County Subdivisions / v1.0.0

View metadata

Schema from county-subdivisions-1.parquet, gcp-portolan-published, v1.0.0.

County Subdivisions are the primary divisions of counties and equivalent entities. They include census county divisions, census subareas, minor civil divisions, and unorganized territories, and can be classified as either legal or statistical. Legal entities are termed minor civil divisions and statistical entities can be either census county divisions, census subareas, or unorganized territories.Minor Civil Divisions (MCDs) are the primary governmental or administrative divisions of a county in many states (parishes in Louisiana) and of the county equivalents in Puerto Rico and the Island Areas. MCDs in the United States, Puerto Rico, and the Island Areas represent many different kinds of legal entities with a wide variety of governmental and/or administrative functions. MCDs include areas variously designated as barrios, barrios-pueblo, boroughs, charter townships, commissioner districts, election districts, election precincts, gores, grants, locations, magisterial districts, parish governing authority districts, plantations, purchases, reservations, supervisor's districts, towns, and townships. The Census Bureau recognizes MCDs in 29 states, Puerto Rico, and the Island Areas. The District of Columbia has no primary divisions, and is considered equivalent to an MCD for statistical purposes.In some states, all or some incorporated places are not part of any MCD; these places are termed independent places. In nine states-Maine, Massachusetts, New Hampshire, New Jersey, North Dakota, Pennsylvania, Rhode Island, South Dakota, and Wisconsin-all incorporated places are independent places. In other states, incorporated places are part of, or dependent within, the MCDs in which they are located, or the pattern is mixed-some incorporated places are independent of MCDs and others are included within one or more MCDs.In New York and Maine, American Indian reservations (AIRs) generally exist outside the jurisdiction of any town (MCD) and thus also serve as the equivalent of MCDs for purposes of data presentation.In states with legal MCDs, the Census Bureau assigns a default FIPS county subdivision code of 00000 and ANSI code of eight zeroes in some coastal, territorial sea, and Great Lakes water where county subdivisions do not extend into the Great Lakes or out to the three-mile limit.Census County Divisions (CCDs) are areas delineated by the Census Bureau in cooperation with state, tribal, and local officials for statistical purposes. CCDs have no legal function and are not governmental units. CCD boundaries usually follow visible features and usually coincide with census tract boundaries. The name of each CCD is based on a place, county, or well-known local name that identifies its location.Census Subareas are statistical subdivisions of boroughs, city and boroughs, municipalities, and census areas, the statistical equivalent entities for counties in Alaska. The state of Alaska and the Census Bureau cooperatively delineate the census subareas to serve as the statistical equivalents of MCDs.Unorganized Territories (UTs) are defined by the Census Bureau in nine MCD states where portions of counties or equivalent entities are not included in any legally established MCD or incorporated place. The Census Bureau recognizes such separate pieces of territory as one or more separate county subdivisions for census purposes. It assigns each unorganized territory a descriptive name, followed by the designation "UT".Download: https://www2.census.gov/geo/tiger/TGRGDB24/tlgdb_2024_a_us_substategeo.gdb.zip Layer: County_SubdivisionMetadata: https://meta.geo.census.gov/data/existing/decennial/GEO/GPMB/TIGERline/Current_19115/series_tl_2023_cousub.shp.iso.xml

Columns
27 columns
Features
36,498
Geometry
MultiPolygon
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryNo0
Range: Length:
Examples:
Values:
AREALANDstringNo0
Range: Length: 12
Examples: 93102473, 180339620, 113710706, 93675204, 78803661
Values:
AREAWATERstringNo0
Range: Length: 11
Examples: 616936, 677294, 2211405, 1554, 217153
Values:
BASENAMEstringNo0
Range: Length: 36
Examples: Polk, Vidette, Forbes, Esmen, Union
Values:
CENTLATstringNo0
Range: Length: 11
Examples: +39.2169763, +33.0523302, +39.9164977, +40.9755059, +39.5598355
Values:
CENTLONstringNo0
Range: Length: 12
Examples: -089.9800594, -082.2257821, -095.0659469, -088.6433855, -084.8717208
Values:
CNECTAstringYes5,000
Range: Length:
Examples:
Values:
COUNTYstringNo0
Range: Length: 3
Examples: 117, 033, 087, 105, 161
Values:
COUSUBstringNo0
Range: Length: 5
Examples: 60924, 93198, 24976, 24426, 77678
Values:
COUSUBCCstringNo0
Range: Length: 2
Examples: T1, Z5, Z1, T1, T1
Values: C2, C5, T1, T5, T9, Z1, Z2, Z3, Z5, Z7, Z9
COUSUBNSstringNo0
Range: Length: 8
Examples: 00429586, 01936617, 00766764, 00428979, 00453936
Values:
FUNCSTATstringNo0
Range: Length: 1
Examples: A, S, N, A, A
Values: A, B, C, F, G, I, N, S
GEOIDstringNo0
Range: Length: 10
Examples: 1711760924, 1303393198, 2908724976, 1710524426, 1816177678
Values:
HU100stringYes5,000
Range: Length:
Examples:
Values:
INTPTLATstringNo0
Range: Length: 11
Examples: +39.2195707, +33.0540669, +39.9161123, +40.9683923, +39.5607295
Values:
INTPTLONstringNo0
Range: Length: 12
Examples: -089.9746679, -082.2294607, -095.0729635, -088.6341843, -084.8679345
Values:
LSADCstringNo0
Range: Length: 2
Examples: 44, 22, 44, 44, 44
Values:
MTFCCstringNo0
Range: Length: 5
Examples: G4040, G4040, G4040, G4040, G4040
Values: G4040
NAMEstringNo0
Range: Length: 36
Examples: Polk township, Vidette CCD, Forbes township, Esmen township, Union township
Values:
NECTAstringYes5,000
Range: Length:
Examples:
Values:
NECTADIVstringYes5,000
Range: Length:
Examples:
Values:
OBJECTIDintegerNo0
Range: 1 to 5000Length:
Examples: 399, 3834, 4837, 4573, 637
Values:
OIDstringNo0
Range: Length: 16
Examples: 27690355579430, 27690356324349, 27690105222357, 27690350556932, 27690273858946
Values:
POP100stringYes5,000
Range: Length:
Examples:
Values:
STATEstringNo0
Range: Length: 2
Examples: 17, 13, 29, 17, 18
Values:
URstringYes5,000
Range: Length:
Examples:
Values:
idintegerNo0
Range: 1 to 5000Length:
Examples: 399, 3834, 4837, 4573, 637
Values:
Quality checks: Failed
Invalid geometry count: 31
Columns hash: 039183fd79bc68ee46badbf4c9740abf6b640828c077e16bb95dfaa29da50f0f