<div><b>Updated TDWG BioBlitz SPARQL Example</b></div><div><br></div>I have a link to a <a href="http://bit.ly">bit.ly</a> bundle for the query and screenshots.<div><br></div><div><a href="http://bit.ly/l7LWuF">http://bit.ly/l7LWuF</a></div>
<div><br></div><div><a href="http://bit.ly/l7LWuF"></a>* It is possible that the LOD cache will be updating to the new version when you read this, so if the live query does not work the bundle has screen shots that will.<br clear="all">
<br></div><div>The query text is below. Note it is set to return just 500 records. Depending on the time of day etc. I had some issues with Pivot so I set the limit to 500 rather than 1005.</div><div><br></div><div>Attributes like time:month and time:dayOfYear are useful for browsing the data for patterns (maybe not in this BioBlitz example)</div>
<div><br></div><div>Also, I limit the records to those from the BioBlitz using the predicate dcterms:isPartOf</div><div><br></div><div><div><font class="Apple-style-span" face="'courier new', monospace">PREFIX txn: <<a href="http://lod.taxonconcept.org/ontology/txn.owl#">http://lod.taxonconcept.org/ontology/txn.owl#</a>></font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">PREFIX rdf: <<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#">http://www.w3.org/1999/02/22-rdf-syntax-ns#</a>></font></div><div><font class="Apple-style-span" face="'courier new', monospace">PREFIX dcterms: <<a href="http://purl.org/dc/terms/">http://purl.org/dc/terms/</a>></font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">PREFIX foaf: <<a href="http://xmlns.com/foaf/0.1/">http://xmlns.com/foaf/0.1/</a>></font></div><div><font class="Apple-style-span" face="'courier new', monospace">PREFIX cc: <<a href="http://creativecommons.org/ns#">http://creativecommons.org/ns#</a>></font></div>
<div><font class="Apple-style-span" face="'courier new', monospace">PREFIX time: <<a href="http://www.w3.org/2006/time#">http://www.w3.org/2006/time#</a>></font></div><div><font class="Apple-style-span" face="'courier new', monospace">PREFIX geo: <<a href="http://www.w3.org/2003/01/geo/wgs84_pos#">http://www.w3.org/2003/01/geo/wgs84_pos#</a>></font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"><br></font></div><div><font class="Apple-style-span" face="'courier new', monospace"><br></font></div><div><font class="Apple-style-span" face="'courier new', monospace">select distinct ?s, ?o as ?image, ?kingdom, ?phylum, ?class, ?order, ?family, ?genus, ?sciname, ?cname, ?month, ?observer, ?lat, ?long where {</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"> ?s rdf:type txn:Occurrence.</font></div><div><font class="Apple-style-span" face="'courier new', monospace"> ?s dcterms:isPartOf <<a href="http://lod.taxonconcept.org/ontology/txn.owl#TDWG2010_BioBlitz">http://lod.taxonconcept.org/ontology/txn.owl#TDWG2010_BioBlitz</a>>.</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"> ?s txn:kingdom ?kingdom.</font></div><div><font class="Apple-style-span" face="'courier new', monospace"> ?s txn:phylum ?phylum.</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"> ?s txn:class ?class.</font></div><div><font class="Apple-style-span" face="'courier new', monospace"> ?s txn:order ?order.</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"> ?s txn:family ?family.</font></div><div><font class="Apple-style-span" face="'courier new', monospace"> ?s txn:genus ?genus.</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"> ?s txn:hasScientificName ?sciname.</font></div><div><font class="Apple-style-span" face="'courier new', monospace"> ?s time:month ?month.</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"> ?s cc:attributionName ?observer.</font></div><div><font class="Apple-style-span" face="'courier new', monospace"> optional {?s foaf:depiction ?o.</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"> ?s txn:commonName ?cname.</font></div><div><font class="Apple-style-span" face="'courier new', monospace"> ?s geo:lat ?lat.</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace"> ?s geo:long ?long.</font></div><div><font class="Apple-style-span" face="'courier new', monospace"> }.</font></div><div>
<font class="Apple-style-span" face="'courier new', monospace"> }</font></div><div><font class="Apple-style-span" face="'courier new', monospace"><br></font></div><div><font class="Apple-style-span" face="'courier new', monospace">limit 500</font></div>
</div><div><br></div><div>The live SPARQL Pivot Query <a href="http://t.co/RNTLGL9">http://t.co/RNTLGL9</a> via LOD cache CLOUD</div><div><br></div><div>The live SPARQL No Pivot Query (my endpoint - just a table, but all observations) <a href="http://bit.ly/mPd8vi">http://bit.ly/mPd8vi</a></div>
<div><br></div><div>Here are some direct links, there are more on <a href="http://bit.ly">bit.ly</a></div><div><br></div><div>Observations viewed by Kingdom <a href="http://assets.taxonconcept.org/ss/UpdatedTDWGBioBlitzByKingdom_1024x564.png">http://assets.taxonconcept.org/ss/UpdatedTDWGBioBlitzByKingdom_1024x564.png</a></div>
<div><br></div><div>Donald's Observations <a href="http://assets.taxonconcept.org/ss/DonaldHobernTDWG2010Observations_1024x564.png">http://assets.taxonconcept.org/ss/DonaldHobernTDWG2010Observations_1024x564.png</a></div>
<div><br></div><div>Cyndy's Observations <a href="http://assets.taxonconcept.org/ss/CyndyParrTDWG2010Observations_1024x564.png">http://assets.taxonconcept.org/ss/CyndyParrTDWG2010Observations_1024x564.png</a></div><div>
<br></div><div> Why not the Wood Frog? It must have not been in the first 500 records but it is here <a href="http://ocs.taxonconcept.org/ocs/fbdc4c11-25d4-4f47-91b8-99c649b9f0b9.html">http://ocs.taxonconcept.org/ocs/fbdc4c11-25d4-4f47-91b8-99c649b9f0b9.html</a></div>
<div><br></div><div>Also I changed the observation and species RDF a little to make some queries easier. </div><div><br></div><div>There is a plant that was identified as <i>Luzula banksiana, (<a href="http://lod.taxonconcept.org/ses/py5ST.html">http://lod.taxonconcept.org/ses/py5ST.html</a>) </i>but I think this a New Zealand plant? Is it cultivated in the US?</div>
<div><br></div><div>See <a href="http://ocs.taxonconcept.org/ocs/index.html">http://ocs.taxonconcept.org/ocs/index.html</a></div><div><a href="http://assets.taxonconcept.org/ss/UpdatedTDWGBioBlitzByKingdom_1024x564.png"></a><br>
-- Pete</div><div><br>
------------------------------------------------------------------------------------<br>Pete DeVries<br>Department of Entomology<br>University of Wisconsin - Madison<br>445 Russell Laboratories<br>1630 Linden Drive<br>Madison, WI 53706<br>
Email: <a href="mailto:pdevries@wisc.edu" target="_blank">pdevries@wisc.edu</a><br><a href="http://www.taxonconcept.org/" target="_blank">TaxonConcept</a> & <a href="http://about.geospecies.org/" target="_blank">GeoSpecies</a> Knowledge Bases<br>
A Semantic Web, <a href="http://linkeddata.org/" target="_blank">Linked Open Data</a> Project<br>--------------------------------------------------------------------------------------<br>
</div>