Icon for Socrata external plugin
Open repository in Console
Updated 11 months ago
Indexed 10 days ago

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" \
{"sql": "
    SELECT *
    FROM \"edmonton-ca/mosquito-application-by-backpack-2020-yvkj-876u\".\"mosquito_application_by_backpack_2020\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • mosquito_application_by_backpack_2020
Upstream Metadata