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..
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.