Mosquito Application by Backpack (2019)
This dataset represents the GPS coordinates and other relevant information of where backpack application/treatment took place for mosquitoes for 2019.
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-2019-kkws-6gjr\".\"mosquito_application_by_backpack_2019\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.