Watershed Reach Index and Problem Scores

The Environmental Integrity Index (EII) is a tool developed by the City of Austin’s Environmental Resource Management Division to monitor and assess the ecological integrity and the degree of impairment in Austin’s watersheds. This feature class provides the most recent results from the EII for the City of Austin Watershed Protection Department’s Masterplanning process. Similarly, the Austin Lakes Index was designed to provide a yearly assessment of the ecological integrity of Lake Austin, Lady Bird Lake, and Lake Long.

Index scores (from both the EII and ALI) are an integer between 0 and 100. Excellent 88-100 | Very Good 76-87 | Good 63-75 | Fair 51-62 | Marginal38-50 | Poor 26-37 | Bad 13-25 | Very Bad 0-12.

Problem Scores are an integer between 1 and 100 with 1 being "No Problem" and 100 being a highest priority.

EII Methodology:

http://www.austintexas.gov/watershed_protection/publications/document.cfm?id=186267

Master Plan Problem Score Methodology:

http://www.austintexas.gov/watershed_protection/publications/document.cfm?id=186352

Lake Index Methodology:

http://www.austintexas.gov/watershed_protection/publications/document.cfm?id=196479

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/watershed-reach-index-and-problem-scores-vk3r-6prc\".\"watershed_reach_index_and_problem_scores\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.