Historical Drought Permits -- Washington State

During times of declared drought (WAC 173-166), the Department of Ecology may approve temporary water right applications and water right transfers for emergency drought relief. This data set lists approved drought permits from the years 2005 and 2001.

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 \"wa-gov/historical-drought-permits-washington-state-w9k2-96gh\".\"historical_drought_permits_washington_state\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.