Diversity Collection

Sep 16, 2025

Subsections of Mapping

Diversity Collection

Mapping

Darwin Core

DwC (Test mit copilot)

subject_id predicate_id object_id subject_label object_label mapping_justification
CollectionEvent.CollectionDate skos:exactMatch dwc:eventDate Collection Date Event Date Identical semantic meaning
CollectionEvent.StartDate skos:closeMatch dwc:eventDate Start Date Event Date Partial overlap
CollectionEvent.EndDate skos:closeMatch dwc:eventDate End Date Event Date Partial overlap
CollectionEvent.Method skos:exactMatch dwc:samplingProtocol Collection Method Sampling Protocol Equivalent terminology
CollectionEvent.LocationID skos:exactMatch dwc:locationID Location ID Location ID Identical semantic meaning
CollectionEvent.Latitude skos:exactMatch dwc:decimalLatitude Latitude Decimal Latitude Identical semantic meaning
CollectionEvent.Longitude skos:exactMatch dwc:decimalLongitude Longitude Decimal Longitude Identical semantic meaning
CollectionEvent.Elevation skos:closeMatch dwc:verbatimElevation Elevation Verbatim Elevation Similar but not standardized
CollectionEvent.Habitat skos:exactMatch dwc:habitat Habitat Habitat Identical semantic meaning
CollectionEvent.Collector skos:exactMatch dwc:recordedBy Collector Recorded By Equivalent terminology
CollectionEvent.Remarks skos:closeMatch dwc:eventRemarks Remarks Event Remarks Partial overlap

Test with gemini

title: “CollectionEvent to Darwin Core SSSOM Mapping”

description: “A standard mapping from the Diversity Workbench CollectionEvent table to Darwin Core terms.” date: 2023-10-27T10:00:00+02:00 draft: false

This document provides a mapping of columns from a typical Diversity Workbench CollectionEvent table to standard Darwin Core terms, following the SSSOM (Simple Standard for Sharing Ontology Mappings) schema.

subject_id subject_label predicate_id object_id object_label mapping_justification comment
CollectionEventID Collection Event ID skos:exactMatch dwc:eventID Event ID semap:LexicalMatch The unique identifier for the collection event.
CollectorsName Collectors Name skos:exactMatch dwc:recordedBy Recorded By semap:LexicalMatch The name(s) of the person(s) who collected the item.
VerbatimEventDate Verbatim Event Date skos:exactMatch dwc:verbatimEventDate Verbatim Event Date semap:LexicalMatch The verbatim original date.
EventDate Event Date skos:exactMatch dwc:eventDate Event Date semap:DerivedMatch The standardized date of the event.
Locality Locality skos:exactMatch dwc:locality Locality semap:LexicalMatch The specific description of the place.
Latitude Latitude skos:exactMatch dwc:decimalLatitude Decimal Latitude semap:LexicalMatch The latitude in decimal degrees.
Longitude Longitude skos:exactMatch dwc:decimalLongitude Decimal Longitude semap:LexicalMatch The longitude in decimal degrees.
GeodeticDatum Geodetic Datum skos:exactMatch dwc:geodeticDatum Geodetic Datum semap:LexicalMatch The geodetic datum for the coordinates.
Altitude Altitude skos:closeMatch dwc:verbatimElevation Verbatim Elevation semap:LexicalMatch The verbatim original elevation. Use dwc:minimumElevationInMeters and dwc:maximumElevationInMeters for a range.
CoordinateUncertainty Coordinate Uncertainty skos:exactMatch dwc:coordinateUncertaintyInMeters Coordinate Uncertainty In Meters semap:LexicalMatch The horizontal distance in meters.
Habitat Habitat skos:exactMatch dwc:habitat Habitat semap:LexicalMatch A description of the habitat.
CollectingMethod Collecting Method skos:exactMatch dwc:samplingProtocol Sampling Protocol semap:LexicalMatch The method used to collect the specimen.
Notes Notes skos:exactMatch dwc:eventRemarks Event Remarks semap:LexicalMatch General notes or remarks about the event.
CollectionID Collection ID skos:closeMatch dwc:occurrenceID Occurrence ID semap:DerivedMatch The original ID from the source database, which might relate to the occurrence record.

Gemini 2. Versuch

