Mosquito Application by Backpack (2020)

This dataset represents the GPS coordinates and other relevant information of where backpack application/treatment took place for mosquitoes for 2020.

A brief description of how it works:

GPS coordinates are obtained from a cell phone, which is connected to an Arduino. A stretch sensor connected to the Arduino is used to detect where pesticide is sprayed.

Things to consider when working with this dataset:

The setup has been tested for accuracy but it is possible for equipment to report incorrect data. Values may be changed due to correction or re-calibration. Values may also be incorrect due to malfunctioning equipment that went undetected for a period of time.

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/mosquito-application-by-backpack-2020-yvkj-876u\".\"mosquito_application_by_backpack_2020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.