Updated TDWG BioBlitz SPARQL Example

I have a link to a bit.ly bundle for the query and screenshots.

http://bit.ly/l7LWuF

* 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.

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.

Attributes like time:month and time:dayOfYear are useful for browsing the data for patterns (maybe not in this BioBlitz example)

Also, I limit the records to those from the BioBlitz using the predicate dcterms:isPartOf

PREFIX txn:     <http://lod.taxonconcept.org/ontology/txn.owl#>
PREFIX rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX foaf:    <http://xmlns.com/foaf/0.1/>
PREFIX cc:      <http://creativecommons.org/ns#>
PREFIX time:    <http://www.w3.org/2006/time#>
PREFIX geo:     <http://www.w3.org/2003/01/geo/wgs84_pos#>


select distinct ?s, ?o as ?image, ?kingdom, ?phylum, ?class, ?order, ?family, ?genus, ?sciname, ?cname, ?month, ?observer, ?lat, ?long where {
 ?s rdf:type txn:Occurrence.
 ?s dcterms:isPartOf <http://lod.taxonconcept.org/ontology/txn.owl#TDWG2010_BioBlitz>.
 ?s txn:kingdom ?kingdom.
 ?s txn:phylum  ?phylum.
 ?s txn:class   ?class.
 ?s txn:order   ?order.
 ?s txn:family  ?family.
 ?s txn:genus   ?genus.
 ?s txn:hasScientificName ?sciname.
 ?s time:month   ?month.
 ?s cc:attributionName ?observer.
 optional {?s foaf:depiction ?o.
           ?s txn:commonName ?cname.
           ?s geo:lat ?lat.
           ?s geo:long ?long.
          }.
 }

limit 500

The live SPARQL Pivot Query http://t.co/RNTLGL9 via LOD cache CLOUD

The live SPARQL No Pivot Query (my endpoint - just a table, but all observations) http://bit.ly/mPd8vi

Here are some direct links, there are more on bit.ly

Observations viewed by Kingdom http://assets.taxonconcept.org/ss/UpdatedTDWGBioBlitzByKingdom_1024x564.png

Donald's Observations http://assets.taxonconcept.org/ss/DonaldHobernTDWG2010Observations_1024x564.png

Cyndy's Observations http://assets.taxonconcept.org/ss/CyndyParrTDWG2010Observations_1024x564.png

   Why not the Wood Frog? It must have not been in the first 500 records but it is here http://ocs.taxonconcept.org/ocs/fbdc4c11-25d4-4f47-91b8-99c649b9f0b9.html

Also I changed the observation and species RDF a little to make some queries easier. 

There is a plant that was identified as Luzula banksiana, (http://lod.taxonconcept.org/ses/py5ST.html) but I think this a New Zealand plant? Is it cultivated in the US?

See http://ocs.taxonconcept.org/ocs/index.html

-- Pete

------------------------------------------------------------------------------------
Pete DeVries
Department of Entomology
University of Wisconsin - Madison
445 Russell Laboratories
1630 Linden Drive
Madison, WI 53706
Email: pdevries@wisc.edu
TaxonConcept  &  GeoSpecies Knowledge Bases
A Semantic Web, Linked Open Data  Project
--------------------------------------------------------------------------------------