Demo: U.S. Residential Energy Consumption by Appliance Type, 2005

From Data-gov Wiki

Jump to: navigation, search

Infobox (stable demo) edit with form
  • name: Demo: U.S. Residential Energy Consumption by Appliance Type, 2005

  • description: Bar graph of electric energy consumption by appliance, USA 2005
  • creator(s): Sarah Magidson
  • created: July 31,2009
  • modified: 2010-5-18

live demo here

Facts about this Demonstration

Live Demo(s)
Video Demo(s)
Data.gov Data source(s)
Other Data source(s)
Technology Used
Related SPARQL
Related Demo(s)


Interesting Observations

This demo queries Dataset 59 to get the amount of energy Americans used with various electric appliances, such as freezers, water heaters, and air conditioners. We compute the weighted-sum of energy (KWh -kilowatt-hours as opposed to BTU which was used in the original dataset) consumed by families for each type of use. Following are some interesting observations:

  • It is not clear what "appliances" means in the original dataset, but it is not a sum of the other values. So we assume it refers to "other appliances".
  • The runner-up is "Air Conditioner", indicating that the U.S. uses air conditioning heavily.

Technical Highlights

This demo depends on a TDB triple store to avoid repeatedly reloading the dataset from the Web.

This demo has been evolved to illustrate different approaches to integrate and display the same information from Dataset 59.

This demo used several non-standard SPARQL features which may be included in SPARQL 2.0.

  • We used aggregation function (e.g. "sum", math, "as") to compute the weighted sum. The SPARQL query is:
PREFIX dgp10: <http://data-gov.tw.rpi.edu/vocab/p/10/>

SELECT (sum (?nw * ?dryer  /3472) as ?Dryer          )
       (sum (?nw * ?dish   /3472) as ?Dish_Washer    )
       (sum (?nw * ?frz    /3472) as ?Freezer        )
       (sum (?nw * ?rfg    /3472) as ?Refrigerator   )
       (sum (?nw * ?ac     /3472) as ?Air_Conditioner)
       (sum (?nw * ?waterh /3472) as ?Water_Heater   )
       (sum (?nw * ?spaceh /3472) as ?Space_Heater   )
       (sum (?nw * ?appl   /3472) as ?Other_Appliance)
WHERE {
  GRAPH <http://data-gov.tw.rpi.edu/vocab/Dataset_59> {
        ?entry dgp10:btuelcdr ?dryer.
        ?entry dgp10:btueldwh ?dish.
        ?entry dgp10:btuelfzz ?frz.
        ?entry dgp10:btuelrfg ?rfg.
        ?entry dgp10:btuelcol ?ac.
        ?entry dgp10:btuelwth ?waterh.
        ?entry dgp10:btuelsph ?<script src='http://www.google-analytics.com/ga.js' type='text/javascript'></script>spaceh.
        ?entry dgp10:btuelapl ?appl. 
        ?entry dgp10:nweight  ?nw.
  }
}

{{#rdfa_map:Data_property_map}}

Facts about Demo: U.S. Residential Energy Consumption by Appliance Type, 2005RDF feed
Data sourceDataset 59  +
Dcterms:created31 July 2009  +
Dcterms:creatorSarah Magidson  +
Dcterms:descriptionBar graph of electric energy consumption by appliance, USA 2005
Dcterms:modified2010-5-18
Foaf:depictionhttps://data-gov.tw.rpi.edu/w/images/d/d7/Ec2.png  +
Foaf:homepagehttp://data-gov.tw.rpi.edu/demo/static/demo-59-ec2.html  +
Foaf:nameDemo: U.S. Residential Energy Consumption by Appliance Type, 2005
ImageEc2.png  +
Skos:altLabelDemo: U.S. Residential Energy Consumption by Appliance Type, 2005  +, demo: u.s. residential energy consumption by appliance type, 2005  +, and DEMO: U.S. RESIDENTIAL ENERGY CONSUMPTION BY APPLIANCE TYPE, 2005  +
Sparqlhttp://data-gov.tw.rpi.edu/sparql/demo-59-ec2.sparql  +
Technology usedRDF  +, SPARQL  +, SparqlProxy  +, Google Visualization API  +, and TDB Triple Store  +
Personal tools
internal pages