NYC Parks Sectors

In order to appropriately manage City parks and allocate resources, NYC Parks has implemented three tiers of management below the Borough level. These three tiers can be represented as administrative geographic boundaries and are defined below:

District - One or more parks that are combined and generally align with New York City Community Boards.

Sector - One or more Park Districts that are combined in order share resources for daily maintenance.

Region - One or more Park Sectors that are combined and assigned a regional managers who provides high-level, strategic planning and support for Parks managers, including maximizing resources between Districts and Sectors.

Data Dictionary: https://docs.google.com/spreadsheets/d/1-FS_NDOUx0-OfKploVC0fIJrwOSdNmh1HKpkfyeoD1E/edit?usp=sharing

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/nyc-parks-sectors-t4re-ksn6\".\"nyc_parks_sectors\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.