NYCPlanning db-housingdev issues

NYCPlanning / db-housingdev

Please note this is the legacy repo. New repo is db-housing

3 stars 0 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Excl from CO calc fields - see detail

#67 mqli322 opened 6 years ago
0
Flag as outlier

#66 mqli322 opened 6 years ago
0
Standardize True/False, Y/N values for all binary fields

#65 hannahkates opened 6 years ago
0
Integrate updated DOB occupancy code assignment and recoding

#64 hannahkates opened 6 years ago
0
Add spatial joins

#63 hannahkates opened 6 years ago
0
Revise DCP's occupancy labels

#62 hannahkates opened 6 years ago
0
Validate 5+ yr = inactive assumption

#61 hannahkates opened 6 years ago
0
Validate 80% = complete assumption

#60 hannahkates opened 6 years ago
0
Define data quality standards - what should be the unit threshold for manual research and geocoding?

#59 hannahkates opened 6 years ago
0
Identify better geocoding method that doesn't map points in the water

#58 hannahkates opened 6 years ago
1
GBAT-A provided some BBL = '0' values

#57 hannahkates opened 6 years ago
0
Decide on approach for mixed-use developments and res->hotel hotel->res conversions

#56 hannahkates opened 6 years ago
0
Large projects that aren't geocoded

#55 hannahkates closed 6 years ago
1
GBAT-E records are missing BBLs

#54 hannahkates opened 6 years ago
0
Fix Queens addresses converted to dates

#53 hannahkates opened 6 years ago
1
Not all “complete” job records have corresponding CofO records

#52 hannahkates opened 6 years ago
0
Fix missing addresses that didn't get concatenated

#51 hannahkates closed 6 years ago
1
Split out units completed pre-April 2010 and post-April 2010 to help with census/population work

#50 hannahkates closed 6 years ago
1
Look into CofO records that say there were issued in 2020

#49 hannahkates opened 6 years ago
1
Identify which demolitions are partial vs full demolitions

#48 hannahkates opened 6 years ago
0
Fix spelling of "Other Accomodations"

#47 hannahkates closed 6 years ago
1
Join HPD Housing NY info onto records

#46 hannahkates opened 7 years ago
1
Change dcp_occ_init to 'Empty Lot' for NB and dcp_occ_prop to 'Empty Lot' for demolitions

#45 hannahkates closed 6 years ago
1
Consider excluding dcp_status = 'disapproved' from all analysis

#44 hannahkates closed 6 years ago
1
Fill in missing borough values using BBL

#43 hannahkates closed 6 years ago
1
Fill in missing addresses with BBL address in PLUTO

#42 hannahkates closed 6 years ago
1
Update sequence of creating fields so that they appear in a nice order

#41 hannahkates closed 6 years ago
1
Residential --> other accommodation conversations are labeled as other accommodations

#40 hannahkates closed 6 years ago
1
Fill in x_inactive as false for records that are complete

#39 hannahkates closed 6 years ago
0
Update disclaimers, documentation, and process diagram

#38 hannahkates opened 7 years ago
0
Add floodplain fields to data dictionary

#37 hannahkates closed 6 years ago
1
R-1 and J-1: delineating whether hotel/motel OR dorms

#36 mqli322 opened 7 years ago
0
Still counting units incomplete even with X status

#35 mqli322 closed 6 years ago
1
Demos: Fill in number of total existing units (0 after a demo is completed, u_init before demo is completed)

#34 hannahkates closed 7 years ago
1
Fill in dcp_status for projects where blank

#33 hannahkates closed 7 years ago
1
2_dob_cofos_process Step 3 Concerns

#32 hannahkates closed 7 years ago
1
Make sure u_net and and u_net_complete calcs are being done correctly for NB and DM

#31 hannahkates closed 7 years ago
1
Update field names for clarity

#30 hannahkates closed 7 years ago
2
Create flag for data freshness (are units unlikely to come to fruition?)

#29 hannahkates closed 7 years ago
2
Create table of potential duplicates for further investigation

#28 hannahkates closed 7 years ago
1
units_net is only calculated when both units_init and u_prop contain real values

#27 hannahkates closed 6 years ago
3
How can adding columns for new years be made easier?

#26 hannahkates closed 6 years ago
0
Create system for easily identifying which records have changed between data refreshes

#25 hannahkates closed 6 years ago
0
Create and populate multiple columns at once when there isn’t WHERE criteria

#24 hannahkates closed 7 years ago
1
Should we really put in fake CofO dates for demos - rename field?

#23 hannahkates closed 7 years ago
2
Add column for flagging manual edits to data

#22 hannahkates closed 7 years ago
1
Step 4 in CofOs processing

#21 hannahkates closed 7 years ago
1
Blank dates in jobs data getting turned into wrong date '2001-01-01'

#20 hannahkates closed 7 years ago
1
Consider relabeling units_exist as units_initial

#19 hannahkates closed 7 years ago
1
Make sure to exclude withdrawn and duplicates from analysis

#18 hannahkates closed 7 years ago
1