[tdwg-content] USDA Plants Growth Forms added to TaxonConcept Plants - Example SPARQL Queries

Peter DeVries pete.devries at gmail.com
Fri Jun 3 22:42:39 CEST 2011


I have a new update to my data set. It is not in the cloud yet but you can
download it or run queries on my server.

See http://www.taxonconcept.org/rdf_and_sitemap/

The USDA Plants data set has lists of plants expected in each county and
state.

I have marked up this data as triples for several states in the Midwest as
well as Massachusetts and Texas.

I have also marked up the data for each Wisconsin County.

The USDA data set also has an attribute called "GrowthForm"

I have these attributes marked up in this vocabulary

OWL http://lod.taxonconcept.org/ontology/usda_plants.owl

Doc http://lod.taxonconcept.org/ontology/usda_plants_doc/index.html

Here are the Growth forms I have as triples.

usda_plant:Growth_Habit_Tree
usda_plant:Growth_Habit_Shrub
usda_plant:Growth_Habit_Subshrub
usda_plant:Growth_Habit_Forb_Herb
usda_plant:Growth_Habit_Graminoid

You can see this in this example from the Knowledge Base

http://lsd.taxonconcept.org/describe/?url=http%3A%2F%2Flod.taxonconcept.org%2Fses%2FHak3o%23Species

bit.ly http://bit.ly/locSNl

You can now run the following kinds of queries:

What plants with the USDA Growth Form Forb_Herb are expected in Door County
WI.

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 door_county_wi:  <http://sws.geonames.org/5250768/>
PREFIX usda_plant:  <http://lod.taxonconcept.org/ontology/usda_plants.owl#>

select distinct ?s, ?o as ?image,  ?col_class, ?sciname where {
 ?s rdf:type txn:SpeciesConcept.
 ?s rdf:type usda_plant:Growth_Habit_Forb_Herb.
 ?s txn:isExpectedIn door_county_wi:.
 ?s txn:inCoLClass ?col_class.
 ?s txn:hasScientificName   ?sciname.
 optional {?s  txn:thumbnail ?o.}.
 }
 ORDER BY ASC(?col_class)

 limit 650

This link is the query encoded in a URI
<
http://lsd.taxonconcept.org/isparql/view/?query=PREFIX%20txn%3A%20%20%3Chttp%3A%2F%2Flod.taxonconcept.org%2Fontology%2Ftxn.owl%23%3E%0APREFIX%20rdf%3A%20%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20dcterms%3A%20%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0APREFIX%20door_county_wi%3A%20%20%3Chttp%3A%2F%2Fsws.geonames.org%2F5250768%2F%3E%0APREFIX%20usda_plant%3A%20%20%3Chttp%3A%2F%2Flod.taxonconcept.org%2Fontology%2Fusda_plants.owl%23%3E%20%0A%0Aselect%20distinct%20%3Fs%2C%20%3Fo%20as%20%3Fimage%2C%20%20%3Fcol_class%2C%20%3Fsciname%20where%20{%0A%20%3Fs%20rdf%3Atype%20txn%3ASpeciesConcept.%0A%20%3Fs%20rdf%3Atype%20usda_plant%3AGrowth_Habit_Forb_Herb.%0A%20%3Fs%20txn%3AisExpectedIn%20door_county_wi%3A.%0A%20%3Fs%20txn%3AinCoLClass%20%3Fcol_class.%0A%20%3Fs%20txn%3AhasScientificName%20%20%20%3Fsciname.%0A%20optional%20{%3Fs%20%20txn%3Athumbnail%20%3Fo.}.%0A%20}%0A%20ORDER%20BY%20ASC(%3Fcol_class)%0A%20%0A%20limit%20650%0A&endpoint=/sparql&maxrows=650&default-graph-uri=&view=1
>

Since this does not always go though email, here is the bit.ly link
http://bit.ly/j5PLzH

<http://bit.ly/j5PLzH>Since the a number of the TDWG BioBlitz Species are
included in the USDA Plants data set, those species concepts now have the
USDA attributes attached.

Since many of these related and now linked data sets exist under different
names, it would have been difficult for this to work without some identifier
like my species concepts.

Respectfully,

- 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
Bases
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/20110603/bcdf546c/attachment.html 


More information about the tdwg-content mailing list