Here is a little more on the latest version of the TDWG BioBlitz records.<br clear="all"><br><meta charset="utf-8"><span class="Apple-style-span" style="border-collapse: collapse; "><div style="font-family: arial, sans-serif; font-size: 13px; ">
This <a href="http://bit.ly/" target="_blank" style="color: rgb(51, 51, 204); ">bit.ly</a> link will run a SPARQL query to give you what you need <span style="color: rgb(68, 68, 68); font-family: Arial; font-size: 15px; ">SPARQL Query for TableView of TDWG BioBlitz Records <span><a href="http://bit.ly/gcA3ox" target="_blank" style="color: rgb(51, 51, 204); ">http://bit.ly/gcA3ox</a></span></span></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><br>Here is the query used: Note it returns those records that have identifications and a lat/long but includes those without a photo.</div><div style="font-family: arial, sans-serif; font-size: 13px; ">
<br></div><div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1">PREFIX foaf: <<a href="http://xmlns.com/foaf/0.1/" target="_blank" style="color: rgb(51, 51, 204); ">http://xmlns.com/foaf/0.1/</a>></font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1">PREFIX txn: <<a href="http://lod.taxonconcept.org/ontology/txn.owl#" target="_blank" style="color: rgb(51, 51, 204); ">http://lod.taxonconcept.org/ontology/txn.owl#</a>></font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1">PREFIX rdf: <<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#" target="_blank" style="color: rgb(51, 51, 204); ">http://www.w3.org/1999/02/22-rdf-syntax-ns#</a>></font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1">PREFIX dcterms: <<a href="http://purl.org/dc/terms/" target="_blank" style="color: rgb(51, 51, 204); ">http://purl.org/dc/terms/</a>></font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1">PREFIX geo: <<a href="http://www.w3.org/2003/01/geo/wgs84_pos#" target="_blank" style="color: rgb(51, 51, 204); ">http://www.w3.org/2003/01/geo/wgs84_pos#</a>></font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1">PREFIX time: <<a href="http://www.w3.org/2006/time#" target="_blank" style="color: rgb(51, 51, 204); ">http://www.w3.org/2006/time#</a>></font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"><br></font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1">select distinct ?s, ?area, ?lat, ?long, ?kingdom, ?phylum, ?class, ?order, ?family, ?scientific_name, ?collector, ?recorder, ?individual, ?date, ?day_of_year, ?depiction where {</font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s rdf:type txn:Occurrence.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s dcterms:isPartOf txn:TDWG2010_BioBlitz.</font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s geo:lat ?lat. </font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s geo:long ?long.</font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:startDate ?date.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s time:dayOfYear ?day_of_year.</font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:occurrenceHasArea ?area.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:kingdom ?kingdom.</font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:phylum ?phylum.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:class ?class.</font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:order ?order.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:family ?family.</font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:hasScientificName ?scientific_name.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; ">
<font face="verdana, sans-serif" size="1"> ?s txn:hasCollector ?collector.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:recordedBy ?recorder.</font></div>
<div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> ?s txn:occurrenceHasIndividual ?individual.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; ">
<font face="verdana, sans-serif" size="1"> OPTIONAL {?s foaf:depiction ?depiction }.</font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1"> }</font></div><div style="font-family: arial, sans-serif; font-size: 13px; ">
<font face="verdana, sans-serif" size="1"><br></font></div><div style="font-family: arial, sans-serif; font-size: 13px; "><font face="verdana, sans-serif" size="1">ORDER BY ASC(?area)</font></div><div style="font-family: arial, sans-serif; font-size: 13px; ">
<font face="verdana, sans-serif" size="1"><br></font></div></div></span><span class="Apple-style-span" style="border-collapse: collapse; font-family: verdana, sans-serif; font-size: x-small; ">limit 1000</span><div><br></div>
<div>===========</div><div><br></div><div>Here is a map base view of those records.</div><div><br></div><div><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="Content-Style-Type" content="text/css">
<title></title>
<meta name="Generator" content="Cocoa HTML Writer">
<meta name="CocoaVersion" content="1038.35">
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; line-height: 19.0px; font: 15.0px Arial; color: #3184b4}
</style>
<p class="p1"><a href="http://bit.ly/ids5hX">http://bit.ly/ids5hX</a></p><p class="p1"><br></p><p class="p1"><meta charset="utf-8"><font class="Apple-style-span" color="#000000" face="arial" size="2">It uses the following query:</font></p>
<p class="p1"><font class="Apple-style-span" color="#000000" face="arial" size="2"><br></font></p><p class="p1"><font class="Apple-style-span" color="#000000" face="arial" size="2">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="Content-Style-Type" content="text/css">
<title></title>
<meta name="Generator" content="Cocoa HTML Writer">
<meta name="CocoaVersion" content="1038.35">
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier; color: #343355}
p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Courier; color: #343355; min-height: 14.0px}
</style>
</font></p><p class="p1"><font class="Apple-style-span" color="#000000" face="arial" size="2">PREFIX foaf: <<a href="http://xmlns.com/foaf/0.1/">http://xmlns.com/foaf/0.1/</a>></font></p><font class="Apple-style-span" color="#000000" face="arial" size="2">
<p class="p1">PREFIX txn: <<a href="http://lod.taxonconcept.org/ontology/txn.owl#">http://lod.taxonconcept.org/ontology/txn.owl#</a>></p>
<p class="p1">PREFIX rdf: <<a href="http://www.w3.org/1999/02/22-rdf-syntax-ns#">http://www.w3.org/1999/02/22-rdf-syntax-ns#</a>></p>
<p class="p1">PREFIX dcterms: <<a href="http://purl.org/dc/terms/">http://purl.org/dc/terms/</a>></p>
<p class="p1">PREFIX geo: <<a href="http://www.w3.org/2003/01/geo/wgs84_pos#">http://www.w3.org/2003/01/geo/wgs84_pos#</a>></p>
<p class="p1">PREFIX time: <<a href="http://www.w3.org/2006/time#">http://www.w3.org/2006/time#</a>></p>
<p class="p2"><br></p>
<p class="p1">describe ?s where {</p>
<p class="p1"> ?s rdf:type txn:Occurrence.</p>
<p class="p1"> ?s dcterms:isPartOf txn:TDWG2010_BioBlitz.</p>
<p class="p1"> ?s geo:lat ?lat. </p>
<p class="p1"> ?s geo:long ?long.</p>
<p class="p1"> ?s txn:startDate ?date.</p>
<p class="p1"> ?s time:dayOfYear ?day_of_year.</p>
<p class="p1"> ?s txn:occurrenceHasArea ?area.</p>
<p class="p1"> ?s txn:kingdom ?kingdom.</p>
<p class="p1"> ?s txn:phylum ?phylum.</p>
<p class="p1"> ?s txn:class ?class.</p>
<p class="p1"> ?s txn:order ?order.</p>
<p class="p1"> ?s txn:family ?family.</p>
<p class="p1"> ?s txn:hasScientificName ?scientific_name.</p>
<p class="p1"> ?s txn:hasCollector ?collector.</p>
<p class="p1"> ?s txn:recordedBy ?recorder.</p>
<p class="p1"> ?s txn:occurrenceHasIndividual ?individual.</p>
<p class="p1"> ?s foaf:depiction ?depiction .</p>
<p class="p1"> }</p>
<p class="p2"><br></p>
<p class="p2">limit 1000</p><p class="p2"><br></p><p class="p2">This PivotView (requires Silverlight) is an interactive way to look at the data. </p><p class="p2"><br></p><p class="p2">It shows the TDWG Observations by Observer <a href="http://bit.ly/fzR3cv">http://bit.ly/fzR3cv</a></p>
<p class="p2"><br></p><p class="p2">* It maybe a little slow to load (~1000 records)</p><p class="p2"><br></p><p class="p2">Here are two screenshots to give you an idea of what this looks like</p><p class="p2">Small Version <a href="http://assets.taxonconcept.org/ss/PivotView_BioBlitz_by_Ob_800x457.png">http://assets.taxonconcept.org/ss/PivotView_BioBlitz_by_Ob_800x457.png</a></p>
<p class="p2">Large Version <a href="http://assets.taxonconcept.org/ss/PivotView_BioBlitz_by_Ob_1614x923.png">http://assets.taxonconcept.org/ss/PivotView_BioBlitz_by_Ob_1614x923.png</a></p><p class="p2"><br></p><p class="p2">
Respectfully,</p><p class="p2"><br></p><p class="p2">- Pete</p></font><p></p></div><div>---------------------------------------------------------------<br>Pete DeVries<br>Department of Entomology<br>University of Wisconsin - Madison<br>
445 Russell Laboratories<br>1630 Linden Drive<br>Madison, WI 53706<br><a href="http://www.taxonconcept.org/" target="_blank">TaxonConcept Knowledge Base</a> / <a href="http://lod.geospecies.org/" target="_blank">GeoSpecies Knowledge Base</a><br>
<a href="http://about.geospecies.org/" target="_blank">About the GeoSpecies Knowledge Base</a><br>------------------------------------------------------------<br>
</div>