Facts about Transportation Energy

This demo describes about alternative fuel usage in the United States in 2005, including the number of fuel stations of each state of different types of fuels, in comparison with other state level data released by government agencies, such as population, total stack air emission, etc..
State Level Comparison : [] Choose from below to compare alternative fuel infrastructure in different states, population, air quality and total housing :

Interesting Observation

  • For the state level comparison, by selecting different types of fuels, we could see that different states have their own "preferences" on alternative fuels. For example, Minnesota is the leading state in the number of states for E85, North Carolina leads the BD, while California leads in CNG, ELEC, H2, and LNG. Texas leads in the number of LPG and gasoline stations.


  • We convert the raw data about alternative fuel infrastructure to RDF, and load them into a triple store
  • Some of the US data is at state level, so that we can query along with other state-level data existing in the triple store, including population, household, air condition, etc.
  • The query results are directly consumed by Google visualization APIs, e.g. GeoMap for state-level data comparison.
Uses Technology: 
Uses Technology: 
Uses Technology: 
Your rating: None Average: 3 (1 vote)

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:351:\"Table './drupal/accesslog' is marked as crashed and last (automatic?) repair failed\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Facts about Transportation Energy', 'node/72', '', '', 0, 'tcjf1gnm9dd8l3jpft2rab7pl3', 65, 1594193290)\";s:5:\"%file\";s:58:\"/data/www/html/drupal/modules/statistics/statistics.module\";s:5:\"%line\";i:63;}', 3, '', 'https://logd.tw.rpi.edu/demo/facts_about_transport in /data/www/html/drupal/includes/database.mysqli.inc on line 134