UM Geospatial Digital Special Collections

Citation: Department of Commerce, U.S. Census Bureau, Geography Division, Spatial Data Collection and Products Branch (). TIGER/Line Shapefile, 2022, US, Current County [gis dataset]. Department of Commerce. https://www.census.gov/geographies/mapping-files/time-series/geo/cartographic-boundary.html. last updated: 2024-05-01 (update frequency: Never). Abstract: TIGER/Line Shapefile, 2016, state, Florida, Current County Subdivision State-based The TIGER/Line shapefiles and related database files (.dbf) are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTBD). The MTBD represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line shapefile is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. County subdivisions are the primary divisions of counties and their equivalent entities for the reporting of Census Bureau data. They include legally-recognized minor civil divisions (MCDs) and statistical census county divisions (CCDs), and unorganized territories. For the 2010 Census, the MCDs are the primary governmental and/or administrative divisions of counties in 29 States and Puerto Rico; Tennessee changed from having CCDs for Census 2000 to having MCDs for the 2010 Census. In MCD States where no MCD exists or is not defined, the Census Bureau creates statistical unorganized territories to complete coverage. The entire area of the United States, Puerto Rico, and the Island Areas are covered by county subdivisions. The boundaries of most legal MCDs are as of January 1, 2015, as reported through the Census Bureau's Boundary and Annexation Survey (BAS). The boundaries of all CCDs, delineated in 20 states, are those as reported as part of the Census Bureau's Participant Statistical Areas Program (PSAP) for the 2010 Census. Key words: USA, Counties, TIGER Open Geospatial Consortium Standards: vector tiles | WMS (coming soon) | WFS (coming soon) ETL documentation

ETL for us_2022_county_tl

######### # GDSC ETL is performed in two steps: shell script to ETL data into postgres # and then additional transformations with SQL in postGIS (if needed). #### ######### # Step 1 - bash script (pseudo code) #### # create directory structure and move into it mkdir -p /data/us_2022_county_tl/{download,etl} && cd /data/us_2022_county_tl # set update flag based on last update and update frequency do_update=0 if date() < last_update + update_frequency else do_update = 1 # download if update flag is set: if do_update == 1 then wget -O download/us_2022_county_tl.zip 'https://www2.census.gov/geo/tiger/TIGER2022/COUNTY/tl_2022_us_county.zip' # unzip to download directory if update flag is set if do_update == 1 then unzip -d download download/us_2022_county_tl.zip && rm download/us_2022_county_tl.zip # load into postGIS with: ogr2ogr -lco GEOMETRY_NAME=geom -f PostgreSQL PG:"" download/tl_2022_us_county.shp -nlt multipolygon -nln us_2022_county_tl ######### # Step 2 - SQL script (pseudo code): #### # remove duplicate points and make geometries valid: UPDATE us_2022_county_tl SET geom=ST_MakeValid(ST_RemoveRepeatedPoints(geom));" # add local geometry column and reproject existing geometries into local EPSG: SELECT AddGeometryColumn ( 'us_2022_county_tl', 'geom_local',4269,'multipolygon',2 ); UPDATE us_2022_county_tl SET geom_local=ST_Transform(ST_Multi(geom),4269); CREATE INDEX us_2022_county_tl_geom_local_idx ON us_2022_county_tl USING GIST (geom_local); NOTIFY pgrst, 'reload schema';"