Tree Insects & Other Pests (2019)

This dataset shows the pesticide treatment activity of the Tree Insects & Other Pests Management Program.

https://www.edmonton.ca/city_government/environmental_stewardship/public-notice-of-pesticide-programs.aspx

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/tree-insects-other-pests-2019-fm4j-2cvh\".\"tree_insects_other_pests_2019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.