40 likes | 162 Views
This resource elaborates on the application of PivotViewer for presenting structured data related to scientific ocean drilling and associated taxonomy. Utilizing Virtuoso's RDF triple store, users can access and visualize key drilling disturbance data through SPARQL queries formatted in CXML. The document outlines fundamental queries for retrieving distinct features of various taxa, which include genus, species, and various morphological characteristics. Additionally, it provides insights into effective data representation methods for both small and large datasets.
E N D
PivotViewer for Scientific Ocean Drilling Data Taxonomy and drilling disturbance data in Pivotviewer.
Structured data presentation • Virtuoso (RDF triple store) (example) • http://data.oceandrilling.org:8890/PivotViewer • SPARQL to CXML (Pivotviewer as a method to display query results) PREFIX gmd: <http://www.isotc211.org/2005/gmd> PREFIX oai_voc: <http://www.mediaspaces.info/vocab/oai-pmh.rdf#> PREFIX taxon: <http://www.chronos.org/taxa/#> SELECT DISTINCT ?uri ?author ?genus ?species ?fad_stage ?lad_stage ?fad_ma ?lad_ma ?chamber_arrangement ?test_outline ?coiling_axis ?edge_view ?umbilical_or_test_sutures ?shell_porosity ?wall_texture ?aperture ?aperture_border ?accessory_apertures ?periphery ?image WHERE { ?uri taxon:author ?author . ?uri taxon:current_genus ?genus . ?uri taxon:species ?species . ?uri taxon:fad_stage ?fad_stage . ?uri taxon:lad_stage ?lad_stage . ?uri taxon:fad_ma ?fad_ma . ?uri taxon:lad_ma ?lad_ma . ?uri taxon:chamber_arrangement ?chamber_arrangement . ?uri taxon:test_outline ?test_outline . ?uri taxon:coiling_axis ?coiling_axis . ?uri taxon:edge_view ?edge_view . ?uri taxon:umbilical_or_test_sutures ?umbilical_or_test_sutures . ?uri taxon:shell_porosity ?shell_porosity . ?uri taxon:wall_texture ?wall_texture . ?uri taxon:aperture ?aperture . ?uri taxon:aperture_border ?aperture_border . ?uri taxon:accessory_apertures ?accessory_apertures . ?uri taxon:periphery ?periphery . ?uri taxon:main_image_url ?image . }
Quick points… • Excel creation is an easy route for small data as you likely saw • <editorial> Data Explorer shown this week could serialize to cxml (odata to cxml transform?) </editorial> • Coding… • Cxml is just xml (not overly complex) • The deep zoom image collection can be more problematic (there are tools) • Easy for small sets (1-10k?) should scale to much larger with non-static approaches • Faceted UI’s in general are a useful tool in the toolbox • SL 5 changes
Douglas Fils Data Manager Consortium for Ocean Leadership United States Implementing Organization Integrated Ocean Drilling Program dfils@oceanleadership.org Thanks…