Rainfall Gauge Results

The collection of significant rainfall measurements in the greater Edmonton area during the summer period. This data is used to assist in the mosquito control program. Mosquito Trap Data can be found at - https://data.edmonton.ca/Environmental-Services/Mosquitoes-Trap-Data/5zeu-wkpv

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/rainfall-gauge-results-7fus-qa4r\".\"rainfall_gauge_results\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.