add DCP housing Database

[austensen]

DOB deals with all the whole complicated process of permits, jobs, and certificates of occupancy. They have a ton of different dataset, and are always making changes to them, and the quality is often pretty poor. Thankfully, City Planning has undertaken the task of compiling all the most useful parts of those DOB sources, cleaned and geocoded, and released a single database with useful info on buildings (demolitions, new buildings, alterations).

We should add the project level file csv, and call the table dcp_housingdb_22q2. (We'll handle the versions like we have done for pluto).

https://www.nyc.gov/site/planning/data-maps/open-data/dwn-housing-database.page#housingdevelopmentproject

We'll also need a documentation page. (data dictionary) we should also link to dcp's github repo for building this database

• [x] add additional table to dataset
• [ ] add documentation to wiki
• [ ] add example query to wiki

Multiple people can work on these parts (documentation and adding the dataset can happen simultaneously). Comment below to claim a part of this work.

[austensen]

I'm working on adding the dataset

[austensen]

I created the new wiki documentation page so it could be linked from the README, but it still needs to be filled out. https://github.com/nycdb/nycdb/wiki/Dataset:-DCP-Housing-Database