• Open Data
• Operate on MODELS (search, change, use)
• Expose models to third party interfaces and tools
• Google: Docs, Maps, Earth, Earth Engine, Fusion, more
• Microsoft: PivotViewer, PowerPivot, Data Market, Excel
• Other: Wolfram Alpha, Qwiki, etc.

Too much talk already  lets try something..  then see what we did...
						

• USIO data is exposed as a model, not a set of services or API's
• Like a database, this means we can "operate" on the data by means of requests.
• It also means we can "cast" the data into different models rather easly... in the previous example we moved from RDF to KML (the Google Earth Model language)
• RDF?

• USIO data is exposed using the Linked Data pattern (http://www.w3.org/DesignIssues/LinkedData.html)
• RDF is a graph model allowing relations (not just tree like relations by graph like relations)
• We can interact with the graph via a query language (SPARQL in this case)
• Also, URL's (URI's) now have meaning (ID) and representations (with persistence and provenance)

but show me what else it can do...

• We can cast to formats like JSON for MIT's SIMILE http://data.oceandrilling.org/labs/exhibit/taxon.html
• We can cast to CXML for Microsoft PowerPivot Taxon data (this will also be done with the Core Atlas data)

• Linked Data pattern encourages and enables re-use of resources.
• Since the resources expose the model (not just the representation) it's easy for others to alter the data to fit their look and feel.
• Current resources include (ref: http://data.oceandrilling.org/linkeddata.html)
• Planned resources
  • Timescales
  • Core Atlas (Kathie Marsaglia)
  • much more...

• The pattern enables easy transforms to 3rd party hosting and services

• Google Fusion tables
  • (like at http://data.oceandrilling.org/)
  • (Login (account required): http://www.google.com/fusiontables/Home?pli=1)
  • So queries at http://data.oceandrilling.org/sparql can be pulled as CSV and loaded for use
• Google DSPL and Earth Engine

• The pattern enables easy transforms to 3rd party hosting and services
• Data markets and "business intelligence" style approaches
  • http://data.oceandrilling.org/labs/odata.html
  • OData
  • Data Market (Excel, Tableau)

• Other items of potential interest:
  • Deep zoom Deep Zoom at data.
  • Qwiki Qwiki Integrated_Ocean_Drilling_Program
  • Corewall Coredev
  • Concept maps Concept maps at data.
• Explore: data.oceandrilling.org and in particular the "labs" section off the home page
• Questions (see more at YouTube: http://www.youtube.com/user/douglasfils

• Freebase
• Refine
• Tableau (on-line published)
• Azure Datamarket
• Qwiki
• Corewall
• Pyton Pattern
• R
• Linked Data Resources
• Deep Zoom
• CytoGraph(Web)
• Google Resources
  • Google Fusion
  • Google Big Query
  • Google DSPL
  • Google Earth
  • Google EarthEngine
  • Google Refine
• OData
  • PowerPivot
  • PivotViewer
  • Excel
• WolframAlpha

SPARQL end point SPARQL is a topic unto itself! (Visual SPARQL builder: http://data.oceandrilling.org/isparql/)

SELECT ?uri 
WHERE {
   ?uri skos:related <http://data.oceandrilling.org/codices/lsh/171/1049/C> .
}
		

PREFIX chronos: <http://www.chronos.org/loc-schema#>
SELECT ?uri ?long ?lat
WHERE {
     ?uri skos:related <http://data.oceandrilling.org/codices/lsh/171> .
     ?uri geo:long ?long .
     ?uri geo:lat ?lat .
}