Difference between revisions of "Querying the Datasets"

From Linked Earth Wiki
Jump to: navigation, search
(Example: Get a List of Datasets with archive type "Sclerosponge" and plot them on a map)
Line 1: Line 1:
 
__TOC__
 
__TOC__
 
The data in the wiki can be queried and embedded within the wiki by Semantic Media Wiki (SMW) queries.
 
  
 
=== Semantic Media Wiki Queries ===
 
=== Semantic Media Wiki Queries ===
 +
The data in the wiki can be queried and embedded within the wiki by Semantic Media Wiki (SMW) queries. The queries refer to the [[Special:Categories Categories]] and [[Special:Properties Properties]] defined in the wiki.
  
 
==== Example: Get a List of Datasets (limit to 5) ====
 
==== Example: Get a List of Datasets (limit to 5) ====
Line 59: Line 58:
 
  | format=leaflet
 
  | format=leaflet
 
}}
 
}}
 +
 +
=== SPARQL Queries ===
 +
One can also make more complex queries using SPARQL to the wiki's triple store.  The SPARQL endpoint is http://wiki.linked.earth/store/ds/query, and one can make queries by passing a query parameter with the text of the SPARQL query. The data can be returned in a variety of formats. The SPARQL queries refer to the Linked Earth core ontology terms found at http://linked.earth/ontology.
 +
 +
'''Note: The mapping between terms on the wiki and the ontology can be found at any wiki Property or Category page by looking at the "Imported from" value. For example, the property [[Property:ArchivedIn_©]] imports the term core:archivedIn from the ontology, where "core:" prefix refers to the linked earth ontology at http://linked.earth/ontology'''
 +
 +
====  ====
 +
<pre>
 +
</pre>
 +
 +
 +
 +
=== Querying Linked Earth Data from another Program/Script ===
 +
 +
The endpoint at http://wiki.linked.earth/store/ds/query also allows one to make queries remotely. One can make queries and get the data

Revision as of 14:46, 22 June 2016

Semantic Media Wiki Queries

The data in the wiki can be queried and embedded within the wiki by Semantic Media Wiki (SMW) queries. The queries refer to the Special:Categories Categories and Special:Properties Properties defined in the wiki.

Example: Get a List of Datasets (limit to 5)

{{ #ask: [[Category:Dataset_©]]
 | mainlabel=Datasets
 | format=broadtable
 | limit=5
}}


Example: Get a List of Datasets that have paleo data based on d18O Proxy (limit 5)

{{ #ask: [[Category:Dataset_©]] [[IncludesPaleoData_©.BasedOn_©.Name_©::d18O]]
 | ?IncludesPaleoData_©=PaleoData
 | format=broadtable
 | limit=5
}}


Example: Get a List of Datasets with archive type "Sclerosponge" and plot them on a map

{{#ask: [[Category:Location_©]] [[CoordinatesFor.archiveType::Sclerosponge]]
 | ?Coordinates
 | ?CoordinatesFor
 | ?Name_©
 | showtitle=off
 | maxzoom=14
 | minzoom=1
 | limit=500
 | template=LiPDLocation
 | format=leaflet
}}


SPARQL Queries

One can also make more complex queries using SPARQL to the wiki's triple store. The SPARQL endpoint is http://wiki.linked.earth/store/ds/query, and one can make queries by passing a query parameter with the text of the SPARQL query. The data can be returned in a variety of formats. The SPARQL queries refer to the Linked Earth core ontology terms found at http://linked.earth/ontology.

Note: The mapping between terms on the wiki and the ontology can be found at any wiki Property or Category page by looking at the "Imported from" value. For example, the property Property:ArchivedIn_© imports the term core:archivedIn from the ontology, where "core:" prefix refers to the linked earth ontology at http://linked.earth/ontology



Querying Linked Earth Data from another Program/Script

The endpoint at http://wiki.linked.earth/store/ds/query also allows one to make queries remotely. One can make queries and get the data