Cannabis Consumption In Public Spaces - Edmonton Insight Community

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

https://www.edmontoninsightcommunity.ca/c/a/5tKHEJ44EOxCU3WV2dl88H?t=1

Open from February 13 - 20, 2018.

At the time the survey was launched survey invitations were sent to 7,131 Insight Community Members. 2,024 members completed the survey which represents a completion rate of 28%. A total of 2,071 respondents completed the survey: 2,024 Insight Community Members and 7 from the call to action button on our webpage and 40 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/cannabis-consumption-in-public-spaces-edmonton-q33t-23hf\".\"cannabis_consumption_in_public_spaces_edmonton\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.