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
| Column | Type | Meaning |
|---|---|---|
geo_id | String | 5-digit ZCTA code (GEOID20), the key of census/acs/acs5_zcta |
geometry | Binary | ZCTA outline as WKB, longitude and latitude in EPSG:4326 |
land_area_m2 | Float64 | The ZCTA's land area (ALAND20) in square meters |
year | Int64 | Vintage year |
_partition | String | Vintage 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
.prjfile does not describe NAD83 longitude and latitude. - The
.dbffile has noGEOID20orALAND20field, or has a deleted record. - A GEOID is not 5 digits, or is repeated.
- A ZCTA has no
ALAND20. - The
.shpand.dbffiles 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.