inst/extdata/spatial_data/README.md

In PHSKC-APDE/rads.data: Data for rads package and other public health uses

reference-data/spatial_data

Notes

These files are used for cross-walking between different levels of geography. Beginning with the 2020 Decennial Census, the Census bureau released 2020 vintage geographies to replace those from 2010 (i.e., blocks, block groups, tracts, and PUMAs). Soon afterward, APDE created 61 2020 vintage Heath Reporting Areas (HRAs) to replace the 48 2010 vintage HRAs. This means that many of our old spatial files are no longer useful and will eventually be retired.

All spatial files that use 2020 vintage data are explictly labeled with a '20' in the file name. If it has a '10' or is not labeled, you can assume it is referring to the 2010 vintage geographies. Please carefully examine the file names and contents to ensure that you are using the correct data!

The complete commit history for these files is visible in GitHub Bash and GitHub Desktop. Unfortunately, GitHub online does not display commits prior to renaming this folder. You can view a synopsis of this commit online. Individual commits can still be viewed online using the commit id from your log.

Table of Contents

:trophy: The best! Based on Census 2020 geographies

• Consider spatagg for your spatial custom crosswalking needs
• spatial_block10_to_hra20_to_region20: Convert between 2010 Census blocks and 2020 HRAs and regions
• spatial_block20_to_hra20_to_region20: convert between 2020 Census blocks and 2020 HRAs and regions
• spatial_geoid20_to_hra20_acs: Crosswalk between 2020 Census geographies and 2020 HRAs for ACS analysis.
• spatial_geoid20_to_kccd20_acs: Crosswalk between 2020 Census geographies and 2020 King County Council Districts for ACS analysis.
• spatial_geoid20_to_sccd13_acs: Crosswalk between 2020 Census geographies and 2013 Seattle City Council Districts for ACS analysis.
• spatial_hra20_to_coo20: Convert between 2020 HRAs and Communities of Opportunity (COO) areas
• spatial_hra20_to_bigcities: Convert between 2020 HRAs King County eight 'big cities'
• spatial_hra20_to_region20: Convert between 2020 HRAs and regions
• spatial_tract10_to_hra20_geog: spatagg geographic crosswalk between 2010 tracts and 2020 HRAs
• spatial_tract10_to_hra20_pop: spatagg population crosswalk between 2010 tracts and 2020 HRAs
• spatial_tract20_to_hra20_geog: spatagg geographic crosswalk between 2020 tracts and 2020 HRAs
• spatial_tract20_to_hra20_pop: spatagg population crosswalk between 2020 tracts and 2020 HRAs
• spatial_zip_to_hra20_geog: spatagg geographic crosswalk between ZIPs and 2020 HRAs
• spatial_zip_to_hra20_pop: spatagg population crosswalk between ZIP and 2020 HRAs

Previous best (vintage 2010)

• geocomp_blk10_kps.csv = Mike Smyser's extensive cross-walking file for King, Pierce, and Snomhomis counties. It starts with 2010 census block ids and cross walks to HRAs, KC regions, Seattle/Non-Seattle, Communities Count regions, school districts, legislative districts, KC Council Districts and Seattle City Council Districts. Copied from [PH_APDEStore].[dbo].[geocomp_blk10_kps] on server 51 on 8/19/2019.

The rest (originally extracted from composition of places-HRA.xlsx on SharePoint)

• acs_council_districts.csv = Cross-walk from 2010 census geoid / tract to King County and Seattle City Council districts
• acs_hra_region_place_etc.csv = Cross-walk between HRA names, KC regions, COO places, 2010 census geoids, places, tracts, and block groups
• blocks10_to_city_council_dist.csv = Cross-walk between 2010 census blocks and council districts; includes acreage of land and and water
• blocks10_to_hra_to_region.csv = Crosswalk between 2010 census blocks, HRAs, and KC regions
• chi_blocks10_xwalk.csv = Crosswalk between 2010 block groups and HRA names, regions, and other RADS/CHI standard geographies
• county_codes.csv = Crosswalk between WA county names (e.g., King), long and short fips county codes (e.g., 53033 & 33), alternate county codes (e.g., 17), gnis county codes, and tiger county codes
• county_codes_to_names.csv = Crosswalk between WA county names (e.g., King), fips county code (e.g., 33), and the alternate county code (e.g., 17)
• hra_shortname_to_CHIname.csv = Crosswalk between official CHI short names (cat1_group) and long names (cat1_group_alias). All spatial files with HRA names should use the standard short names
• hra_vid_region.csv = Crosswalk between HRAs, vids, and KC regions
• legislative_codes_to_names.csv = Crosswalk between legistlative district codes, legislative district names, and corresponding counties
• school_codes_to_names.csv = Crosswalk between school district names and school district codes
• school_dist_to_region.csv = Crosswalk between King County school districts and KC regions
• tract_to_county_council_dist.csv = Crosswalk between 2010 census tracts and King County Council Districts.
• tract10_to_puma.csv = Crosswalk between 2010 census tracts and PUMAs (Public Use Microdata Areas)
• zip_city_region_scc.csv = Crosswalk between 126 zip codes (with cities) to KC regions
• zip_hca.csv = 133 zip codes, with zip type, city, primary_city, used to define King County in HCA Medicaid data extracts. Includes 98354 and 98422, which barely cross into south KC). ZIPs spanning county lines are noted in the two_counties field.

Legacy

PHSKC-APDE/rads.data documentation built on Jan. 25, 2025, 12:25 a.m.