• download geographic data
• upload tract-level data to convert

• do we need to st_make_valid on any of these?
• should we include NHGIS conflated tract boundaries (at least for 2000)?

Some of California left out??

how will we map these with the 2020 tracts again?

The synced leaflet maps are very cool, but cause problems when there is not enough RAM to process it -- which looks like what is happening on github actions on Windows builds and when the pkgdown site gets published.

Should we break out this small side-by-side map into a shiny app? Maybe include the code to reproduce the leaflet map in the package as a function and then don't render it in a vignette or pkgdown?

and to interpolate CODEC tract data to these geographies (RISEUP, Andy, etc...)

or can we load objects okay without having {{sf}} loaded?

is there a good way to label the county maps with their names without using any extra packages?

• use internal mapping data (cincy:::hamilton_tract_to_cincy_neighborhood) that is created from version controlled CSV as source of truth for adding neighborhood based on tract
• rename CSV file to include tract vintage (2010...)
• rearrange columns for use with census_merger
• add function to add neighborhood to tract
  • cincy::add_neighborhood()
  • tidy tibble in / tibble out
  • check for census_tract_id_2010 (or census_tract_id_2020 eventually)
  • only support that CSV file (not CAGIS neigh)

Right now, our cincy::tract_*_*() functions return the census tract identifier as tract_fips. Should we harmonize this with other instances where we use census tract identifier column names?

• hh_acs_measures uses census_tract_id and census_tract_vintage
• dep_index uses census_tract_fips
• degauss-org/census_block_group uses census_tract_id_2010, census_tract_id_2020
• degauss-org/st_census_tract uses census_tract_id and census_tract_vintage columns

https://cchmc.sharepoint.com/sites/BrokampGroup/Shared%20Documents/Forms/AllItems.aspx?id=%2Fsites%2FBrokampGroup%2FShared%20Documents%2FGeneral%2Fcompare%5Faw%5Fzcta%5Fdep%5Findex%2Ehtml&parent=%2Fsites%2FBrokampGroup%2FShared%20Documents%2FGeneral

add additional objects:

tibble of county name, state name, county_id (5 digit fips), sf geometry column

include for each area definitions in XLSX file on OneDrive

get_county_grouping(grouping = c("healthvine", "healthvine OH-KY-IN", "8-county catchment", "7-county catchment", "southwestern ohio")

• educating users of types of geographies available for Cincinnati
• comparison of different neighborhood sources
• demonstration of neighborhood CCHMC and census tract mapping

when from_id and to_id have the same name, this gets grouped by whichever one is first in the data (usually from_id instead of to_id)

example:

interpolate(from = cincy::tract_tigris_2020 |> filter(census_tract_id %in% c("39061026104", "39061026103")),
to = cincy::tract_tigris_2010 |> filter(census_tract_id == "39061026101"), 
wt = "pop")

returns missing values for 39061026101

but

interpolate(from = cincy::tract_tigris_2020 |> filter(census_tract_id %in% c("39061026104", "39061026103")) |> rename(census_tract_id_2020 = census_tract_id),
to = cincy::tract_tigris_2010 |> filter(census_tract_id == "39061026101") |> rename(census_tract_id_2010 = census_tract_id), 
wt = "pop")

works as expected.

avoid snapshot tests

in a vignette, documentation, or readme so we can point non-R people here for the definition

The zipcodes currently are retained even if they only touch with the county, but these should be excluded:

Change would go here for e.g., the 2010 tract data:

herre: https://github.com/geomarker-io/cincy/blob/6ea8a85925ff0f4a3cf87a5b806e1aad3c62bdaa/R/interpolate.R#LL136C45-L136C45

name output object and reassign attributes from input called from

link to this from vignette on {{cincy}} package about different geographies

• don't show detailed code for converting; instead, this will live in different vignette somewhere else

remove this from our list of Hamilton County ZIP codes here when we manually ignore some other ZIP codes that are intersected with Hamilton County shape: