RSMP Illicit Discharge Detection and Elimination (IDDE)

Most Municipal Separate Storm Sewer System (MS4) permittees in the State of Washington are a part of the Regional Stormwater Monitoring Program (RSMP). One part of the RSMP is the Source Identification Information Repository. Permittees may choose to enter their permit-required illicit discharge data into this dataset using a form, simplifying both their reporting processes and analyses for the RSMP.

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/rsmp-illicit-discharge-detection-and-elimination-ikwr-f47z\".\"rsmp_illicit_discharge_detection_and_elimination\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.