Data table via SPARQL

List of Dams from dbpedia

Data table via SPARQL Published 03 May 2019 Last modified 12 Mar 2024

Topics: Water and marine environment

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

dam	label	country	description	length	elevation	lake	owner	purpose	river	damtatus	volume	locationMap	comment	geometry
<http://dbpedia.org/resource/A._I._Selden_Dam>	"A. I. Selden Dam"	"United States"	"Concretegravity dam"	"0.208483"^^<http://www.w3.org/2001/XMLSchema#double>	""	<http://dbpedia.org/resource/A._I._Selden_Dam__Lake__1>	""	""	"http://dbpedia.org/resource/Black_Warrior_River"	""	""	""	"A. I. Selden Dam is a dam in Hale County, Alabama. The concrete gravity dam was constructed in 1958 by the United States Army Corps of Engineers with a height of 71 feet (22 m) and 684 feet (208 m) long at its crest. It impounds the Black Warrior River for navigation and flood control. Named for the U.S. representative from Alabama, Armistead I. Selden, Jr., the dam is owned and operated by the Corps of Engineers."	"POINT(-87.840835571289 32.779167175293)"
<http://dbpedia.org/resource/Aar_Dam>	"Aar Dam"	"http://dbpedia.org/resource/Germany"	"Embankment, rock-fill"	"0.27"^^<http://www.w3.org/2001/XMLSchema#double>	"272.5"^^<http://www.w3.org/2001/XMLSchema#double>	<http://dbpedia.org/resource/Aar_Dam__Lake__1>	""	""	"http://dbpedia.org/resource/Aar_(Dill)"	""	"90000.0"^^<http://www.w3.org/2001/XMLSchema#double>	"Germany"	"The Aar Dam and its reservoir, the Aartalsee, lie in the upper Aar valley in the German state of Hesse. Both are in the municipalities of Bischoffen and Hohenahr in the county of Lahn-Dill-Kreis and about 15 km northwest of the town of Gie\u00dfen in Hesse. On the lakeshores lie the villages of and , both part of the parish of Hohenahr. Since 1991 the dam has impounded the River Aar, a left-hand tributary of the Dill in the Gladenbach Uplands. The reservoir is also fed by the Stadterbach, Wilsbach (into the forebay), Weidbach and Meerbach (into the main reservoir)."	"POINT(8.45472240448 50.699722290039)"
<http://dbpedia.org/resource/Aathupalayam_Dam>	"Aathupalayam Dam"	"India"	"Embankment"	"2.85"^^<http://www.w3.org/2001/XMLSchema#double>	""	<http://dbpedia.org/resource/Aathupalayam_Dam__Lake__1>	""	""	""	"O"	""	"India Tamil Nadu"	"The Aathupalayam Dam is situated in Karvazhi Village near Thennilai of K. Paramathi Taluk in Karur District. The parched aycut area has not been receiving supplies as the Aathupalayam reservoir had become a storage tank for Orathuppalayam polluted water flowing down the River Noyyal over the past few years."	"POINT(77.819725036621 11.02833366394)"
<http://dbpedia.org/resource/Aayash_Dam>	"Aayash Dam"	"Saudi Arabia"	""	""	""	""	"http://dbpedia.org/resource/Ministry_of_Environment,_Water_and_Agriculture_(Saudi_Arabia)"	"Flood control"	""	""	""	"Saudi Arabia"	"The Aayash Dam is a dam in Saudi Arabia opened in 2005 and located in Asir region. The main purpose of the dam is flood control."	"POINT(42.487499237061 19.696388244629)"
<http://dbpedia.org/resource/Aayash_Dam>	"\u0633\u062f \u0648\u0627\u062f\u064a \u0639\u064a\u0627\u0634"	"Saudi Arabia"	""	""	""	""	"http://dbpedia.org/resource/Ministry_of_Environment,_Water_and_Agriculture_(Saudi_Arabia)"	"Flood control"	""	""	""	"Saudi Arabia"	"The Aayash Dam is a dam in Saudi Arabia opened in 2005 and located in Asir region. The main purpose of the dam is flood control."	"POINT(42.487499237061 19.696388244629)"
<http://dbpedia.org/resource/Aberdeen_Lock_and_Dam>	"Aberdeen Lock and Dam"	"http://dbpedia.org/resource/United_States_of_America"	""	""	""	<http://dbpedia.org/resource/Aberdeen_Lock_and_Dam__Lake__1>	""	""	""	"O"	""	""	"The Aberdeen Lock and Dam is one of four lock and dam structures on the Tennessee-Tombigbee Waterway that generally lie along the original course of the Tombigbee River. It is located east of Aberdeen in Monroe County, Mississippi and impounds Aberdeen Lake."	"POINT(-88.519721984863 33.830554962158)"
<http://dbpedia.org/resource/Abiquiu_Dam>	"Abiquiu Dam"	"United States"	"Embankment"	"0.54864"^^<http://www.w3.org/2001/XMLSchema#double>	""	<http://dbpedia.org/resource/Abiquiu_Dam__Lake__1>	""	""	"http://dbpedia.org/resource/Rio_Chama_(Rio_Grande)"	""	""	""	"Abiquiu Dam is a dam on the Rio Chama, located about 60 miles (97 km) northwest of Santa Fe in Rio Arriba County, New Mexico. Built and operated by the U.S. Army Corps of Engineers (USACE), the dam is an earth embankment structure 354 feet (108 m) high and 1,800 feet (550 m) long, containing 11.8 million cubic yards (9,022,000 m3) of fill. The dam forms Abiquiu Lake, one of the largest lakes in New Mexico with a full storage capacity of 1,369,000 acre-feet (1,689,000 dam3) and 5,200 acres (2,100 ha) of water. To date, the reservoir has never filled to capacity, with a record high of 402,258 acre-feet (496,178 dam3), 29.4% of full pool, on June 22, 1987. The dam's primary purpose is flood control, in addition to irrigation and municipal water storage, and hydroelectric generation."	"POINT(-106.42610931396 36.238056182861)"
<http://dbpedia.org/resource/Abitibi_Canyon_Generating_Station>	"Abitibi Canyon Generating Station"	"Canada"	""	""	""	""	"http://dbpedia.org/resource/Ontario_Power_Generation"	"P"	"http://dbpedia.org/resource/Abitibi_River"	"O"	""	"Ontario"	"Abitibi Canyon Generating Station is a hydroelectric power plant owned by Ontario Power Generation on the Abitibi River. The station is located 80 km north of Smooth Rock Falls, within Pitt Township in Northern Unorganized Cochrane District, in Ontario, Canada."	"POINT(-81.570831298828 49.877777099609)"
<http://dbpedia.org/resource/Abitibi_Canyon_Generating_Station>	"\u0413\u0415\u0421 \u0410\u0431\u0456\u0442\u0456\u0431\u0456-\u041a\u0430\u043d\u044c\u0439\u043e\u043d"	"Canada"	""	""	""	""	"http://dbpedia.org/resource/Ontario_Power_Generation"	"P"	"http://dbpedia.org/resource/Abitibi_River"	"O"	""	"Ontario"	"Abitibi Canyon Generating Station is a hydroelectric power plant owned by Ontario Power Generation on the Abitibi River. The station is located 80 km north of Smooth Rock Falls, within Pitt Township in Northern Unorganized Cochrane District, in Ontario, Canada."	"POINT(-81.570831298828 49.877777099609)"
<http://dbpedia.org/resource/Achwa_1_Hydroelectric_Power_Station>	"Achwa 1 Hydroelectric Power Station"	"http://dbpedia.org/resource/Uganda"	""	""	""	""	""	""	"http://dbpedia.org/resource/Achwa_River"	"UC"	""	"Uganda"	"The Achwa 1 Hydroelectric Power Station (A1HPS), also Achwa I Hydroelectric Power Station, is a hydroelectric power station currently under construction (2020) in Uganda, with a planned installed capacity of 41 megawatts (55,000 hp)."	"POINT(32.514167785645 3.1480555534363)"

