Create globally unique IDs

EMODnet / esas2obis

Darwin Core mapping of ESAS data for publication to OBIS

MIT License

0 stars 0 forks source link

Create globally unique IDs #2

Closed peterdesmet closed 2 years ago

peterdesmet commented 2 years ago

See https://obis.org/manual/darwincore/#occurrence

I suggest:

esas:dataCustodian:campaignID:observationID
esas:630:110000001:1100000001

peterdesmet commented 2 years ago

This should then also be used for campaign, sample, positionIDs

peterdesmet commented 2 years ago

Discussed with @rubenpp7 Although the term "globally" unique is used, it mainly means "within the dataset". For traceability it is best to use the identifiers as they appear in ESAS. So no prefixes like esas:. No changes required in SQL, as that is the current approach.

Note that I do follow the recommendation:

Repeating the parentEventID in the child event (use : as delimiter) will make the structure of the dataset easier to understand.

So data looks like this: