Difference between revisions of "Querying Coral Records"

From Linked Earth Wiki
Jump to: navigation, search
(Example: Get a list of datasets datasets with archive coral (limit to 10))
(Fix queries)
 
Line 7: Line 7:
 
<pre>
 
<pre>
 
{{ #ask:  
 
{{ #ask:  
[[Category:Dataset_©]]  
+
[[Category:Dataset_(L)]]  
[[IncludesPaleoData_©.FoundInMeasurementTable_©.IncludesVariable_©.MeasuredOn_©::<q>[[Category:Coral]]</q>]]
+
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 
  | mainlabel=Datasets
 
  | mainlabel=Datasets
 
  | format=broadtable
 
  | format=broadtable
Line 15: Line 15:
 
</pre>
 
</pre>
 
{{ #ask:  
 
{{ #ask:  
[[Category:Dataset_©]]  
+
[[Category:Dataset_(L)]]  
[[IncludesPaleoData_©.FoundInMeasurementTable_©.IncludesVariable_©.MeasuredOn_©::<q>[[Category:Coral]]</q>]]
+
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 
  | mainlabel=Datasets
 
  | mainlabel=Datasets
 
  | format=broadtable
 
  | format=broadtable
Line 26: Line 26:
 
<pre>
 
<pre>
 
{{ #ask:  
 
{{ #ask:  
[[Category:Dataset_©]]  
+
[[Category:Dataset_(L)]]  
[[IncludesPaleoData_©.FoundInMeasurementTable_©.IncludesVariable_©.MeasuredOn_©::<q>[[Category:Coral]]</q>]]
+
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
[[IncludesPaleoData_©.FoundInMeasurementTable_©.IncludesVariable_©.OnProxyObservationProperty_©::D18O]]
+
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).ProxyObservationType_(L)::D18O]]
  | ?IncludesPaleoData_©=PaleoData
+
  | ?IncludesPaleoData_(L)=PaleoData
 
  | format=broadtable
 
  | format=broadtable
 
  | limit=10
 
  | limit=10
Line 35: Line 35:
 
</pre>
 
</pre>
 
{{ #ask:  
 
{{ #ask:  
[[Category:Dataset_©]]  
+
[[Category:Dataset_(L)]]  
[[IncludesPaleoData_©.FoundInMeasurementTable_©.IncludesVariable_©.MeasuredOn_©::<q>[[Category:Coral]]</q>]]
+
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
[[IncludesPaleoData_©.FoundInMeasurementTable_©.IncludesVariable_©.OnProxyObservationProperty_©::D18O]]
+
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).ProxyObservationType_(L)::D18O]]
  | ?IncludesPaleoData_©=PaleoData
+
  | ?IncludesPaleoData_(L)=PaleoData
 
  | format=broadtable
 
  | format=broadtable
 
  | limit=10
 
  | limit=10
Line 47: Line 47:
 
<pre>
 
<pre>
 
{{#ask:  
 
{{#ask:  
[[Category:Location_©]]  
+
[[Category:Location_(L)]]  
[[CoordinatesFor.IncludesPaleoData_©.FoundInMeasurementTable_©.IncludesVariable_©.MeasuredOn_©::<q>[[Category:Coral]]</q>]]
+
[[CoordinatesFor.IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 
[[Ocean::Atlantic]]
 
[[Ocean::Atlantic]]
 
  | ?Coordinates
 
  | ?Coordinates
 
  | ?CoordinatesFor
 
  | ?CoordinatesFor
  | ?Name_©
+
  | ?Name_(L)
 
  | showtitle=off
 
  | showtitle=off
 
  | maxzoom=14
 
  | maxzoom=14
Line 64: Line 64:
  
 
{{#ask:  
 
{{#ask:  
[[Category:Location_©]]  
+
[[Category:Location_(L)]]  
[[CoordinatesFor.IncludesPaleoData_©.FoundInMeasurementTable_©.IncludesVariable_©.MeasuredOn_©::<q>[[Category:Coral]]</q>]]
+
[[CoordinatesFor.IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 
[[Ocean::Atlantic]]
 
[[Ocean::Atlantic]]
 
  | ?Coordinates
 
  | ?Coordinates
 
  | ?CoordinatesFor
 
  | ?CoordinatesFor
  | ?Name_©
+
  | ?Name_(L)
 
  | showtitle=off
 
  | showtitle=off
 
  | maxzoom=14
 
  | maxzoom=14

Latest revision as of 18:48, 24 October 2018

This is an example on how to query the datasets on the wiki using Semantic Media Wiki (SMW) queries. The queries refer to the Special:Categories and Special:Properties defined in the wiki.

Example: Get a list of datasets with archive coral (limit to 10)

{{ #ask: 
[[Category:Dataset_(L)]] 
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 | mainlabel=Datasets
 | format=broadtable
 | limit=10
}}
The query result could not be obtained from the SPARQL database. This error might be temporary or indicate a bug in the database software.

Example: Get a list of datasets with archive coral and observation d18O

{{ #ask: 
[[Category:Dataset_(L)]] 
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).ProxyObservationType_(L)::D18O]]
 | ?IncludesPaleoData_(L)=PaleoData
 | format=broadtable
 | limit=10
}}
The query result could not be obtained from the SPARQL database. This error might be temporary or indicate a bug in the database software.

Example: Search and map the records for the Atlantic

{{#ask: 
[[Category:Location_(L)]] 
[[CoordinatesFor.IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
[[Ocean::Atlantic]]
 | ?Coordinates
 | ?CoordinatesFor
 | ?Name_(L)
 | showtitle=off
 | maxzoom=14
 | minzoom=1
 | limit=500
 | template=LiPDLocation
 | format=leaflet
}}


The query result could not be obtained from the SPARQL database. This error might be temporary or indicate a bug in the database software.