TIF Data Quality Issue?
Mildly going insane looking at TIFs. I was running some completeness checks and have a strange result where some TIFs appear to be missing.
Let's just focus on one TIF. City of Chicago - Clark / Montrose
tbl(ptaxsim_db_conn, 'agency_info') %>% collect() %>%
filter(agency_num %in% c('030210629', '030210539'))
tbl(ptaxsim_db_conn, 'tif_distribution') %>% collect()%>%
filter(agency_num %in% c('030210629', '030210539'))
readxl::read_excel('ptaxsim/data-raw/tif/distribution/2021 TIF Agency Distribution Report_0.xlsx') %>%
filter(`TIF Agency` %in% c('030210629', '030210539'))
st_read(paste0(
"https://opendata.arcgis.com/api/v3/datasets/",
"8aeb00520c544aafb9a22510465c679d_18/downloads/",
"data?format=geojson&spatialRefId=4326&where=1%3D1"
), quiet = TRUE) %>%
filter(AGENCYNUM %in% c('030210629', '030210539'))
- agency_info has only 030210539
- tif_distribution has 030210629 and 030210539 for all years
- clerk distribution has 030210629 and 030210539 in 2021
- cook central tif shapefile has only 030210539
Any thoughts here? It looks like the same tif has two agency numbers and tax codes but I can't find a shapefile for it to confirm if 030210629 and 030210539 are the same.
Edited by Dan Snow