Daniel-Mietchen / ideas

A dumping ground for halfbaked ideas, some of which will hopefully be worked on soon
Other
26 stars 6 forks source link

Look into fire databases #1245

Open Daniel-Mietchen opened 5 years ago

Daniel-Mietchen commented 5 years ago

I wanted to enrich the Wikidata item for the currently ongoing Kincase Fire a bit and thus ventured into the world of databases about fires.

Turns out that there

None of them seems to be exposing persistent identifiers for fires, though the one for the Kincade Fire could be used as a URI.

There is also the European Forest Fire Information System (EFFIS), which does expose PIDs, but if I see this correctly, only for fires that have news items associated with them, e.g.

Daniel-Mietchen commented 5 years ago

Here is a query for the Wikidata data model used for wildfires:

SELECT DISTINCT ?property ?propertyLabel ?count
WITH {
  SELECT DISTINCT ?property (COUNT(*) AS ?count) WHERE {
    ?item wdt:P31/wdt:P279* wd:Q169950 ;
    ?p [ ] .
    ?property a wikibase:Property;
                wikibase:claim ?p.
  }
  GROUP BY ?property 
  } AS %results WHERE {
  INCLUDE %results.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?count)
LIMIT 100