NYCPlanning / db-zap-opendata

Workflow for creating subset of ZAP data that's on open data
0 stars 0 forks source link

ZAP Open Data QAQC #22

Open AmandaDoyle opened 2 years ago

AmandaDoyle commented 2 years ago
SashaWeinstein commented 2 years ago

This is a good question, applicant type breaks the pattern of all the other columns. The SQL to switch the field names was written before I started so the open data has always had these fields names. Easy to switch over, needs to be changed in 2 places, SQL query and recode process

croswell81 commented 2 years ago

yes, it should be applicant_type according to the data dictionary. I will review all field names once I confirm access to the data.