Wikidata:WikiProject Civil Defense/List of dams

Special sign for works and installations containing dangerous forces such as dam (Q12323), levee (Q105190) and nuclear power plant (Q134447)

See commons Category:Dams

Query

Generic query

The following query uses these:

• Items: dam (Q12323)   

• Properties: country (P17)   , located in the administrative territorial entity (P131)   , coordinate location (P625)   , instance of (P31)   

  # dam (Q12323) / barrier that impounds water or underground streams
  SELECT DISTINCT ?item ?itemLabel ?countryLabel ?located_in_admLabel ?coordinate_location WHERE {
    VALUES ?instances_of {
      wd:Q12323
    }
    ?item (p:P31/ps:P31) ?instances_of.
    OPTIONAL { ?item wdt:P17 ?country. }
    OPTIONAL { ?item wdt:P131 ?located_in_adm. }
    OPTIONAL { ?item wdt:P625 ?coordinate_location. }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr,ru,es,ja,zh,ar". }
  }
  #ORDER BY (?countryLabel) (?located_in_adm) (?coordinate_location)
  LIMIT 100
  

Try it!

List

Note: over 700.000 items. Not possible a global query.