search

NYCPlanning / db-developments

🏠 🏘️ 🏗️ Developments Database
https://nycplanning.github.io/db-developments
8 stars 2 forks source link

20Q2 - Final output tables #186

Closed mgraber closed 4 years ago

mgraber commented 4 years ago

173

174

Since the refactor, the package of tables we need to deliver for review is slightly different. What tables need to get delivered for HED to perform their manual review?

  1. Developments database in new schema as outlined in this spreadsheet a. Csv for all records b. Csv for records that don’t have a geometry c. Shapefile for records that have a geometry

  2. Housing database, which is a subset of DevDB a. Csv for all records b. Csv for records that don’t have a geometry c. Shapefile for records that have a geometry

  3. Six aggregate tables as 6 separate tables

  4. QAQC outputs a. FINAL_qaqc table as csv b. HNY_no_match table as csv

  5. Corrections files a. CORR_hny_match b. housing_input_research aka manual corrections table

SPTKL commented 4 years ago

I'm thinking we don't have to output housing_input_research? the only place where housing_input_research would change is adding bistest records. since HED is ok with removing them directly, housing_input_research will not change

mgraber commented 4 years ago

I'm thinking we don't have to output housing_input_research? the only place where housing_input_research would change is adding bistest records. since HED is ok with removing them directly, housing_input_research will not change

Don't they need to be able to add to it or modify it?

levysamu commented 4 years ago

If it's all the same to you, I think you should give us the manual inputs table to confirm that we have the same version that you are using. I would hate to have any confusion on that front.

kschmidtDCP commented 4 years ago

@AmandaDoyle @mgraber @SPTKL Tables 1b and 2b (csv for records without a geometry) should be unnecessary. Records without a geometry will be captured in the QAQC table, and 100% geocoded by HED. Therefore, the final output should never include records without a geometry.