Parks Supervisor Inspections - Feature Findings

Supervisor Inspections are conducted by Park Supervisors in order to assess the conditions and identify issues at parks in their districts. Park Supervisors follow the standards set out in the Parks Inspection Program (PIP) Inspection Manual but are not trained in the protocol to the same degree as PIP inspectors, and supervisor inspections are not subject to the thorough review that PIP inspections receive.

During the course of an inspection, Park Supervisors separately rate each feature within a park. This table contains the features inspected, with ratings and notes for each feature.

Overall results and inspection-level records are contained in the Parks Supervisor Inspections - Inspection Results dataset; each row in this table represents one inspection of an individual property (park, playground, or zone).

Specific feature-level records are contained in the Parks Supervisor Inspections - Feature Findings dataset; each row in this table represents the specific feature's details/rating from each inspection.

Data Dictionary: https://docs.google.com/spreadsheets/d/17nwvIsPdAInf-DzGAcwq8hu6SXIzQYabUDktw3BwwLY/edit#gid=1553660070

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/parks-supervisor-inspections-feature-findings-wag2-kf63\".\"parks_supervisor_inspections_feature_findings\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.