Flood Mitigation - Edmonton Insight Community

This was one single topic among many as part of the January 2017 Mixed Topic survey. To view the survey questions, click on the following link:

https://www.edmontoninsightcommunity.ca/R.aspx?a=1503&as=Vo00JJ2YW5&t=1

Open from January 10 - 17, 2017.

At the time the survey was launched survey invitations were sent to 6533Insight Community Members. 1638 members completed the survey which represents a completion rate of 25%. A total of 1646 respondents completed the survey: 1638 Insight Community Members and 7 using the anonymous link(s) which will have no demographic info.

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/flood-mitigation-edmonton-insight-community-9zfy-62bn\".\"flood_mitigation_edmonton_insight_community\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.