Querying Coral Records

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

{"format":"leaflet","minzoom":1,"maxzoom":14,"limit":500,"offset":0,"link":"all","sort":[""],"order":[],"headers":"show","mainlabel":"","intro":"","outro":"","searchlabel":"... further results","default":"","geoservice":"geonames","width":"auto","height":"350px","centre":false,"title":"","label":"","icon":"","visitedicon":"","lines":[],"polygons":[],"circles":[],"rectangles":[],"wmsoverlay":false,"copycoords":false,"static":false,"zoom":false,"defzoom":14,"layer":"OpenStreetMap","overlaylayers":[],"resizable":false,"enablefullscreen":false,"markercluster":false,"clustermaxzoom":20,"clusterzoomonclick":true,"clustermaxradius":80,"clusterspiderfy":true,"showtitle":false,"hidenamespace":false,"template":"LiPDLocation","userparam":"","activeicon":"","pagelabel":false,"ajaxcoordproperty":"","ajaxquery":"","locations":[{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-Bermuda.DraschbaA.2000\" title=\"Ocn-Bermuda.DraschbaA.2000\"\u003EOcn-Bermuda.DraschbaA.2000\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Bermuda\n\u003C/p\u003E","title":"Ocn-Bermuda.DraschbaA.2000.Location","link":"","lat":30.0867,"lon":-64.5417,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-Bermuda.DraschbaB.2000\" title=\"Ocn-Bermuda.DraschbaB.2000\"\u003EOcn-Bermuda.DraschbaB.2000\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Bermuda\n\u003C/p\u003E","title":"Ocn-Bermuda.DraschbaB.2000.Location","link":"","lat":30.0867,"lon":-64.5417,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-BermudaSouthShore.Goodkin.2008\" title=\"Ocn-BermudaSouthShore.Goodkin.2008\"\u003EOcn-BermudaSouthShore.Goodkin.2008\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Bermuda south shore\n\u003C/p\u003E","title":"Ocn-BermudaSouthShore.Goodkin.2008.Location","link":"","lat":30.6486,"lon":-64.9888,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-BiscayneBay.Swart.1996\" title=\"Ocn-BiscayneBay.Swart.1996\"\u003EOcn-BiscayneBay.Swart.1996\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Biscayne Bay\n\u003C/p\u003E","title":"Ocn-BiscayneBay.Swart.1996.Location","link":"","lat":25.38,"lon":-80.17,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-DryTortugas.DeLong.2014\" title=\"Ocn-DryTortugas.DeLong.2014\"\u003EOcn-DryTortugas.DeLong.2014\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Dry Tortugas\n\u003C/p\u003E","title":"Ocn-DryTortugas.DeLong.2014.Location","link":"","lat":24.6,"lon":-82.3,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-FloridaBay.Swart.1996\" title=\"Ocn-FloridaBay.Swart.1996\"\u003EOcn-FloridaBay.Swart.1996\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Florida Bay\n\u003C/p\u003E","title":"Ocn-FloridaBay.Swart.1996.Location","link":"","lat":24.93,"lon":-80.75,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-GingerbreadsBahamas.Saenger.2009\" title=\"Ocn-GingerbreadsBahamas.Saenger.2009\"\u003EOcn-GingerbreadsBahamas.Saenger.2009\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Gingerbreads Bahamas\n\u003C/p\u003E","title":"Ocn-GingerbreadsBahamas.Saenger.2009.Location","link":"","lat":25.84,"lon":-78.62,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-Guadeloupe.Steinhilber.2010\" title=\"Ocn-Guadeloupe.Steinhilber.2010\"\u003EOcn-Guadeloupe.Steinhilber.2010\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Guadeloupe\n\u003C/p\u003E","title":"Ocn-Guadeloupe.Steinhilber.2010.Location","link":"","lat":16.2,"lon":-61.49,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-LosRoques.Hetzinger.2008\" title=\"Ocn-LosRoques.Hetzinger.2008\"\u003EOcn-LosRoques.Hetzinger.2008\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Los Roques, Venezuela\n\u003C/p\u003E","title":"Ocn-LosRoques.Hetzinger.2008.Location","link":"","lat":11.77,"lon":-66.75,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-NorthEastBreakers_Bermuda.Kuhnert.2002\" title=\"Ocn-NorthEastBreakers Bermuda.Kuhnert.2002\"\u003EOcn-NorthEastBreakers Bermuda.Kuhnert.2002\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: North East Breakers, Bermuda\n\u003C/p\u003E","title":"Ocn-NorthEastBreakers Bermuda.Kuhnert.2002.Location","link":"","lat":32.47,"lon":-64.7,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-NorthEastBreakers_Bermuda.Kuhnert.2005\" title=\"Ocn-NorthEastBreakers Bermuda.Kuhnert.2005\"\u003EOcn-NorthEastBreakers Bermuda.Kuhnert.2005\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: North East Breakers, Bermuda\n\u003C/p\u003E","title":"Ocn-NorthEastBreakers Bermuda.Kuhnert.2005.Location","link":"","lat":32.467,"lon":-64.7,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-PedradeLume-CapeVerdeIslands.Moses.2006\" title=\"Ocn-PedradeLume-CapeVerdeIslands.Moses.2006\"\u003EOcn-PedradeLume-CapeVerdeIslands.Moses.2006\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Pedra de Lume, Cape Verde Islands\n\u003C/p\u003E","title":"Ocn-PedradeLume-CapeVerdeIslands.Moses.2006.Location","link":"","lat":16.76,"lon":-22.8883,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-PuntaMaroma.V%C3%A1squez-Bedoya.2012\" title=\"Ocn-PuntaMaroma.V\u00e1squez-Bedoya.2012\"\u003EOcn-PuntaMaroma.V\u00e1squez-Bedoya.2012\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Punta Maroma, Mexico\n\u003C/p\u003E","title":"Ocn-PuntaMaroma.V\u00e1squez-Bedoya.2012.Location","link":"","lat":20.83,"lon":-86.74,"icon":""},{"text":"\u003Cp\u003E\u003Cb\u003E\u003Ca href=\"/Ocn-TurrumoteReefPuertoRico.Kilbourne.2008\" title=\"Ocn-TurrumoteReefPuertoRico.Kilbourne.2008\"\u003EOcn-TurrumoteReefPuertoRico.Kilbourne.2008\u003C/a\u003E\u003C/b\u003E\n\u003C/p\u003E\u003Cp\u003EArchive Type: Turrumote Reef, Puerto Rico\n\u003C/p\u003E","title":"Ocn-TurrumoteReefPuertoRico.Kilbourne.2008.Location","link":"","lat":17.93,"lon":-67,"icon":""}]}