Park Quality

This Indicator measures overall ratings for Oakland parks and compares average scores by City Council District. The overall ratings were based on an annual survey that assigned parks letter grades (A through F), which corresponded to scores (A=4, B=3, C=2, D=1 and F=0). In addition to Council District scores, the scores for parks surrounding Lake Merritt were reported as an average Lakeside score. The survey also included questions about greenery, amenities, recreation areas, and homeless encampments. For a map of the City Council Districts, see here: http://www2.oaklandnet.com/oakca1/groups/ceda/documents/image/oak044524.pdf.

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 \"oaklandca-gov/park-quality-sbr3-iqtb\".\"park_quality\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.