Groundwater Chemistry in Ramotswa, Botswana - Rainwater Chemistry Dataset

Rainwater collected in clean bucket in Gaborone. Filtered and refrigerated before analysis. All concentrations in mg/L. Analyzed at WaterLab in Pretoria, South Africa.

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 \"usaid-gov/groundwater-chemistry-in-ramotswa-botswana-828y-ynhz\".\"groundwater_chemistry_in_ramotswa_botswana\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.