Linking Open Government Data

Interesting Observations

The user chooses one or more government account names from a checklist (see Figure 1), and the application will display a timeline of their earnings from 1962 to the present and projected values through 2014 (see Figure about). The data and the accounts on the checklist come from dataset 403, published by the Office of Management and Budget. Potential uses of this app include (but of course are not limited to) seeing how much revenue a particular tax or program is generating, how effective it has been over time, comparing programs, or seeing how much money certain government-funded foundations have received.

Technology Highlights

• The checklist is created through a combination of HTML forms and PHP.
• When the form is submitted, a SPARQL query is generated using PHP (the outline of which you can see here).
• The data is run through the Tech: RDF-Google Visualization
  • The visualization used is the annotated timeline.
• Some PHP is also used to list what accounts you have chosen.
Uses Dataset: 
data-gov 403
Uses Technology: 
RDF
Uses Technology: 
SPARQL
Uses Technology: 
SparqlProxy
Uses Technology: 
Google Visualization API
Uses Technology: 
PHP
Uses SPARQL Query: 
http://data-gov.tw.rpi.edu/demo/interactive/demo-403-account-sparql.php?acct
Uses SPARQL Endpoint: 
http://data-gov.tw.rpi.edu/sparql
Screen Shot: 
http://data-gov.tw.rpi.edu/w/images/5/59/403tline.png
Thumbnail: 

Average: Select ratingPoorOkayGoodGreatAwesome
Your rating: None Average: 2 (1 vote)