Existing Hydro Non-powered Damms in Colorado

This data set contains a list of U.S. Existing Non-powered Dams (NPD) with hydropower potential greater than 1MW. This data set consists of geo-referenced digital data and associated attributes created in Hadjerioua B. Y. Wei S.-C. Kao and B. T. Smith (2012) An Assessment of Energy Potential at Non-powered Dams in the United States Technical Manual 2011/251 Oak Ridge National Laboratory Oak Ridge TN..

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 \"colorado-gov/existing-hydro-nonpowered-damms-in-colorado-ytai-hin3\".\"existing_hydro_nonpowered_damms_in_colorado\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.