July 2021 Mixed Topic - Sorting Waste in Public Spaces - Edmonton Insight Community

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

https://www.edmontoninsightcommunity.ca/c/a/6NKy8plNpEnE8sKG4CTYiO?t=1

Open from July 13-20, 2021.

At the time the survey was launched survey invitations were sent to 13,553 Insight Community Members. 3322 members completed the survey which represents a completion rate of 24.51%. A total of 3326 respondents completed the survey: 3322 Insight Community Members, 1 from the call to action button on our webpage, and 3 using the anonymous link on Edmonton.ca/Surveys which will have no demographic info.

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/july-2021-mixed-topic-sorting-waste-in-public-5rrk-8guy\".\"july_2021_mixed_topic_sorting_waste_in_public\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.