Received 5749 rows in 0.241 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/list-of-dams-from-dbpedia/daviz.json

For system integrators

Linked Data query (SPARQL)

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org

SPARQL Endpoint:
http://dbpedia.org/sparql

SPARQL Query:


        PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX http: <http://www.w3.org/2011/http#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX dbp: <http://dbpedia.org/property/>
PREFIX dbi: <http://dbpedia.org/ontology/Infrastructure/>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>

SELECT DISTINCT
?dam
str(?label) as ?label
str(?country) as ?country
str(?description) as ?description
xsd:double(str(?length)) as ?length
xsd:double(str(?elevation)) as ?elevation
?lake
#?location
str(?owner) as ?owner
str(?purpose) as ?purpose
str(?river) as ?river
str(?damtatus) as ?damtatus
xsd:double(str(?volume)) as ?volume
str(?locationMap) as ?locationMap
str(?comment) as ?comment
str(?geometry) as ?geometry
WHERE
{
 ?dam rdf:type <http://dbpedia.org/ontology/Dam> .
 #FILTER (str(?dam) = 'http://dbpedia.org/resource/Ain_Zada_Dam')
 ?dam rdfs:label ?label .
 ?dam dbp:country ?country .
 OPTIONAL { ?dam dbo:description ?description }
 OPTIONAL { ?dam dbi:length ?length }
 OPTIONAL { ?dam dbo:elevation ?elevation }
 OPTIONAL { ?dam dbo:lake ?lake }
 OPTIONAL { ?dam dbo:location ?location }
 OPTIONAL { ?dam dbo:owner ?owner }
 OPTIONAL { ?dam dbo:purpose ?purpose }
 OPTIONAL { ?dam dbo:river ?river }
 OPTIONAL { ?dam dbo:status ?damtatus }
 OPTIONAL { ?dam dbo:volume ?volume }
 OPTIONAL { ?dam dbp:locationMap ?locationMap } 
 OPTIONAL { ?dam rdfs:comment ?comment 
            FILTER (lang(?comment) = 'en')
}
 OPTIONAL { ?dam geo:geometry ?geometry }
 
}
ORDER BY ?dam

Permalinks

Permalink to this version: 6fbb918eab4b45d19f2aab357f00c8cd
Permalink to latest version: S1NM4VDI72

Geographic coverage

Albania Armenia Austria Azerbaijan Belarus Belgium Bosnia and Herzegovina Bulgaria Croatia Cyprus Czechia Denmark Estonia Finland France Georgia Germany Greece Hungary Iceland Ireland Italy Kazakhstan Kosovo Kyrgyzstan Latvia Liechtenstein Lithuania Luxembourg Malta Moldova Monaco Montenegro Netherlands North Macedonia Norway Poland Portugal Romania Russia San Marino Serbia Slovakia Slovenia Spain Sweden Switzerland Tajikistan Turkey Turkmenistan Ukraine United Kingdom Uzbekistan