[IPT] Darwin Core Star Schema

Quentin Groom quentin.groom at plantentuinmeise.be
Wed Nov 11 13:48:06 CET 2015


So if I understand correctly, the event file can be used as a Core, just as
Taxon and Occurrence can be Core files. Though as there can only be one
Core ID I will still need to keep my taxon information in the Occurrence
file.
Although I don't think this is a problem, it can get a little confusing in
the documentation due to the crossover of terms between taxon and
occurrence files.

I'm happy to be a Guinea pig. I'll experiment with the validator if you
think this should work and let you know how I get on.

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
Skype name: qgroom
Website:    www.botanicgarden.be


On 11 November 2015 at 11:58, Hannu Saarenmaa <hannu.saarenmaa at helsinki.fi>
wrote:

> 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
> Skype name: qgroom
> Website:    www.botanicgarden.be
>
>
> _______________________________________________
> IPT mailing listIPT at lists.gbif.orghttp://lists.gbif.org/mailman/listinfo/ipt
>
>
> --
>
> Hannu Saarenmaa, Research Directorhannu.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 Digitisationwww.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/f7a9838b/attachment.html>


More information about the IPT mailing list