Difference between revisions of "Querying Coral Records"

From Linked Earth Wiki
Jump to: navigation, search
(→‎Example: Get a list of datasets with archive coral and observation d18O)
(Fix queries)
 
(7 intermediate revisions by one other user not shown)
Line 3: Line 3:
 
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.
 
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 datasets with archive coral (limit to 10) ===
+
===Example: Get a list of datasets with archive coral (limit to 10) ===
  
 
<pre>
 
<pre>
−
{{ #ask: [[Category:Dataset_©]] [[archiveType::coral]]
+
{{ #ask:  
 +
[[Category:Dataset_(L)]]  
 +
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 
  | mainlabel=Datasets
 
  | mainlabel=Datasets
 
  | format=broadtable
 
  | format=broadtable
Line 12: Line 14:
 
}}
 
}}
 
</pre>
 
</pre>
−
{{ #ask: [[Category:Dataset_©]] [[archiveType::coral]]
+
{{ #ask:  
 +
[[Category:Dataset_(L)]]  
 +
[[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 
  | mainlabel=Datasets
 
  | mainlabel=Datasets
 
  | format=broadtable
 
  | format=broadtable
Line 21: Line 25:
  
 
<pre>
 
<pre>
−
{{ #ask: [[Category:Dataset_©]] [[archiveType::coral]] [[IncludesPaleoData_©.IncludesVariable_©.Name_©::D18O]]
+
{{ #ask:  
−
  | ?IncludesPaleoData_©=PaleoData
+
[[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
 
  | format=broadtable
 
  | limit=10
 
  | limit=10
 
}}
 
}}
 
</pre>
 
</pre>
−
{{ #ask: [[Category:Dataset_©]] [[archiveType::coral]] [[IncludesPaleoData_©.IncludesVariable_©.Name_©::D18O]]
+
{{ #ask:  
−
  | ?IncludesPaleoData_©=PaleoData
+
[[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
 
  | format=broadtable
 
  | limit=10
 
  | limit=10
Line 36: Line 46:
  
 
<pre>
 
<pre>
−
{{#ask: [[Category:Location_©]] [[CoordinatesFor.archiveType::Coral]] [[Ocean::Atlantic]
+
{{#ask:  
 +
[[Category:Location_(L)]]  
 +
[[CoordinatesFor.IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 +
[[Ocean::Atlantic]]
 
  | ?Coordinates
 
  | ?Coordinates
 
  | ?CoordinatesFor
 
  | ?CoordinatesFor
−
  | ?Name_©
+
  | ?Name_(L)
 
  | showtitle=off
 
  | showtitle=off
 
  | maxzoom=14
 
  | maxzoom=14
Line 50: Line 63:
  
  
−
{{#ask: [[Category:Location_©]] [[CoordinatesFor.archiveType::Coral]] [[Ocean::Atlantic]]
+
{{#ask:  
 +
[[Category:Location_(L)]]  
 +
[[CoordinatesFor.IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]]
 +
[[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
}}
Datasets
CO00COKY-SAMPLEDATA
Ocn-AbrahamReef.Druffel.1999
Ocn-AmedeeIsland.DeLong.2012
Ocn-AqabaJordanAQ18.Heiss.1999
Ocn-AqabaJordanAQ19.Heiss.1999
Ocn-Bermuda.DraschbaA.2000
Ocn-Bermuda.DraschbaB.2000
Ocn-BermudaSouthShore.Goodkin.2008
Ocn-BiscayneBay.Swart.1996
Ocn-BunakenIsland.Charles.2003
... further results

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
}}
 PaleoData
CO00COKY-SAMPLEDATACO00COKY-SAMPLEDATA.PaleoData1
Ocn-AbrahamReef.Druffel.1999Ocn-AbrahamReef.Druffel.1999.PaleoData1
Ocn-AqabaJordanAQ18.Heiss.1999Ocn-AqabaJordanAQ18.Heiss.1999.PaleoData1
Ocn-AqabaJordanAQ19.Heiss.1999Ocn-AqabaJordanAQ19.Heiss.1999.PaleoData1
Ocn-Bermuda.DraschbaA.2000Ocn-Bermuda.DraschbaA.2000.PaleoData1
Ocn-Bermuda.DraschbaB.2000Ocn-Bermuda.DraschbaB.2000.PaleoData1
Ocn-BermudaSouthShore.Goodkin.2008Ocn-BermudaSouthShore.Goodkin.2008.PaleoData1
Ocn-BermudaSouthShore.Goodkin.2008.PaleoData2
Ocn-BiscayneBay.Swart.1996Ocn-BiscayneBay.Swart.1996.PaleoData1
Ocn-BunakenIsland.Charles.2003Ocn-BunakenIsland.Charles.2003.PaleoData1
Ocn-Clipperton1b.Wu.2014Ocn-Clipperton1b.Wu.2014.PaleoData1
... further results

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
}}


Loading map...
Retrieved from "https://wiki.linked.earth/wiki/index.php?title=Querying_Coral_Records&oldid=78826"