NYCPlanning / db-factfinder

data ETL for population fact finder (decennial + acs)
https://nycplanning.github.io/db-factfinder/factfinder/
MIT License
2 stars 3 forks source link

2021 ACS Metadata missing `category` field. #254

Closed TylerMatteo closed 1 year ago

TylerMatteo commented 1 year ago

I was debugging an issue that Population found while testing the new ACS data in PFF and I have hunch that the root cause is that the metadata file for the 2021 ACS data is missing the category field. Our scripts download those metadata.json files and use them to associate rows with each other in our app. The metadata file for 2010 still has them and I don't think they've changed. Is is possible to add that field back to 2021 metadata? Thanks!

damonmcc commented 1 year ago

per PR https://github.com/NYCPlanning/db-factfinder/pull/252, 2021/metadata.json was provided by the Population team. not sure how they generated it, just sent an email to Population

damonmcc commented 1 year ago

I generated it 🤦🏾‍♂️ by converting the excel file provided by Population to json. have received a new excel file and will regenerate json file