Edmontonians' Perception Survey - City Design And Attractiveness

In 2014, the City of Edmonton contracted Leger to conduct a survey of Edmontonians designed to understand perceptions on key measures relating to the quality of life in Edmonton.

This research is aimed at capturing citizen perception based performance measures which feed into the corporate performance reporting to achieve the City’s vision for 2040 (The Way Ahead). In recent years, Citizen Perception Surveys have been carried out annually to gather data and report on the measures.

Taking into account the recent modifications in performance measures as well as the focus on continuous improvement, the 2014 research was designed to:

• Measure the progress with respect to the key performance measures

• Understand the drivers of the performance measures and provide recommendations about how the measures can be further improved.

• Make comparisons with past measures wherever applicable

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 \"edmonton-ca/edmontonians-perception-survey-city-design-and-uhk5-49bk\".\"edmontonians_perception_survey_city_design_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.