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. |