Citizen Satisfaction Survey - Perception of Services

Since 1997, The City of Calgary has conducted its annual Citizen Satisfaction Survey to ask Calgarians how satisfied they are with City performance, programs, services, and overall quality of life in Calgary. This file is a summary of the services portion of the Citizen Satisfaction survey, and details how satisfied Calgarians are with each service, how important each service is for them, and whether or not The City should invest more, less, or the same amount in that service.

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 \"calgary-ca/citizen-satisfaction-survey-perception-of-services-s9g3-2u2e\".\"citizen_satisfaction_survey_perception_of_services\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.