NYCPlanning / db-facilities-old

This repo contains all the scripts used to build the City Planning Facilities Database (FacDB). Please note this database and its build and maintenance processes are still in active development.
https://capitalplanning.nyc.gov/facilities
5 stars 3 forks source link

NYCHA community centers #114

Open hannahkates opened 7 years ago

hannahkates commented 7 years ago

Do these belong in FacDB? We definitely want to to call out which tenants are in NYCHA space and there could be value in including vacant centers.

hannahkates commented 7 years ago

New data for NYCHA community facilities is on Open Data now: https://data.cityofnewyork.us/Housing-Development/NYCHA-Facilities-and-Service-Centers/d4iy-9uh7/data

AmandaDoyle commented 6 years ago

Maybe if it is updated

hannahkates commented 6 years ago

The input for factype is formatted inconsistently. Need to trim off the " - " prefix when it appears. I also think it would be helpful to include "NYCHA Community Center - " as a prefix for the factype, so it's clearer that that it's a community center that is occupied by the "type" program.

image

hannahkates commented 6 years ago

The insertion of this table hasn't been added to the 2_assembly.sh script, so the records are missing from the final output table

hannahkates commented 6 years ago

These are being incorrectly classified as Public Safety > Police Services for facgroup > facsubgrp