NYCPlanning / data-engineering

Primary repository for NYC DCP's Data Engineering team
22 stars 0 forks source link

PLUTO QAQC page: add 2020 census tract field to the report #1087

Open sf-dcp opened 2 months ago

sf-dcp commented 2 months ago

Follow-up to this comment

sf-dcp commented 2 days ago

Checked with GIS, this doesn't necessarily need to be added to the QAQC page if we can do an internal data check that census tracts don't change. It's a better approach because adding a 2020 census tract to the QAQC page won't be a "clean" approach: we would need to add a column to the QAQC mismatch table in SQL and make it backwards compatible.

Will be exploring how we can check this as a part of PLUTO build.