Linking Wildland Fire and Government Budget

US government is spending billions of dollars on fighting with Wildland Fire, and this demos show their correlations.
div style="background:whitesmoke; width:1100px">
Scaling options: budget(USDA/DOI) acres fires
loading ...

Interesting Observations

  • billions of dollars are spent on fighting wildland fire.
  • the big drop of wild fire in 1985 is strange, can we find explanations.
  • While the number of fires are more stable in the past 20 year, the amount of burned land has been growing in the past five years. Meanwhile, the budget is also growing (almost non-linearly in recent years). It would useful to explain which department, Department of the Interior or Department of Agriculture, is taking the primary role in fighing wildland fire and should receive more budget allocation.
more information

Technology Highlights

Find relevant data in Budget Dataset

We use SPARQL to list relevant Budget Accounts
PREFIX rdf: <> 

SELECT ?p  sum(xsd:integer (?o)) ?agency
 # match the specific BGP first, then filter based on account_name. only join with the completely unbound triple pattern after the filter so that the intermediate result size isn't large.
  ?s 	<> ?account_name.
  ?s  <> ?bureau.
  ?s <> ?agency . 
  filter (regex(?account_name,"Wildland Fire"))
 ?s ?p ?o.
group by ?p ?agency

Collect Annotations from Users

We use semantic wiki to help users collaboratively contribute news on Dataset_WildfireNews. The news is then published on-the-fly via Wildfire News RSS Here, the RSS data is not loaded into the triple store, so it will be related every time we reload the live demo. Following is the sample sparql query (with FROM clause):
SELECT ?date ?title ?link

?s <> ?title .
?s <> ?link .
?s <> ?description .
?s <> ?date.

Connect to Dbpedia/Wikipedia

We can query dbpedia for wildland fires in the US using the category yago-class:WildfiresInTheUnitedStates. Note that dbpedia provide sparql endpoint at
SELECT distinct ?subject ?label ?comment ?page ?image ?arces
      ?s a <>.
      ?s <> ?label.
      filter (lang(?label)="en")
     ?s <> ?subject.
 ?s <> ?comment.  
 ?s <> ?page. 

  optional{ ?s <> ?image. }
  optional{ ?s <> ?arces. }

 filter (lang(?comment)="en")

Uses Dataset: 
Uses Dataset: 
Uses Technology: 
Uses Technology: 
Uses Technology: 
Uses Technology: 
No votes yet

Warning: Table './drupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:364:\"Table &#039;./drupal/accesslog&#039; is marked as crashed and last (automatic?) repair failed\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values(&#039;Linking Wildland Fire and Government Budget&#039;, &#039;node/57&#039;, &#039;&#039;, &#039;;, 0, &#039;qcrqeoar6aj0h1i7p1a085b497&#039;, 31, 1618681981)\";s:5:\"%file\";s:58:\"/data/www/html/drupal/modules/statistics/statistics.module\";s:5:\"%line\";i:63;}', 3, '', ' in /data/www/html/drupal/includes/ on line 134