Wikidata:WikiProject Civil Defense/List of firefighting organizations

Context

• Wikidata
  • fire department (Q6498663)   : organization with the job to help the public in emergency situations like fire
  • firefighting (Q897825)   : actions to protect people, animals, goods, lands, and other objects from fire
• OpenStreetMap
  • Tag:amenity=fire_station
• See also
  • https://en.wikipedia.org/wiki/List_of_fire_departments

Query

Wikidata

Global query

The following query uses these:

• Items: fire department (Q6498663)   

• Properties: subclass of (P279)   , country (P17)   , applies to jurisdiction (P1001)   , operating area (P2541)   , official website (P856)   , instance of (P31)   

  # instance_of=fire department (Q6498663)
  SELECT DISTINCT ?item ?itemLabel ?countryLabel ?jurisdictionLabel ?operating_areaLabel ?official_website WHERE {
    VALUES ?instances_of {
      wd:Q6498663
    }
    ?item (p:P31/ps:P31/(wdt:P279*)) ?instances_of.
    OPTIONAL { ?item wdt:P17 ?country. }
    OPTIONAL { ?item wdt:P1001 ?jurisdiction. }
    OPTIONAL { ?item wdt:P2541 ?operating_area. }
    OPTIONAL { ?item wdt:P856 ?official_website. }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr,ru,es,ja,zh,ar". }
  }
  ORDER BY (?countryLabel) (?jurisdictionLabel) (?operating_areaLabel)
  LIMIT 5000
  

Try it!

Country-level query example

The following query uses these:

• Items: fire department (Q6498663)   , Brazil (Q155)   

• Properties: subclass of (P279)   , country (P17)   , applies to jurisdiction (P1001)   , operating area (P2541)   , official website (P856)   , instance of (P31)   

  # instance_of=fire department (Q6498663); Brazil (Q155)
  SELECT DISTINCT ?item ?itemLabel ?countryLabel ?jurisdictionLabel ?operating_areaLabel ?official_website WHERE {
    VALUES ?instances_of {
      wd:Q6498663
    }
    ?item (p:P31/ps:P31/(wdt:P279*)) ?instances_of;
      wdt:P17 ?country;
      p:P17 ?statement1.
    ?statement1 ps:P17 wd:Q155.  # Q155 = Brazil; Change here to select another country
    OPTIONAL { ?item wdt:P1001 ?jurisdiction. }
    OPTIONAL { ?item wdt:P2541 ?operating_area. }
    OPTIONAL { ?item wdt:P856 ?official_website. }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr,ru,es,ja,zh,ar". }
  }
  ORDER BY (?countryLabel) (?jurisdictionLabel) (?operating_areaLabel)
  LIMIT 5000
  

Try it!

Maintenance queries

Without country

The following query uses these:

• Items: fire department (Q6498663)   

• Properties: subclass of (P279)   , country (P17)   , applies to jurisdiction (P1001)   , operating area (P2541)   , official website (P856)   , instance of (P31)   

  # instance_of=fire department (Q6498663) ; FILTER NOT P17
  SELECT DISTINCT ?item ?itemLabel ?countryLabel ?jurisdictionLabel ?operating_areaLabel ?official_website WHERE {
    VALUES ?instances_of {
      wd:Q6498663
    }
    ?item (p:P31/ps:P31/(wdt:P279*)) ?instances_of.
    FILTER(NOT EXISTS { ?item wdt:P17 ?val. })  # only without country
    OPTIONAL { ?item wdt:P17 ?country. }
    OPTIONAL { ?item wdt:P1001 ?jurisdiction. }
    OPTIONAL { ?item wdt:P2541 ?operating_area. }
    OPTIONAL { ?item wdt:P856 ?official_website. }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,de,fr,ru,es,ja,zh,ar". }
  }
  ORDER BY (?countryLabel) (?jurisdictionLabel) (?operating_areaLabel)
  LIMIT 5000
  

Try it!

OpenStreetMap

• overpass-turbo Tag:amenity=fire_station

List

Removed global level Listeria table (not able to render anymore with more detailed items)

Examples of queries by country

• WikiProject Civil Defense/List of firefighting organizations/Brazil