CO2 Mosquito Trap Data

Capture results of mosquitoes from various locations in Edmonton. These collections are from CO2 traps that are used to record changes in abundance of mosquitoes before and after control campaigns and to compare seasonal and annual fluctuations in population. Not all trap collection sites are factored into the historical averages. Some data can be incomplete due to trap failure. Some trap locations change over time. Trap collections reflect, not absolute population levels, but mosquito activity, which is influenced by changing environmental conditions (temperature, humidity, wind, etc.). The weekly averages do not include any male mosquitoes or any females of species that do not typically bite people. Each data set reflects the mosquito activity of the week previous to the collection date.

To complement this dataset, there is the Rainfall Gauge data which measures rainfall data in the Greater Edmonton area:

https://data.edmonton.ca/Environmental-Services/Rainfall-Gauge-Results/7fus-qa4r

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/co2-mosquito-trap-data-uezh-cisn\".\"co2_mosquito_trap_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.