AUSRIVAS dataset

AUSRIVAS (Australian River Assessment System) is a river condition monitoring program that uses the environmental sensitivity of aquatic macroinvertebrates to assess the condition of waterways. AUSRIVAS predicts the macroinvertebrate fauna expected to occur at a site with specific environmental characteristics, in the absence of environmental stress. The fauna observed (O) at a site can then be compared to fauna expected (E), with the deviation between the two providing an indication of biological condition. A site displaying no biological impairment should have an O/E taxa score close to one. The O/E taxa score will decrease as the macroinvertebrate assemblage and richness are adversely affected.

ACT Government maintains 13 AUSRIVAS monitoring locations across the ACT. Sampling is undertaken twice per year (spring and autumn). Site details are provided in another dataset. The O/E taxa score (Score) is provided in this dataset, along with the siteID, Site Name, Season in which the survey was undertaken, and the Year in which the survey was undertaken.

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 \"data-act-gov-au/ausrivas-dataset-w365-dkdh\".\"ausrivas_dataset\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.