*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%3E. ?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....

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@wisc.edu TaxonConcept http://www.taxonconcept.org/ & GeoSpecieshttp://about.geospecies.org/ Knowledge Bases A Semantic Web, Linked Open Data http://linkeddata.org/ Project --------------------------------------------------------------------------------------