The DePaul IHS releases quarterly housing index data at the census PUMA level; problematically for us this data continues to use 2010 PUMA geographies which we don't have for any parcels that didn't exist before 2022.
This issue could be solved using forward and nearest neighbor filling in our SQL views or, in my opinion, could be solved much more quickly by joining a list of all of the unique PIN10s to 2010 PUMA geography and refactoring the housing index to become parcel-level (and for that matter yearly rather than quarterly) rather than PUMA-level during ingest.
The DePaul IHS releases quarterly housing index data at the census PUMA level; problematically for us this data continues to use 2010 PUMA geographies which we don't have for any parcels that didn't exist before 2022.
This issue could be solved using forward and nearest neighbor filling in our SQL views or, in my opinion, could be solved much more quickly by joining a list of all of the unique PIN10s to 2010 PUMA geography and refactoring the housing index to become parcel-level (and for that matter yearly rather than quarterly) rather than PUMA-level during ingest.