This�bit.ly�link will run a SPARQL query to give you what you need�SPARQL Query for TableView of TDWG BioBlitz Records�http://bit.ly/gcA3ox

Here is the query used: Note it returns those records that have identifications and a lat/long but includes those without a photo.

PREFIX foaf: � �<http://xmlns.com/foaf/0.1/>

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 geo: � � <http://www.w3.org/2003/01/geo/wgs84_pos#>

PREFIX time: � �<http://www.w3.org/2006/time#>

select distinct ?s, ?area, ?lat, ?long, ?kingdom, ?phylum, ?class, ?order, ?family, ?scientific_name, ?collector, ?recorder, ?individual, ?date, ?day_of_year, ?depiction where {

�?s rdf:type txn:Occurrence.

�?s dcterms:isPartOf txn:TDWG2010_BioBlitz.

�?s geo:lat � � � �?lat.�

�?s geo:long � � � ?long.

�?s txn:startDate �?date.

�?s time:dayOfYear ?day_of_year.

�?s txn:occurrenceHasArea ?area.

�?s txn:kingdom �?kingdom.

�?s txn:phylum � ?phylum.

�?s txn:class � �?class.

�?s txn:order � �?order.

�?s txn:family � ?family.

�?s txn:hasScientificName ?scientific_name.

�?s txn:hasCollector ?collector.

�?s txn:recordedBy � ?recorder.

�?s txn:occurrenceHasIndividual ?individual.

�OPTIONAL {?s foaf:depiction ?depiction }.

�}

ORDER BY ASC(?area)

Here is a map base view of those records.

http://bit.ly/ids5hX

It uses the following query:

PREFIX foaf:� � <http://xmlns.com/foaf/0.1/>

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 geo: � � <http://www.w3.org/2003/01/geo/wgs84_pos#>

PREFIX time:� � <http://www.w3.org/2006/time#>

describe ?s where {

�?s rdf:type txn:Occurrence.

�?s dcterms:isPartOf txn:TDWG2010_BioBlitz.

�?s geo:lat� � � � ?lat.�

�?s geo:long � � � ?long.

�?s txn:startDate� ?date.

�?s time:dayOfYear ?day_of_year.

�?s txn:occurrenceHasArea ?area.

�?s txn:kingdom� ?kingdom.

�?s txn:phylum � ?phylum.

�?s txn:class� � ?class.

�?s txn:order� � ?order.

�?s txn:family � ?family.

�?s txn:hasScientificName ?scientific_name.

�?s txn:hasCollector ?collector.

�?s txn:recordedBy � ?recorder.

�?s txn:occurrenceHasIndividual ?individual.

�?s foaf:depiction ?depiction .

�}

limit 1000

This PivotView (requires Silverlight) is an interactive way to look at the data.�

It shows the TDWG Observations by Observer�http://bit.ly/fzR3cv

* It maybe a little slow to load (~1000 records)

Here are two screenshots to give you an idea of what this looks like

Small Version�http://assets.taxonconcept.org/ss/PivotView_BioBlitz_by_Ob_800x457.png

Large Version�http://assets.taxonconcept.org/ss/PivotView_BioBlitz_by_Ob_1614x923.png

Respectfully,

- Pete

---------------------------------------------------------------
Pete DeVries
Department of Entomology
University of Wisconsin - Madison
445 Russell Laboratories
1630 Linden Drive
Madison, WI 53706
TaxonConcept Knowledge Base / GeoSpecies Knowledge Base
About the GeoSpecies Knowledge Base
------------------------------------------------------------