1 / 16

Mashing Up Linked Open Government Data

Mashing Up Linked Open Government Data. Li Ding Tetherless World Constellation Rensselaer Polytechnic Institute Nov 8, 2010. LOGD Consumption Workflow. LOGD Application UI. Query Data. Integrate Data. Visualize Data. JSON. XML. CSV. SPARQL Query. Format Data. SPARQL Results.

dafydd
Download Presentation

Mashing Up Linked Open Government Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mashing Up Linked Open Government Data Li Ding Tetherless World Constellation Rensselaer Polytechnic Institute Nov 8, 2010

  2. LOGD Consumption Workflow LOGD Application UI Query Data Integrate Data Visualize Data JSON XML CSV SPARQL Query Format Data SPARQL Results dbpedia data.gov.uk TWC LOGD W W W

  3. Query Data: SPARQL-based Data Mashup SELECT ?x ?y WHERE { graph <RDF Dataset 1> { ?x <p1> ?obj } graph <RDF Dataset 2> { ?y <p2> ?obj } } query SPARQL Endpoint RDF Dataset 2 RDF Dataset 1 <record_y> <p2> obj <record_x> <p1> obj same value load load LOGD data dump file 1 LOGD data dump file 2

  4. Format Data JSON (Google Viz) google.visualization.Query.setResponse({version:0.6,status:'ok',reqId:0,table:{cols:[{id:'g',label:'g',type:'string'},{id:'number_of_triples',label:'number_of_triples',type:'number'}],rows:[ {c:[{v:'http://data-gov.tw.rpi.edu/vocab/Dataset_353'},{v:23721}]}, {c:[{v:'http://data-gov.tw.rpi.edu/vocab/Dataset_1623'},{v:446}]}, {c:[{v:'http://data-gov.tw.rpi.edu/vocab/Dataset_1580'},{v:778}]}, …. <sparql xmlns="http://www.w3.org/2005/sparql-results#" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.w3.org/2001/sw/DataAccess/rf1/result2.xsd"> <head> <variable name="g"/> <variable name="number_of_triples"/> </head> <results distinct="false" ordered="true"> <result> <binding name="g"><uri>http://data-gov.tw.rpi.edu/vocab/Dataset_353</uri></binding> <binding name="number_of_triples"><literal>23721</literal></binding> </result> ….. HTML Table SPARQL/XML

  5. Integrate & Visualize Data • Dynamic content generated by SPARQL query • Aggregate data from multiple sources • Visualize data using different technologies XSLT Javascript Google AJAX API Yahoo Pipes PHP + Java

  6. Aspects Data Mashup Visualization Mashup Application Mashup Subject Temporal Mashup Spatial Mashup Entity Mashup … Other topics Semantic Search Social mashup Provenance Types of Mashups

  7. US and UK Foreign AID FY2007:Integrating data from two countries Data Sources: [Spatial Mashup] Data.gov (USAID) + Data.gov.uk (DFID) Created by James Michaelis, RPI, http://data-gov.tw.rpi.edu/demo/linked/aidviz-1554-10030.html

  8. Gov Data for Pop Science:Integrating different sources for discovery Gov data provides knowledge for poplation science study [Spatial Mashup] Data.gov (Population) + NIH (Tobacco Tax, Smoking rate) Created by Sarah Magidson, U. Chicago.http://data-gov.tw.rpi.edu/demo/stable/tobacco-smoker/demo-state-10026-smoke-rate-statevarsapi.html

  9. Consume LOGD data in Semantic Search Data-gov Semantic Search Web Search Results http://data-gov.tw.rpi.edu/ HTML XHTML+RDFa RDFa RDF Annotation ARC2

  10. Adding Social Factor to Mashups • Import socially contributed data, e.g. DBpedia • Let users contribute • links • feedbacks Other Social Web Apps Enhance* Import/export RDF Raw Data Publish* consume* User feedback

  11. Social Mashup - US Wildland Fire:Linking to Wikipedia (socially contributed) Category:Wildfires In The United States Budget on wildfire “DOI” and “USDA”(OMB) Wildland fire (NIFC) [Temporal Mashup] Data.gov (statistics+ budget) + Wikipedia (famous fires) Created by Li Ding, RPI, http://data-gov.tw.rpi.edu/demo/stable/demo-1187-40x-wildfire-budget.html

  12. Social Mashup - White House Visitor Search:Linking social network data using semantic wiki NYTimes Wikipedia dbpedia:Barack_Obama Semantic Wiki “POTUS” The White House [Person Mashup] Data.gov (statistics) + Wikipedia (personal profiles) Created by Dominic DiFranzo, Evan Patton, RPI, http://data-gov.tw.rpi.edu/demo/stable/white-house-visitor/top100-visitees.php

  13. Social Mashup: USPS Spending and Newsgovernment data + User Feedbacks [Temporal Mashup] Data.gov (budget) + USPS + User Contributed News Created by Sarah Magidson, http://data-gov.tw.rpi.edu/demo/linked/demo-401-usps-news.html

  14. Using Web Tools Information networks can be integrated via the Semantic Wiki and visualized a number of different ways: social networks, human-language technology, workflows, …

  15. More Mashups (c) Agency Budget and NYTimes (a) white house visitor search (b) US-UK Foreign Aid Comparison (d) Wildland fire and DBpedia (d) Wildland fire and DBpedia (g) [Financial] Stock price and Twitter events (e) [Health] Tobacco Prevalence and Correlated Factors (f) [Policy] About Supreme Court Justices (j) [RDFa] semantic search (k) [RSS] data.gov updates (h) [Yahoo! Pipes] World Earthquake Map (i) [IBM ManyEyes] white house visitor network

  16. Resources • Online Tutorials • Mashing up LOGD data with SPARQL • Retrieving SPARQL Results • Building LOGD Visualizations • Standards and Tools • SPARQL Endpoint • SparqlProxy • Visualization APIs • Google Visualization API • MIT SIMILE Exhibit • Language (name it): Javascript, PHP, Python,…

More Related