Schema
Incorporated Places / Incorporated Places / v1.0.0
Schema from incorporated-places.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
Incorporated Places are those reported to the Census Bureau as legally in existence as of the latest Boundary and Annexation Survey (BAS), under the laws of their respective states. An incorporated place is established to provide governmental functions for a concentration of people as opposed to a minor civil division, which generally is created to provide services or administer an area without regard, necessarily, to population. Places always are within a single state or equivalent entity, but may extend across county and county subdivision boundaries. An incorporated place usually is a city, town, village, or borough but can have other legal descriptions. For Census Bureau data tabulation and presentation purposes, incorporated places exclude:1) The boroughs in Alaska (treated as statistical equivalents of counties).2) Towns in the New England states, New York, and Wisconsin (treated as MCDs).3) The boroughs in New York (treated as MCDs).Download: https://www2.census.gov/geo/tiger/TGRGDB24/tlgdb_2024_a_us_substategeo.gdb.zip Layer: Incorporated_PlaceMetadata: https://meta.geo.census.gov/data/existing/decennial/GEO/GPMB/TIGERline/Current_19115/series_tl_2023_place.shp.iso.xml
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| AREALAND | integer | No | 0 | — | — Range: 39049 to 4421287267Length: — | Examples: 499129, 655957, 925498, 4726296, 23834391 Values: — |
| AREAWATER | integer | No | 0 | — | — Range: 0 to 614965903Length: — | Examples: 248, 0, 3336, 0, 38463 Values: — |
| BASENAME | string | No | 0 | — | — Range: —Length: 49 | Examples: Rogers, West Chester, Somerville, Lester, Webster City Values: — |
| CBSAPCI | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: N, Y |
| CENTLAT | string | No | 0 | — | — Range: —Length: 11 | Examples: +41.4646588, +41.3400387, +38.2785948, +43.4402929, +42.4619126 Values: — |
| CENTLON | string | No | 0 | — | — Range: —Length: 12 | Examples: -096.9158210, -091.8169476, -087.3769787, -096.3314163, -093.8178094 Values: — |
| FUNCSTAT | string | No | 0 | — | — Range: —Length: 1 | Examples: A, A, A, A, A Values: A, F, I, N |
| GEOID | string | No | 0 | — | — Range: —Length: 7 | Examples: 3142145, 1983775, 1870542, 1944670, 1983145 Values: — |
| INTPTLAT | string | No | 0 | — | — Range: —Length: 11 | Examples: +41.4645835, +41.3400387, +38.2796732, +43.4402929, +42.4624232 Values: — |
| INTPTLON | string | No | 0 | — | — Range: —Length: 12 | Examples: -096.9164388, -091.8169476, -087.3757477, -096.3314163, -093.8182006 Values: — |
| LSADC | string | No | 0 | — | — Range: —Length: 2 | Examples: 47, 25, 43, 25, 25 Values: 00, 21, 25, 37, 43, 47, CG, CN, UG |
| MTFCC | string | No | 0 | — | — Range: —Length: 5 | Examples: G4110, G4110, G4110, G4110, G4110 Values: G4110 |
| NAME | string | No | 0 | — | — Range: —Length: 49 | Examples: Rogers village, West Chester city, Somerville town, Lester city, Webster City city Values: — |
| NECTAPCI | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: N |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
| OID | string | No | 0 | — | — Range: —Length: 16 | Examples: 27890230227737, 27890180284119, 27890131097382, 27890130965369, 27890355814641 Values: — |
| PLACE | string | No | 0 | — | — Range: —Length: 5 | Examples: 42145, 83775, 70542, 44670, 83145 Values: — |
| PLACECC | string | No | 0 | — | — Range: —Length: 2 | Examples: C1, C1, C1, C1, C2 Values: C1, C2, C5, C6, C7, C8, C9 |
| PLACENS | string | No | 0 | — | — Range: —Length: 8 | Examples: 02399111, 02397263, 02397665, 02395686, 00468965 Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: 31, 19, 18, 19, 19 Values: — |
| id | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |