Wikidata:WikiProject Civil Defense/List of dams/Brazil

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

Query

The following query uses these:

• Items: dam (Q12323)   , Brazil (Q155)   

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

  # barragem (Q12323) ; Brasil (Q155)
  SELECT DISTINCT ?item ?itemLabel ?itemDescription ?located_in_admLabel ?coordinate_location WHERE {
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
    {
      SELECT DISTINCT ?item WHERE {
        {
          ?item p:P31 ?statement0.
          ?statement0 (ps:P31/(wdt:P279*)) wd:Q12323.
          FILTER(EXISTS { ?statement0 prov:wasDerivedFrom ?reference. })
        }
        {
          ?item p:P17 ?statement1.
          ?statement1 (ps:P17/(wdt:P279*)) wd:Q155.
          FILTER(EXISTS { ?statement1 prov:wasDerivedFrom ?reference. })
        }
      }
      # LIMIT 10000
    }
    OPTIONAL { ?item wdt:P131 ?located_in_adm. }
    OPTIONAL { ?item wdt:P625 ?coordinate_location. }
  }
  

Try it!