List of Dams from dbpedia

Data table via SPARQL Published 03 May 2019 Last modified 03 May 2019

Download this dataset

Dataset preview

(Live Query)

dam label country description length elevation lake owner purpose river damtatus volume locationMap comment geometry
<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__1> "" "" "" "O" "" "India Tamil Nadu" "The Aathupalayam Dam is situated in Karvazhi village 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. The storage facility was meant to harness excess flood water flowing down River Noyyal and draining from the Lower Bhavani Project (LBP) canal to irrigate more than 19,000 acres in Karur district. Usually the excess LBP water flows down the Malayathu Palayam banks only between September and December." "POINT(77.819725036621 11.02833366394)"
<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. This facility is the fifth downstream hydroelectric plant of six on the Abitibi River. Designed by George F. Hardy Company, the construction of this 349 MW facility began in 1930 and became fully operational in 1936. Hydro One has a 500 kV transmission line along with a 230 kV line that runs south to Sudbury and continues all the way to Toronto to interconnect with the rest of the 500 kV network in Ontario." "POINT(-81.570831298828 49.877777099609)"
<http://dbpedia.org/resource/Ah_Pah_Dam> "Ah Pah Dam" "United States" "Concrete thick arch" "1.0668"^^<http://www.w3.org/2001/XMLSchema#double> "" <http://dbpedia.org/resource/Ah_Pah_Dam__1> "http://dbpedia.org/resource/U.S._Bureau_of_Reclamation" "" "http://dbpedia.org/resource/Klamath_River" "Unbuilt" "" "" "Ah Pah Dam was a proposed dam on the Klamath River in the U.S. state of California proposed by the United States Bureau of Reclamation as part of its United Western Investigation study in 1951. It was to have been 813 feet (248 m) high and was to be located 12 miles (19 km) upstream of the river's mouth. It would stand almost as tall as the Transamerica Pyramid building in San Francisco, but would be much more massive. It would flood 40 miles (64 km) of the Trinity River, including the Yurok, Karuk and Hupa Indian Reservations, the lower Salmon River, and 70 miles (110 km) of the Klamath River, creating a reservoir with a volume of 15,000,000 acre feet (19 km3) - two-thirds of the size of Lake Mead, and becoming the largest reservoir in California. The water would flow by gravity through a" "POINT(-123.93590545654 41.422039031982)"
<http://dbpedia.org/resource/Ain_Zada_Dam> "Barrage d'A\u00efn Zada" "Algeria" "Embankment" "0.7"^^<http://www.w3.org/2001/XMLSchema#double> "" <http://dbpedia.org/resource/Ain_Zada_Dam__1> "" "" "" "O" "2.607e+06"^^<http://www.w3.org/2001/XMLSchema#double> "Algeria" "The Ain Zada Dam is an embankment dam located 10 km (6 mi) east of Khelil on the Bou-Sellam River in Bordj Bou Arr\u00e9ridj Province, Algeria. Constructed between 1982 and 1986, the primary purpose of the dam is supplying drinking and irrigation water to S\u00e9tif, located 24 km (15 mi) to the west." "POINT(5.1494445800781 36.174446105957)"
<http://dbpedia.org/resource/Ain_Zada_Dam> "\u0633\u062f \u0639\u064a\u0646 \u0632\u0627\u062f\u0629" "Algeria" "Embankment" "0.7"^^<http://www.w3.org/2001/XMLSchema#double> "" <http://dbpedia.org/resource/Ain_Zada_Dam__1> "" "" "" "O" "2.607e+06"^^<http://www.w3.org/2001/XMLSchema#double> "Algeria" "The Ain Zada Dam is an embankment dam located 10 km (6 mi) east of Khelil on the Bou-Sellam River in Bordj Bou Arr\u00e9ridj Province, Algeria. Constructed between 1982 and 1986, the primary purpose of the dam is supplying drinking and irrigation water to S\u00e9tif, located 24 km (15 mi) to the west." "POINT(5.1494445800781 36.174446105957)"
<http://dbpedia.org/resource/Ain_Zada_Dam> "Ain Zada Dam" "Algeria" "Embankment" "0.7"^^<http://www.w3.org/2001/XMLSchema#double> "" <http://dbpedia.org/resource/Ain_Zada_Dam__1> "" "" "" "O" "2.607e+06"^^<http://www.w3.org/2001/XMLSchema#double> "Algeria" "The Ain Zada Dam is an embankment dam located 10 km (6 mi) east of Khelil on the Bou-Sellam River in Bordj Bou Arr\u00e9ridj Province, Algeria. Constructed between 1982 and 1986, the primary purpose of the dam is supplying drinking and irrigation water to S\u00e9tif, located 24 km (15 mi) to the west." "POINT(5.1494445800781 36.174446105957)"
<http://dbpedia.org/resource/Aksu_Dam> "Aksu Dam" "Turkey" "Embankment, rock-fill" "0.364"^^<http://www.w3.org/2001/XMLSchema#double> "1047.0"^^<http://www.w3.org/2001/XMLSchema#double> <http://dbpedia.org/resource/Aksu_Dam__1> "http://dbpedia.org/resource/State_Hydraulic_Works" "Power" "http://dbpedia.org/resource/\u00c7oruh_River" "Preliminary construction" "1.918e+06"^^<http://www.w3.org/2001/XMLSchema#double> "Turkey" "The Aksu Dam is an embankment dam in the preliminary stages of construction near the town of Aksu on the \u00c7oruh River in Erzurum Province, Turkey. The dam is part of the \u00c7oruh Development Plan and its construction will be supervised by Turkey's State Hydraulic Works. Construction on access roads and diversion tunnels began in 2010." "POINT(41.156856536865 40.601528167725)"
<http://dbpedia.org/resource/Al_Massira_Dam> "\u0633\u062f \u0627\u0644\u0645\u0633\u064a\u0631\u0629" "Morocco" "Gravity" "0.39"^^<http://www.w3.org/2001/XMLSchema#double> "" <http://dbpedia.org/resource/Al_Massira_Dam__1> "" "" "http://dbpedia.org/resource/Oum_Er-Rbia_River" "O" "354000.0"^^<http://www.w3.org/2001/XMLSchema#double> "Morocco" "The Al Massira Dam is a gravity dam located 70 kilometres (43 mi) south of Settat on the Oum Er-Rbia River in Settat Province, Morocco. Completed in 1979, the dam provides water for the irrigation of over 100,000 hectares (250,000 acres) of farmland in the Doukkala region. The dam's hydroelectric power plant also generates 221 gigawatt-hours (800 TJ) on average annually. The power station was commissioned in 1980. Just to the north of the dam is a rip rap saddle dam to support water elevation in the reservoir. The dam's reservoir and wetlands were designated as a Ramsar site in 2005." "POINT(-7.6374998092651 32.475276947021)"
<http://dbpedia.org/resource/Al_Massira_Dam> "Barrage Al Massira" "Morocco" "Gravity" "0.39"^^<http://www.w3.org/2001/XMLSchema#double> "" <http://dbpedia.org/resource/Al_Massira_Dam__1> "" "" "http://dbpedia.org/resource/Oum_Er-Rbia_River" "O" "354000.0"^^<http://www.w3.org/2001/XMLSchema#double> "Morocco" "The Al Massira Dam is a gravity dam located 70 kilometres (43 mi) south of Settat on the Oum Er-Rbia River in Settat Province, Morocco. Completed in 1979, the dam provides water for the irrigation of over 100,000 hectares (250,000 acres) of farmland in the Doukkala region. The dam's hydroelectric power plant also generates 221 gigawatt-hours (800 TJ) on average annually. The power station was commissioned in 1980. Just to the north of the dam is a rip rap saddle dam to support water elevation in the reservoir. The dam's reservoir and wetlands were designated as a Ramsar site in 2005." "POINT(-7.6374998092651 32.475276947021)"
<http://dbpedia.org/resource/Al_Massira_Dam> "Al Massira Dam" "Morocco" "Gravity" "0.39"^^<http://www.w3.org/2001/XMLSchema#double> "" <http://dbpedia.org/resource/Al_Massira_Dam__1> "" "" "http://dbpedia.org/resource/Oum_Er-Rbia_River" "O" "354000.0"^^<http://www.w3.org/2001/XMLSchema#double> "Morocco" "The Al Massira Dam is a gravity dam located 70 kilometres (43 mi) south of Settat on the Oum Er-Rbia River in Settat Province, Morocco. Completed in 1979, the dam provides water for the irrigation of over 100,000 hectares (250,000 acres) of farmland in the Doukkala region. The dam's hydroelectric power plant also generates 221 gigawatt-hours (800 TJ) on average annually. The power station was commissioned in 1980. Just to the north of the dam is a rip rap saddle dam to support water elevation in the reservoir. The dam's reservoir and wetlands were designated as a Ramsar site in 2005." "POINT(-7.6374998092651 32.475276947021)"

Received 676 rows in 0.225 seconds.


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

For system integrators

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



http://dbpedia.org/sparql

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


Temporal coverage

Document Actions
Filed under: