PRCF - Parks Ranger Reports
The Park Rangers report monthly on the number of warnings or citations given, the total number of parks visited for the month, and the total number of warnings or citations that were related to the population of homeless.
This data populates directly from a SharePoint form.
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 \"citydata-mesaaz-gov/prcf-parks-ranger-reports-daky-m4y3\".\"prcf_parks_ranger_reports\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.