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