[tdwg-content] Updated TDWG BioBlitz SPARQL Example

Peter DeVries pete.devries at gmail.com
Fri May 6 23:29:40 CEST 2011

*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

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 <
 ?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

Donald's Observations

Cyndy's Observations

   Why not the Wood Frog? It must have not been in the first 500 records but
it is here

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

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 at wisc.edu
TaxonConcept <http://www.taxonconcept.org/>  &
GeoSpecies<http://about.geospecies.org/> Knowledge
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 

More information about the tdwg-content mailing list