tdwg / mids

11 stars 7 forks source link

MIDS Mapping to ABCD #64

Open DavidFichtmueller opened 1 year ago

DavidFichtmueller commented 1 year ago

The MIDS draft v1.16 from 2022-05-28 already has some mappings to ABCD terms, but it only has them to ABCD 3 and the mappings are incomplete and in some cases wrong. So we looked into the mappings a bit more and created the table below for the mappings between MIDS and both ABCD 3 (concept URI) and ABCD 2 (both concept URI and XPath). I hope this helps with the alignment of MIDS and ABCD. Please let me know if you have any other questions.

Prefixes:

MIDS Term ABCD 3 Term ABCD 2 Term ABCD 2 Xpath Comment
Modified abcd:DataSet with abcd:hasDateModified abcd2:DataSet-DateModified /DataSets/DataSet/Metadata/RevisionData/DateModified
Modified abcd:Unit with abcd:hasDateModified abcd2:Unit-DateLastEdited /DataSets/DataSet/Units/Unit/DateLastEdited alternative modified date on record level
PhysicalSpecimenId abcd:Unit with abcd:id abcd2:UnitID /DataSets/DataSet/Units/Unit/UnitID
PhysicalSpecimenId abcd:Unit with abcd:guid abcd2:UnitGUID /DataSets/DataSet/Units/Unit/UnitGUID
Institution - Code abcd:Unit abcd:sourceInstitutionID abcd2:SourceInstitutionID /DataSets/DataSet/Units/Unit/SourceInstitutionID
Institution - Referent abcd:DataSet with abcd:hasOwner (of class abcd:Person) with abcd:hasOrganization with abcd:guid abcd2:DataSet-Owner-OrganisationGUID /DataSets/DataSet/Metadata/Owners/Owner/Organisation/OrganisationGUID has:Owner can both point to a person or an organization, if it is person, use has:Organization to get to the organization for its GUID
Institution - Referent abcd:DataSet with abcd:hasOwner (of class abcd:Organization) with abcd:guid this is if the owner is the organization
Institution - Referent abcd:Unit with abcd:hasOwner (of class abcd:Person) with abcd:hasOrganization with abcd:guid abcd2:Unit-Owner-OrganisationGUID /DataSets/DataSet/Units/Unit/Owner/Organisation/OrganisationGUID alternative owner on the record level, again with both ways to get the Org GUID
Institution - Referent abcd:Unit with abcd:hasOwner (of class abcd:Organization) with abcd:guid
SpecimenType abcd:Unit with abcd:hasRecordBasis abcd2:RecordBasis /DataSets/DataSet/Units/Unit/RecordBasis
ObjectType abcd:Unit with abcd:kindOfUnit abcd2:KindOfUnit /DataSets/DataSet/Units/Unit/KindOfUnit
Name abcd:ScientificName with abcd:fullScientificName abcd2:TaxonIdentified-FullScientificNameString /DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString
Name abcd:IdentifiedTaxon with abcd:informalName abcd2:TaxonIdentified-InformalNameString /DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/InformalNameString
Name abcd: ZoologicalScientificName with abcd:namedIndividual abcd2:TaxonIdentified-NamedIndividual /DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/NameAtomised/Zoological/NamedIndividual
License abcd:DataSet with abcd:hasLicense (of class abcd:LegalStatement) abcd2:DataSet-License-Text /DataSets/DataSet/Metadata/IPRStatements/Licenses/License/Text
License abcd:Unit with abcd:hasLicense (of class abcd:LegalStatement) abcd2:Unit-License-Text /DataSets/DataSet/Units/Unit/IPRStatements/Licenses/License/Text alternative license on record level
PreparationType abcd:Preparation with abcd:preparationType abcd2:SpecimenUnit-PreparationType /DataSets/DataSet/Units/Unit/SpecimenUnit/Preparations/Preparation/PreparationType
snsb-seifert commented 6 months ago
MIDS Class ABCD3 Term ABCD2 Term ABCD2 XPath comment
QualitativeLocation Gathering_LocalityText /DataSets/DataSet/Units/Unit/Gathering/LocalityText
QualitativeLocation Gathering_Country /DataSets/DataSet/Units/Unit/Gathering/Country
QualitativeLocation Gathering_Biotope /DataSets/DataSet/Units/Unit/Gathering/Biotope
QualitativeLocation Gathering_NamedAreas /DataSets/DataSet/Units/Unit/Gathering/NamedAreas
QualitativeLocation Gathering_Gathering_NearNamedPlaces_Gathering_Gathering_NearNamedPlaces_NamedPlaceRelation_NearNamedPlace /DataSets/DataSet/Units/Unit/Gathering/NearNamedPlaces/NamedPlaceRelation/NearNamedPlace
QualitativeLocation Gathering_AreaDetail /DataSets/DataSet/Units/Unit/Gathering/AreaDetails
QuantitativeLocation Gathering_SiteCoordinateSets /DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets
QuantitativeLocation Gathering_GML /DataSets/DataSet/Units/Unit/Gathering/GML
QuantitativeLocation Gathering_WFS /DataSets/DataSet/Units/Unit/Gathering/WFS
QuantitativeLocation Gathering_WMSURL /DataSets/DataSet/Units/Unit/Gathering/WMSURL WMS URL with center coordinate given
CollectingAgent Gathering_Agents_GatheringAgent /DataSets/DataSet/Units/Unit/Gathering/Agents/GatheringAgent
DateCollected Gathering_DateTime /DataSets/DataSet/Units/Unit/Gathering/DateTime
CollectingNumber Unit_CollectorsFieldNumber /DataSets/DataSet/Units/Unit/CollectorsFieldNumber
Media Unit_Unit_MultiMediaObjects_MultiMediaObject /DataSets/DataSet/Units/Unit/MultiMediaObjects/MultiMediaObject
GeologicalAge PalaeontologicalUnit_TimeRange /DataSets/DataSet/Units/Unit/PalaeontologicalUnit/TimeRange
GeologicalAge Stratigraphy_ChronostratigraphicTerms /DataSets/DataSet/Units/Unit/Gathering/Stratigraphy/ChronostratigraphicTerms/ ChronostratigraphicTerm
TypeStatus Unit_Unit_SpecimenUnit_NomenclaturalTypeDesignations_NomenclaturalTypeDesignation_TypeStatus /DataSets/DataSet/Units/Unit/SpecimenUnit/NomenclaturalTypeDesignations/NomenclaturalTypeDesignation/TypeStatus Cell
CollectorID N/A
ScientificNameID N/A
GeographicalLocalityID N/A
IdentifiedByID N/A
AssociatedMediaID N/A
Mass
DavidFichtmueller commented 5 months ago

I have transferred the mappings from here into the SSSOM format, however since I could not edit this table , I created a copy of the file and added a new work sheet for the ABCD mapping. It is a first draft and there are still many things to be optimized, but it gives us a basis for discussion. One of the structural changes that I did was the addition of a column xpath (I am still not sure, which property to use to semantically describe it, maybe create one under the tdwgutils: group), as the xpath is the practical link between the URI of the concept to its content in the XML structure. But we can discuss this later, how to best integrate them.

matdillen commented 5 months ago

Could the xpath be labeled as object_source?