Difference between revisions of "Querying Coral Records"
From Linked Earth Wiki
(Create example query page using the coral archive) |
(Fix queries) |
||
(17 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | __TOC__ | ||
+ | |||
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: | + | ===Example: Get a list of datasets with archive coral (limit to 10) === |
<pre> | <pre> | ||
− | {{ #ask: [[Category: | + | {{ #ask: |
− | | | + | [[Category:Dataset_(L)]] |
+ | [[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]] | ||
+ | | mainlabel=Datasets | ||
| format=broadtable | | format=broadtable | ||
− | | limit= | + | | limit=10 |
}} | }} | ||
</pre> | </pre> | ||
− | {{ #ask: [[Category: | + | {{ #ask: |
− | | | + | [[Category:Dataset_(L)]] |
+ | [[IncludesPaleoData_(L).FoundInMeasurementTable_(L).IncludesVariable_(L).MeasuredOn_(L)::<q>[[Category:Coral]]</q>]] | ||
+ | | mainlabel=Datasets | ||
| format=broadtable | | format=broadtable | ||
− | | limit= | + | | limit=10 |
+ | }} | ||
+ | |||
+ | ===Example: Get a list of datasets with archive coral and observation d18O === | ||
+ | |||
+ | <pre> | ||
+ | {{ #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 | ||
+ | }} | ||
+ | </pre> | ||
+ | {{ #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 | ||
+ | }} | ||
+ | |||
+ | ===Example: Search and map the records for the Atlantic=== | ||
+ | |||
+ | <pre> | ||
+ | {{#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 | ||
+ | }} | ||
+ | </pre> | ||
+ | |||
+ | |||
+ | {{#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 | ||
}} | }} |
Latest revision as of 18:48, 24 October 2018
Contents
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.