Skip to main content

Census ZCTA Boundaries

census/tiger/cb_zcta520 holds the outline of every ZIP Code Tabulation Area (ZCTA) of the 2020 ZCTA delineation, one partition per vintage year.

Source​

The Census Bureau's national cartographic boundary shapefile at the 1:500,000 scale, https://www2.census.gov/geo/tiger/GENZ<year>/shp/cb_<year>_us_zcta520_500k.zip. The Bureau publishes this file for 2020 only. The national GeoPackage that census/tiger/cb_tract reads has no ZCTA layer. ZCTAs are delineated once per decennial census, so the 2020 outlines are the ZCTAs of every ACS vintage from 2020 on, including the vintages in census/acs/acs5_zcta.

The asset reads the shapefile's .shp, .dbf and .prj files. ai_public.sources.census.shapefile reads polygon records, as the ESRI Shapefile Technical Description specifies them. A clockwise ring is an outer ring and a counterclockwise ring is a hole.

Columns​

ColumnTypeMeaning
geo_idString5-digit ZCTA code (GEOID20), the key of census/acs/acs5_zcta
geometryBinaryZCTA outline as WKB, longitude and latitude in EPSG:4326
land_area_m2Float64The ZCTA's land area (ALAND20) in square meters
yearInt64Vintage year
_partitionStringVintage year, the partition key

Coordinates​

The shapefile's coordinates are NAD83, as its .prj file states. Each outline is transformed to EPSG:4326 as census/tiger/cb_tract describes.

Checks​

A materialization fails when any of these holds:

  • The .prj file does not describe NAD83 longitude and latitude.
  • The .dbf file has no GEOID20 or ALAND20 field, or has a deleted record.
  • A GEOID is not 5 digits, or is repeated.
  • A ZCTA has no ALAND20.
  • The .shp and .dbf files have different numbers of records.
  • An outline is not a valid polygon or multipolygon.

Partitions​

years in the asset's defs.yaml lists the vintage years, one static partition each. The component's eager automation materializes a missing partition. To turn automation off, set automation: null.

market/us/composite/dealers reads the partition that its zcta_vintage names.

Resources​

The asset reads the shapefile in batches of 2,000 ZCTAs. The 2020 zip is about 67 MB and its extracted files about 100 MB. ecs_vcpu and ecs_memory_gb in the asset's defs.yaml set its ECS task size.