Example Queries of GeoSpecies Data Set

Here are some example SPARQL queries of the current GeoSpecies Data Set.
They should work on your local triple store or, on the LOD once the new data
set is updated.

Note the difference between

*geospecies:isExpectedIn* (could be expected in area even if unlikely)

and

*geospecies:wasObservedIn* (a record for a species observation in that area
is in the knowledge base)

The *isExpectedIn* can be used to get a presumptive species list for an
area.


#1 Mosquitoes (Culicidae) Expected in Wisconsin
PREFIX geospecies: <http://rdf.geospecies.org/ont/geospecies#>
PREFIX culicidae: <http://lod.geospecies.org/families/wQViY>
PREFIX state: <http://sws.geonames.org/5279468/>
PREFIX dcterms: <http://purl.org/dc/terms/>

SELECT DISTINCT ?family_name ?cannonicalName ?speciesconcept ?geospeciespage

WHERE {
?x geospecies:hasFamilyName ?family_name;
 geospecies:hasCanonicalName ?cannonicalName;
 dcterms:identifier ?speciesconcept;
 geospecies:hasGeoSpeciesPage ?geospeciespage;
 geospecies:inFamily <http://lod.geospecies.org/families/wQViY>;
 geospecies:isExpectedIn <http://sws.geonames.org/5279468/>.
}
ORDER BY ?family_name ?cannonicalName



#2 "Strigidae" OWLs Expected in Wisconsin
PREFIX geospecies: <http://rdf.geospecies.org/ont/geospecies#>
PREFIX strigidae: <http://lod.geospecies.org/families/a4vTG>
PREFIX state: <http://sws.geonames.org/5279468/>
PREFIX dcterms: <http://purl.org/dc/terms/>

SELECT DISTINCT ?family_name ?cannonicalName ?speciesconcept ?geospeciespage

WHERE {
?x geospecies:hasFamilyName ?family_name;
geospecies:hasCanonicalName ?cannonicalName;
dcterms:identifier ?speciesconcept;
geospecies:hasGeoSpeciesPage ?geospeciespage;
geospecies:inFamily <http://lod.geospecies.org/families/a4vTG>;
geospecies:isExpectedIn<http://sws.geonames.org/5279468/>.
}
ORDER BY ?family_name ?cannonicalName


#3 Species Observed in Door County, Wisconsin
PREFIX geospecies: <http://rdf.geospecies.org/ont/geospecies#>
PREFIX county: <http://sws.geonames.org/5279468/>
PREFIX dcterms: <http://purl.org/dc/terms/>

SELECT DISTINCT ?family_name ?cannonicalName ?speciesconcept ?geospeciespage

WHERE {
?x geospecies:hasFamilyName ?family_name;
 geospecies:hasCanonicalName ?cannonicalName;
 dcterms:identifier ?speciesconcept;
 geospecies:hasGeoSpeciesPage ?geospeciespage;
 geospecies:wasObservedIn<http://sws.geonames.org/5279468/>.
}
ORDER BY ?family_name ?cannonicalName

----------------------------------------------------------------
Pete DeVries
Department of Entomology
University of Wisconsin - Madison
445 Russell Laboratories
1630 Linden Drive
Madison, WI 53706
GeoSpecies Knowledge Base http://lod.geospecies.org/
About the GeoSpecies Knowledge Base
http://about.geospecies.org/
------------------------------------------------------------