erzeuge ein sssom mapping nach darwincore (https://dwc.tdwg.org) der datenbank tabelle CollectionEvent die hier definiert ist: https://www.diversityworkbench.de/manual/dwb_latest/modules/diversitycollection/internals_dc/database_dc/database_structure_dc/database_tables_dc/index.html#table-collectionevent. Halte Dich strikt an die Definition der tabelle CollectionEvent. Füge keine Spalten hinzu und lasse keine weg.
subject_id (Spalte in CollectionEvent) predicate_id (Beziehung) object_id (Darwin Core Begriff)
CollectionEventID skos:closeMatch dwc:eventID
CollectionID skos:closeMatch dwc:collectionID
Collector skos:closeMatch dwc:recordedBy
LocalityDescription skos:closeMatch dwc:locality
Altitude skos:closeMatch dwc:minimumElevationInMeters
Altitude skos:closeMatch dwc:maximumElevationInMeters
AltitudeUnit skos:closeMatch dwc:verbatimElevation
Longitude skos:closeMatch dwc:decimalLongitude
Latitude skos:closeMatch dwc:decimalLatitude
GeoRefMethod skos:closeMatch dwc:georeferenceProtocol
HabitatDescription skos:closeMatch dwc:habitat
DateStart skos:closeMatch dwc:eventDate
DateEnd skos:closeMatch dwc:eventDate
CollectionTime skos:closeMatch dwc:eventTime
Notes skos:closeMatch dwc:eventRemarks
Number skos:closeMatch dwc:recordNumber
LocationID skos:closeMatch dwc:locationID
AccessionDate skos:closeMatch dwc:dateCollected
AccessionNumber skos:closeMatch dwc:catalogNumber
SeriesNumber skos:closeMatch dwc:collectionNumber
Author skos:closeMatch dwc:recordedBy
Version skos:closeMatch dwc:dataGeneralizations
please create a sssom mapping to darwincore (https://dwc.tdwg.org) for the database table CollectionEvent as defined below: 
### Table **CollectionEvent**
The event where and when the specimen were collected
| Column | Data type | Description | Nullable | Relation |
| --- | :-: | --- | :-: | --- |
| __CollectionEventID__| int| Unique ID for the table CollectionEvent (= primary key)| NO| -|
| Version| int| The version of the data set. Automatically set by the system.Default value: (1)| NO| -|
| SeriesID| int| The ID of the related expedition. Relates to the PK of the table CollectionExpedition (foreign key). | YES| Refers to table CollectionEventSeries|
| CollectorsEventNumber| nvarchar (50)| Number assigned to a collection event by the collector (= 'field number')| YES| -|
| CollectionDate| datetime| The cached date of the collection event calulated from the entries in CollectionDay, -Month and -Year.| YES| -|
| CollectionDay| tinyint| The day of the date of the event or when the collection event started| YES| -|
| CollectionMonth| tinyint| The month of the date of the event or when the collection event started| YES| -|
| CollectionYear| smallint| The year of the date of the event or when the collection event started| YES| -|
| CollectionEndDay| tinyint| The day of the date of the event or when the collection event ended| YES| -|
| CollectionEndMonth| tinyint| The month of the date of the event or when the collection event ended| YES| -|
| CollectionEndYear| smallint| The year of the date of the event or when the collection event ended| YES| -|
| CollectionDateSupplement| nvarchar (100)| Verbal or additional collection date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'. The end date, if the collection event comprises a period. The time of the event, if necessary.| YES| -|
| CollectionDateCategory| nvarchar (50)| Category of the date of the identification e.g. "system", "estimated"  (= foreign key, see  in table CollEventDateCategory_Enum)| YES| Refers to table CollEventDateCategory_Enum|
| CollectionTime| varchar (50)| The time of the event or when the collection event started| YES| -|
| CollectionTimeSpan| varchar (50)| The time span e.g. in seconds of the collection event| YES| -|
| LocalityDescription| nvarchar (MAX)| Locality description of the locality exactly as written on the original label (i.e. without corrections during data entry)| YES| -|
| LocalityVerbatim| nvarchar (MAX)| Locality as given in historical context, documents and labels| YES| -|
| HabitatDescription| nvarchar (MAX)| Geo-ecological description of the locality exactly as written on the original label (i.e. without corrections during data entry)| YES| -|
| ReferenceTitle| nvarchar (255)| The title of the publication where the collection event was published. Note that this is only a cached value where ReferenceURI is present| YES| -|
| ReferenceURI| varchar (255)| URI (e.g. LSID) of the source publication where the collection event is published, may e.g. refer to the module DiversityReferences| YES| -|
| ReferenceDetails| nvarchar (50)| The exact location within the reference, e.g. pages, plates| YES| -|
| CollectingMethod| nvarchar (MAX)| Description of the method used for collecting the samples, e.g. traps, moist chambers, drag net| YES| -|
| Notes| nvarchar (MAX)| Notes on the collection event| YES| -|
| CountryCache| nvarchar (50)| The country where the collection event took place. Cached value derived from an entry in CollectionEventLocalisation| YES| -|
| DataWithholdingReason| nvarchar (255)| If the data set is withhold, the reason for withholding the data, otherwise null| YES| -|
| DataWithholdingReasonDate| nvarchar (50)| The reason for withholding the collection date| YES| -|
| LogCreatedWhen| datetime| Point in time when this data set was createdDefault value: getdate()| YES| -|
| LogCreatedBy| nvarchar (50)| Name of the creator of this data setDefault value: suser_sname()| YES| -|
| LogUpdatedWhen| datetime| Point in time when this data set was updated lastDefault value: getdate()| YES| -|
| LogUpdatedBy| nvarchar (50)| Name of the person to update this data set lastDefault value: suser_sname()| YES| -|

 The mapping should contain the sssom columns subject_id, subject_label, predicate_id, object_id, object_label, mapping_justification, comment.

3. Versuch mit Gemini

Here is the SSSOM mapping for the CollectionEvent table to Darwin Core, based on the provided definition.

subject_id subject_label predicate_id object_id object_label mapping_justification comment
CollectionEventID CollectionEventID skos:closeMatch dwc:eventID eventID This column serves as a unique identifier for the collection event. Unique identifier for a collection event.
Version Version skos:closeMatch dwc:datasetID datasetID The dataset version can be mapped to a unique dataset identifier. The version of the data set.
SeriesID SeriesID skos:closeMatch dwc:eventID eventID This ID relates to a series of collection events, which could be represented as an event ID. Relates to the collection expedition or series of events.
CollectorsEventNumber CollectorsEventNumber skos:closeMatch dwc:recordNumber recordNumber This field number is the collector’s identifier for a specific collection event. Number assigned to a collection event by the collector.
CollectionDate CollectionDate skos:closeMatch dwc:eventDate eventDate The cached date of the collection event is a direct match for eventDate. The cached date of the collection event.
CollectionDay CollectionDay skos:closeMatch dwc:day day Direct mapping to the Darwin Core day term. The day of the date of the event.
CollectionMonth CollectionMonth skos:closeMatch dwc:month month Direct mapping to the Darwin Core month term. The month of the date of the event.
CollectionYear CollectionYear skos:closeMatch dwc:year year Direct mapping to the Darwin Core year term. The year of the date of the event.
CollectionEndDay CollectionEndDay skos:closeMatch dwc:endDayOfYear endDayOfYear Represents the end day of a multi-day collection event. The day of the end of the collection event.
CollectionEndMonth CollectionEndMonth skos:closeMatch dwc:endDayOfYear endDayOfYear Represents the end month of a multi-month collection event. The month of the end of the collection event.
CollectionEndYear CollectionEndYear skos:closeMatch dwc:year year The end year of a multi-year collection event. The year of the end of the collection event.
CollectionDateSupplement CollectionDateSupplement skos:closeMatch dwc:verbatimEventDate verbatimEventDate This column contains verbatim date information not suitable for structured fields. Verbal or additional collection date information.
CollectionDateCategory CollectionDateCategory skos:closeMatch dwc:eventRemarks eventRemarks This is a categorical note about the date and can be included in general remarks. Category of the date of the identification.
CollectionTime CollectionTime skos:closeMatch dwc:eventTime eventTime Direct mapping to the Darwin Core event time term. The time of the event.
CollectionTimeSpan CollectionTimeSpan skos:closeMatch dwc:duration duration Represents the duration of the event. The time span of the collection event.
LocalityDescription LocalityDescription skos:closeMatch dwc:locality locality Direct mapping to the Darwin Core locality term. Locality description on the original label.
LocalityVerbatim LocalityVerbatim skos:closeMatch dwc:verbatimLocality verbatimLocality This column explicitly holds verbatim locality information. Locality as given in historical context.
HabitatDescription HabitatDescription skos:closeMatch dwc:habitat habitat Direct mapping to the Darwin Core habitat term. Geo-ecological description of the locality.
ReferenceTitle ReferenceTitle skos:closeMatch dwc:bibliographicCitation bibliographicCitation The title of a publication is a core component of a bibliographic citation. The title of the publication where the collection event was published.
ReferenceURI ReferenceURI skos:closeMatch dwc:occurrenceID occurrenceID A URI referencing a publication can be used to uniquely identify an occurrence. URI of the source publication where the collection event is published.
ReferenceDetails ReferenceDetails skos:closeMatch dwc:bibliographicCitation bibliographicCitation Details like page numbers are part of a full bibliographic citation. The exact location within the reference.
CollectingMethod CollectingMethod skos:closeMatch dwc:samplingProtocol samplingProtocol This is a direct description of the method used for collecting. Description of the method used for collecting.
Notes Notes skos:closeMatch dwc:eventRemarks eventRemarks General notes about the event. Notes on the collection event.
CountryCache CountryCache skos:closeMatch dwc:country country Direct mapping to the Darwin Core country term. The country where the collection event took place.
DataWithholdingReason DataWithholdingReason skos:closeMatch dwc:dataGeneralizations dataGeneralizations The reason for withholding data relates to the generalization of the data to protect sensitive information. If the data set is withheld, the reason for withholding.
DataWithholdingReasonDate DataWithholdingReasonDate skos:closeMatch dwc:eventRemarks eventRemarks This is a remark about why the date is withheld. The reason for withholding the collection date.
LogCreatedWhen LogCreatedWhen skos:closeMatch dwc:dateIdentified dateIdentified The creation log can be mapped to the date of identification. Point in time when this data set was created.
LogCreatedBy LogCreatedBy skos:closeMatch dwc:recordedBy recordedBy The name of the creator can be mapped to the person who recorded the event. Name of the creator of this data set.
LogUpdatedWhen LogUpdatedWhen skos:closeMatch dwc:dateIdentified dateIdentified The log update time can be a proxy for a later date of identification. Point in time when this data set was updated last.
LogUpdatedBy LogUpdatedBy skos:closeMatch dwc:recordedBy recordedBy The name of the person who updated the data can be mapped to the recorder. Name of the person to update this data set last.