Goal: for each county, calculate the fraction of land area that is tribal land. Add this new column to the county_fips data warehouse table and then to the county properties that get joined on to various data mart tables.
I think we can intersect the AIAN shapefile with a county shapefile, calculate the area fractions, and join that as a new column in the county_fips data warehouse table. Note that the 2021 county shapefile we currently use is only in local cache, which is not very clean. See extract.fips_table and transform.fips_table for example processing of zipped census shapefiles.
TrentonBush
commented
1 year ago
Goal: for each county, calculate the fraction of land area that is tribal land. Add this new column to the county_fips data warehouse table and then to the county properties that get joined on to various data mart tables.
The census has a shapefile of American Indian and Alaska Native (AIAN) lands and some "relationship files" (not sure what those are).
I think we can intersect the AIAN shapefile with a county shapefile, calculate the area fractions, and join that as a new column in the county_fips data warehouse table. Note that the 2021 county shapefile we currently use is only in local cache, which is not very clean. See
extract.fips_tableandtransform.fips_tablefor example processing of zipped census shapefiles.