Demo: US Government Agencies' Contributions at Data.gov

From Data-gov Wiki

Jump to: navigation, search

Infobox (stable demo) edit with form
  • name: Demo: US Government Agencies' Contributions at Data.gov

  • description: This demo shows how many raw datasets have been contributed to Data.gov by each US government agency.
  • creator(s): Li Ding,Sarah Magidson
  • created: May 11, 2010
  • modified: 2010-5-18

The prior version of this demo is Demo: Agencies' Dataset Contribution on Data.gov

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:


Technical Highlights

In this demo, SPARQL query results are displayed using various Google Visulization APIs including pie chart, bar chart, line chart and table.


This demo also show the use of aggregation function in SPARQL (we used virtuoso syntax)

# NOTE:
#  this query used SPARQL 1.1 feature, and its SELECT clause is customized to virtuoso syntax
#  we only query raw data catalog
#
PREFIX dgp92:  <http://data-gov.tw.rpi.edu/vocab/p/92/>
SELECT  ?agency , count(*) AS ?cnt
FROM NAMED <http://data-gov.tw.rpi.edu/raw/92/data-92.rdf>
WHERE { 
GRAPH <http://data-gov.tw.rpi.edu/raw/92/data-92.rdf>
{
 ?entry dgp92:agency ?agency. 
 ?entry dgp92:data_gov_data_category_type "Raw Data Catalog" .
}
}
GROUP BY ?agency
ORDER BY DESC (?cnt )
Facts about Demo: US Government Agencies' Contributions at Data.govRDF feed
Data sourceDataset 92  +
Dcterms:created11 May 2010  +
Dcterms:creatorLi Ding  +, and Sarah Magidson  +
Dcterms:descriptionThis demo shows how many raw datasets have been contributed to Data.gov by each US government agency.
Dcterms:modified2010-5-18
Foaf:depictionhttps://data-gov.tw.rpi.edu/w/images/e/e7/Demo-92-agency-rawdata-contribution.png  +
Foaf:nameDemo: US Government Agencies' Contributions at Data.gov
ImageDemo-92-agency-rawdata-contribution.png  +
Live demohttp://data-gov.tw.rpi.edu/demo/stable/demo-92-agency-rawdata-contribution.html  +
Skos:altLabelDemo: US Government Agencies' Contributions at Data.gov  +, demo: us government agencies' contributions at data.gov  +, and DEMO: US GOVERNMENT AGENCIES' CONTRIBUTIONS AT DATA.GOV  +
Sparqlhttp://data-gov.tw.rpi.edu/demo/stable/demo-92-agency-rawdata-contribution.sparql  +
Technology usedRDF  +, SPARQL  +, SparqlProxy  +, Google Visualization Table  +, Google Visualization Bar Chart  +, Google Visualization Line Chart  +, and Google Visualization Pie Chart  +
Personal tools
internal pages