Demo: Agencies' Dataset Contribution on Data.gov

From Data-gov Wiki

Jump to: navigation, search

NOTE: This demo is replaced by Demo: Raw Government Data Now! Agencies' Contributions at Data.gov.

Infobox (legacy demo) edit with form
  • name: Demo: Agencies' Dataset Contribution on Data.gov

  • description: This demo shows the number of Data.gov datasets contributed by each government agency
  • creator(s): Sarah Magidson,Li Ding
  • created: July 31,2009
  • modified: 2010-5-19

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 the data.gov catalog to list all the agencies that submitted data to data.gov, then counts the number of datasets each submitted. From the visualization, web users are presented with the following observations:

This demo queries the latest RDF file (instead of the static triple store) to generate the pie chart. The result is a pie chart of agencies according to how many datasets they have submitted to data.gov.

Technical Highlights

This demo is a showcase for Tech: RDF-Google Visualization, where SPARQL query results are displayed using various Google Visulization APIs including pie chart, bar chart, column chart, line chart and table.


This demo is a showcase for SPARQL technology

  • The use of "FROM" clause in SPARQL query. This demo uses an online file as the dataset of SPARQL query, which is independent of the triple store.
  • It uses extended SPARQL query (count) to achieve counting task.
  • You can use a general purposed SPARQL web service that handles such query, e.g. http://onto.rpi.edu/joseki/sparql.html
PREFIX dgp92:  <http://data-gov.tw.rpi.edu/vocab/p/92/>
SELECT  ?ag  (count(*) AS ?cnt)
FROM <http://data-gov.tw.rpi.edu/raw/92/data-92.rdf>
WHERE { 
  ?entry dgp92:agency ?ag. 
}
GROUP BY ?ag
ORDER BY DESC (?cnt)


This demo is a showcase for an experimental configurable script for displaying a data table (one column for key, one column for value)

{
  "title"       : "US Government Agencies' Dataset Contribution",
  "description" : "This demo was created by ... <a href='http://data-gov.tw.rpi.edu/wiki/Dataset_92'>Dataset 92</a> - Data.gov Catalog</li></ul>",
  "url_query"   : "http://data-gov.tw.rpi.edu/sparql/select_count_agency_from.sparql",
  "url_demo"    : "http://data-gov.tw.rpi.edu/demo/static/demo-92-agency.php",
  "url_wiki"    : "http://data-gov.tw.rpi.edu/wiki/Demo:_Agencies%27_Dataset_Contribution_on_Data.gov",
  "tab_style"   : "height:550px", 
  "show_header" : "true",
  "packages"    : [
     {"package": "Table",       "style":"height:520px", "params":"{height:500, 'allowHtml': true}"},
     {"package": "BarChart",    "style":"height:520px", "params":"{height:500}"},
     {"package": "ColumnChart", "style":"height:520px", "params":"{height:500}"},
     {"package": "LineChart",   "style":"height:520px", "params":"{height:500, logScale:true}"},
     {"package": "PieChart",    "style":"height:520px", "params":"{height:500, pieMinimalAngle: 1, is3D: true}"} 
  ]
}

{{#rdfa_map:data_property_map}}

Personal tools
internal pages