Schema
State Legislative Districts - Upper / State Legislative Districts - Upper / v1.0.0
Schema from state-legislative-districts-upper.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
State Legislative Districts (SLDs) are the areas from which members are elected to state legislatures. The SLDs embody the upper (senate) and lower (house) chambers of the state legislature. Nebraska has a unicameral legislature and the District of Columbia has a single council, both of which the Census Bureau treats as upper-chamber legislative areas for the purpose of data presentation; there are no data by lower-chamber legislative area for either Nebraska or the District of Columbia. A unique three-character census code, identified by state participants, is assigned to each SLD within a state. In Connecticut, Illinois, Louisiana, New Hampshire, Wisconsin, and Puerto Rico, the Redistricting Data Program (RDP) participant did not define the SLDs to cover all of the state or state equivalent area. In these areas with no SLDs defined, the code "ZZZ" has been assigned, which is treated as a single SLD for purposes of data presentation.The most recent SLD boundaries collected by the Census Bureau are for the 2022 election year and were provided by state-level participants through the RDP.Download: https://www2.census.gov/geo/tiger/TGRGDB24/tlgdb_2024_a_us_legislative.gdb.zip Layer: State_Legislative_Districts_UpperMetadata: https://meta.geo.census.gov/data/existing/decennial/GEO/GPMB/TIGERline/Current_19115/series_tl_2023_sldu.shp.iso.xml
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| STATEFP | string | No | 0 | — | — Range: —Length: 2 | Examples: 01, 25, 13, 36, 20 Values: — |
| SLDUST | string | No | 0 | — | — Range: —Length: 3 | Examples: 032, D05, 015, 057, 013 Values: — |
| GEOID | string | No | 0 | — | — Range: —Length: 5 | Examples: 01032, 25D05, 13015, 36057, 20013 Values: — |
| GEOIDFQ | string | No | 0 | — | — Range: —Length: 14 | Examples: 610U900US01032, 610U900US25D05, 610U900US13015, 610U900US36057, 610U900US20013 Values: — |
| NAMELSAD | string | No | 0 | — | — Range: —Length: 45 | Examples: State Senate District 32, Hampshire-Franklin-Worcester District, State Senate District 15, State Senate District 57, State Senate District 13 Values: — |
| LSAD | string | No | 0 | — | — Range: —Length: 2 | Examples: LU, 07, LU, LU, LU Values: 00, 07, L1, L2, LS, LU |
| LSY | string | No | 0 | — | — Range: —Length: 4 | Examples: 2024, 2024, 2024, 2024, 2024 Values: 2024 |
| MTFCC | string | No | 0 | — | — Range: —Length: 5 | Examples: G5210, G5210, G5210, G5210, G5210 Values: G5210 |
| FUNCSTAT | string | No | 0 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: F, N |
| ALAND | integer | No | 0 | — | — Range: 0 to 505478821689Length: — | Examples: 910459427, 1904414611, 5389805751, 10526489019, 4695126941 Values: — |
| AWATER | integer | No | 0 | — | — Range: 0 to 109831653152Length: — | Examples: 982206639, 123020074, 46094166, 1201236130, 31927946 Values: — |
| INTPTLAT | string | No | 0 | — | — Range: —Length: 11 | Examples: +30.3773692, +42.5375655, +32.4517197, +42.4113090, +37.5193327 Values: — |
| INTPTLON | string | No | 0 | — | — Range: —Length: 12 | Examples: -087.8224140, -072.3689359, -084.4171008, -078.7240962, -094.8500742 Values: — |
