Smart Cities - Edmonton Insight Community

This was one single topic among many, from the April 2018 Mixed Topic survey. To view the survey questions, click on the following link:

https://www.edmontoninsightcommunity.ca/S.aspx?s=868&r=bw4hh6S508nh9KK5g512C1&t=1

Open from April 17 - 24, 2018.

At the time the survey was launched survey invitations were sent to 7,774 Insight Community Members. 2,221 members completed the survey which represents a completion rate of 29%. A total of 2,239 respondents completed the survey: 2,221 Insight Community Members and 10 from the call to action button on our webpage and 8 using the anonymous link(s) on edmonton.ca/surveys which will have no demographic information.

Column definitions can be found as an attachment to this dataset (under the About option, in the Attachment section).

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/smart-cities-edmonton-insight-community-dw7e-u9iy\".\"smart_cities_edmonton_insight_community\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.