Strategic Measure_Number and percentage of creeks and lakes in good or excellent health

Strategic Direction 2023 (SD23) Measure HE.D.3 reports the number and percentage of creeks and lakes in good or excellent health. This measure is calculated every two years using the monitoring data from the Watershed Protection Department's Environmental Integrity Index (EII) and Austin Lakes Index (ALI) programs. These programs monitor and assess the chemical, biological, and physical integrity of Austin’s creeks and lakes.

Note: Due to software limitations, the scores for one biennial reporting period (e.g., FY2013/2014) are repeated twice in the dataset in order to enable the creation of data visualizations that require annual reporting.

View more details and insights related to this measure on the story page: https://data.austintexas.gov/stories/s/d5yi-gac8

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 \"datahub-austintexas-gov/strategic-measurenumber-and-percentage-of-creeks-773s-mqs2\".\"strategic_measurenumber_and_percentage_of_creeks\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.