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.