NYCHA Facilities and Service Centers

Contains all occupied and vacant facilities portfolio from Facility Planning (commercial spaces) and Community Operations (community centers, senior centers, day care centers, health centers, etc) It includes the 5 Community Operations borough offices. The source data is our latest Property Directory as December 2012. The field “Comments” contains summary codes to distinguish the type of facility (BO – NYCHA Community Operations Borough Offices, CO – Community Operations, FP – Facility Planning). Please note that there are two commercial spaces (not coded under field “comments”)recorded in our property directory which are not part of the portfolio for Facility Planning.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/nycha-facilities-and-service-centers-d4iy-9uh7\".\"nycha_facilities_and_service_centers\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.