[tdwg-content] Updated TDWG BioBlitz SPARQL Example

[Peter DeVries]

*Updated TDWG BioBlitz SPARQL Example*

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

http://bit.ly/l7LWuF

<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
<http://assets.taxonconcept.org/ss/UpdatedTDWGBioBlitzByKingdom_1024x564.png>
-- Pete

------------------------------------------------------------------------------------
Pete DeVries
Department of Entomology
University of Wisconsin - Madison
445 Russell Laboratories
1630 Linden Drive
Madison, WI 53706
Email: pdevries at wisc.edu
TaxonConcept <http://www.taxonconcept.org/>  &
GeoSpecies<http://about.geospecies.org/> Knowledge
Bases
A Semantic Web, Linked Open Data <http://linkeddata.org/>  Project
--------------------------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.tdwg.org/pipermail/tdwg-content/attachments/20110506/74aa5a26/attachment.html