NYCPlanning/db-housing

Issues

• For A1 jobs, adjust units_net_complete field calculation

  #57 opened 6 years ago by AmandaEyer
  1

• Jobs marked as Complete but units_net_complete is null and lastest CO units not showing up in the unit change fields

  #58 opened 6 years ago by mqli322
  0

• Map the geometry to the center of the lot

  #52 opened 6 years ago by AmandaDoyle
  1

• Pull in unit_change value from dcp_attributes

  #53 opened 6 years ago by AmandaEyer
  6

• CO calculation for A1 jobs

  #54 opened 6 years ago by AmandaEyer
  3

• Future improvement of Database

  #47 opened 6 years ago by AmandaEyer
  2

• Geocoding

  #51 opened 6 years ago by AmandaEyer
  1

• Lat Long Mixup

  #50 opened 6 years ago by AmandaEyer
  1

• Small other things to discuss

  #37 opened 6 years ago by AmandaEyer
  2

• Include DCP attribute corrections

  #48 opened 6 years ago by AmandaEyer
  1

• Exclude records from Housing Database

  #46 opened 6 years ago by AmandaEyer
  4

• Missing fields

  #49 opened 6 years ago by AmandaEyer
  1

• Clean up hotel records

  #45 opened 6 years ago by AmandaEyer
  0

• Please pull "Job Description" field from Job Applications file

  #18 opened 7 years ago by AmandaEyer
  3

• Update to mixed use flag

  #25 opened 7 years ago by AmandaEyer
  2

• Populate x_withdrawal as YES if specialactionstatus = W OR c

  #44 opened 6 years ago by AmandaDoyle
  2

• Add logic to QC_outliers so that records that were previously verified as non outliers are not added

  #43 opened 6 years ago by AmandaDoyle
  1

• Complete unit_change field for Demolitions

  #38 opened 6 years ago by AmandaEyer
  4

• Occupancy QC missing

  #40 opened 6 years ago by AmandaEyer
  1

• Database needs geocoding

  #42 opened 6 years ago by AmandaEyer
  1

• We should update the "inactive" flag

  #39 opened 6 years ago by AmandaEyer
  1

• Non-residential applications lack CO data

  #26 opened 7 years ago by AmandaEyer
  1

• Flag for manual review

  #28 opened 6 years ago by mqli322
  5

• Is it possible aggregate completions not by year but biannually?

  #21 opened 7 years ago by AmandaEyer
  2

• Criteria for Final Outputs (both housing and all developments)

  #35 opened 6 years ago by AmandaEyer
  1

• Negative 2018 Unit change Numbers

  #31 opened 6 years ago by BillS85
  7

• Recoding of Garages and Rear Building Records

  #23 opened 6 years ago by BillS85
  6

• Issue with unit_change field for 2010 and 2011

  #36 opened 6 years ago by AmandaEyer
  1

• HDB looking Good But.....

  #33 opened 6 years ago by BillS85
  2

• Change code for outliers QC

  #34 opened 6 years ago by AmandaEyer
  1

• Add "mixed_use_flag" field to database

  #19 opened 7 years ago by AmandaEyer
  2

• add dob occupancy code I-1 to housing export of database

  #24 opened 6 years ago by AmandaEyer
  1

• Add missing jobs to the database

  #29 opened 6 years ago by AmandaEyer
  1

• Withdrawn records aren't being labeled correctly in the dcp_status field

  #10 opened 7 years ago by hannahkates
  2

• Assisted Liviving with Other DCP category

  #32 opened 7 years ago by BillS85
  1

• Add _2018 fields

  #30 opened 7 years ago by AmandaDoyle
  1

• Flag as outlier

  #27 opened 7 years ago by mqli322
  18

• DCP corrected records was not incorporated

  #11 opened 7 years ago by AmandaEyer
  3

• the database is missing a status_x_year field

  #16 opened 7 years ago by AmandaEyer
  6

• Update housing_input_lookup_occupancy.csv so that it is a proper lookup table

  #22 opened 7 years ago by AmandaDoyle
  2

• Missing records because parameters does not include pre-2008 residential code (J-0, J-2, J-3)

  #17 opened 7 years ago by AmandaEyer
  5

• We should ask DOB why/when the occupancy codes RES, COM and PUB are still used, even though they pre-date 1968 building code.

  #12 opened 7 years ago by AmandaEyer
  1

• Job 104592068 has a dob_occ_init and prop with a period, and is not classified

  #13 opened 7 years ago by AmandaEyer
  1

• Units_net should only be calculated when both u_init and u_prop are available

  #7 opened 7 years ago by hannahkates
  1

• Why aren't the new column names reflected in the export?

  #8 opened 7 years ago by hannahkates
  1

• Columns that we decided to drop are still in there

  #15 opened 7 years ago by AmandaEyer
  1

• thousands of records are missing

  #14 opened 7 years ago by AmandaEyer
  1

• the_geom field doesn’t need to exist anymore

  #9 opened 7 years ago by hannahkates
  1

• Units_prop = 0 needs to be filled in for all demolition projects

  #6 opened 7 years ago by hannahkates
  1

• Units_init = 0 needs to be filled in for all new new building projects

  #5 opened 7 years ago by hannahkates
  1