[IPT] Darwin Core Star Schema

Hannu Saarenmaa hannu.saarenmaa at helsinki.fi
Wed Nov 11 11:58:52 CET 2015


Quentin & Co

It depends what you mean by "survey".   I would put each visit to a 
sampling location (such as a plot) in the event core, and put all the 
taxa that are observed in a non-core table.   The properties of the 
entire survey (project) would go to the EML metadata.

Hannu

On 2015-11-11 10:20, Quentin Groom wrote:
> I'm rather confused how the Darwin Core Star Schema is meant to work 
> for survey data.
>
> Darwin Core can have one of two Core files, taxon or occurrence. The 
> most appropriate for a survey would seem to be occurrence. So I 
> imagine that in the star schema you could also have a related event 
> file detailing the date and location of each survey and a non-core 
> taxon file detailing the taxa that are observed.
>
> However, this does not seem to be possible. The DWC-A validator 
> (http://tools.gbif.org/dwca-validator/), assumes only on core id in 
> the core file so you can't link an occurrence both to a taxon and to 
> an event. This is also true in the Darwin Core Archive Assistant 
> (http://tools.gbif.org/dwca-assistant/). The solution seems to be to 
> put all the information from the taxon core file into the occurrence 
> file, but keep the separate event file linked with the core occurrence id.
>
> Is this correct? It seems rather counter intuitive.
>
> Regards
> Quentin
>
>
> Dr. Quentin Groom
> (Botany and Information Technology)
>
> Botanic Garden Meise
> Domein van Bouchout
> B-1860 Meise
> Belgium
>
> ORCID: 0000-0002-0596-5376
>
> Landline; +32 (0) 226 009 20 ext. 364
> FAX:      +32 (0) 226 009 45
>
> E-mail: quentin.groom at plantentuinmeise.be 
> <mailto:quentin.groom at plantentuinmeise.be>
> Skype name: qgroom
> Website: www.botanicgarden.be <http://www.botanicgarden.be>
>
>
> _______________________________________________
> IPT mailing list
> IPT at lists.gbif.org
> http://lists.gbif.org/mailman/listinfo/ipt

-- 

Hannu Saarenmaa, Research Director
hannu.saarenmaa at uef.fi
Mobile +358-50-4479668

University of Eastern Finland
Digitarium, SIB Labs, Joensuu Science Park
Länsikatu 15 (P.O. Box 111)
FI-80101 Joensuu

www.digitarium.fi/en - Service Centre for High-Performance Digitisation
www.eubon.eu - EU BON - GEO BON - Data Integration and Interoperability

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gbif.org/pipermail/ipt/attachments/20151111/42f660cd/attachment.html>


More information about the IPT mailing list