Overview of mapping

[peterdesmet]

Excel sheet to Darwin Core mapping.

opnames_lijst

Mapped to occurrences.

field	DwC field	comments
deelmonster_id	occ.eventID; part of the occ.occurrenceID	multiple unique plants per deelmonster_id. Example for eventID: 21341683. Example for occurrenceID: "21341683:808203f629d0cbc61dca8cf2a0de0064".
meetplaats	none	position recorded at event level
Jaar	none	date recorded at event level
monsternamedatum	none	date recorded at event level
Macrofyt Naam	part of occ.scientificName and occ.occurrenceID	used with Macrofyt Auteur to form scientificName, e.g. Rorippa amphibia (L.) Besser, Sparganium emersum Rehm.. Use with deelmonster_id to form occurrenceID (see examples above).
Macrofyt Rang	occ.taxonRank	Final mapping depending on #6
Macrofyt Auteur	part of occ.scientificName	used with Macrofyt Naam to form scientificName (see examples above).
Macrofyt Voorkeursnaam	occ.vernacularName
groeivorm	occ.occurrenceRemarks	See DwC term definition. Examples: Oever/moeras, Vallisneriden. To be translated to English, see #21.
Tansley Code	occ.organismQuantityValue + occ.organismQuantityType	See #11.
Tansley Weging	none	See #12.
waterlichaamcategorie	none	Same info present in sheet meetplaatsen.
gevalideerd	occ.identificationVerificationStatus	Example: verified. All data are validated.
waterlichaamcategorietype	none	Same info present in sheet meetplaatsen.

Vegetatie-ontwikkeling

Mapped to mof.

field	DwC field	comments
deelmonster_id	mof.id
meetplaats	none	Same as event
monsternamedatum	none	Same as event
interval	part of mof.measurementType	example "submerged plants 70-80m upstream"
Submers Code	none
submers	mof.measurementValue	Example: "rare", see #13 and #7
TODO Submers Weging	none	It can be added. See #14.
gevalideerd	none	not possible to add validation for measurements. See #13.
opmerking	mof.measurementRemarks
waterlichaamcategorietype	none	none

Meetplaatsen

Mostly mapped to event locations

field	DwC field	comments
meetplaats	event.locationID	Examples: TR100400.1, C05.143.
omschrijving	event.locationRemarks	Examples: "Hamont, Kluizerdijk, voor Achelse Kluis, 20m opw brug", "centroïde MAAS II".
X	event.verbatimLongitude	Example: 228043.
Y	event.verbatimLatitude	Example: 221224.
gemeente	event.municipality
provincie	event.stateProvince
waterloop	none	More relevant info is present in waterlichaam (mapped to waterBody)
bekken	mof.measurementType + mof.measurementValue	Translated as basin. See above and #15.
owl	mof.measurementType + mof.measurementValue	See above and #15.
waterlichaam	event.waterBody	Example: WARMBEEK, MAAS I+II+III.
waterlichaamcategorietype	mof.measurementType + mof.measurementValue	See above and #15.
kaart	none	Internal use only.
team	occ.identifiedBy	See #16.

Kenmerken

Mostly mapped to events and mofs.

field	DwC field	comments
deelmonster_id	event.eventID	Used as unique identifier.
meetplaats	none	meetplaats field used in the JOIN with meetplaatsen sheet.
Jaar	none	Already part of eventDate
monsternamedatum	event.eventDate
Totale Bedekking (%)	mof.measurementValue + mof.measurementType	Translated as total coverage. Assigned measurementUnit: %. Used in measurementID, example: 21586186:total_coverage.
Bedekking Eutrofiëringsindicatoren (%)	mof.measurementValue + mof.measurementType	Translated as eutrophication coverage. Assigned measurementUnit: %. Used in measurementID, example: 21586186:eutrophication_coverage.
Bedekking Helofyten (%)	mof.measurementValue + mof.measurementType	Translated as helophytes coverage. Assigned measurementUnit: %. Used in measurementID, example: 21586186:helophytes_coverage.
Beschaduwing Macrofyten (%)	mof.measurementValue + mof.measurementType	Translated as macrophytes shading. Assigned measurementUnit: %. Used in measurementID, example: 21327838:macrophytes_shading.
sliblaag	mof.measurementValue + mof.measurementType	Translated as sludge level. Assigned measurementUnit: cm. Used in measurementID, example: 21327837:sludge_level. See #17.
Laag Grof Organisch Materiaal (cm)	mof.measurementValue + mof.measurementType	Translated as coarse organic matter layer. Assigned measurementUnit: cm. Used in measurementID, example: 21583203:coarse_organic_matter_layer. See #2.
Breedte Waterspiegel Gemiddeld (cm)	mof.measurementValue + mof.measurementType	Translated as average width water level. Assigned measurementUnit: cm. Used in measurementID, example: 21336080:average_width_water_level. See #18.
Breedte Waterspiegel Minimum (cm)	mof.measurementValue + mof.measurementType	Translated as minimum width water level. Assigned measurementUnit: cm. Used in measurementID, example: 21336080:minimum_width_water_level. See #18.
Breedte Waterspiegel Maximum (cm)	mof.measurementValue + mof.measurementType	Translated as maximum width water level. Assigned measurementUnit: cm. Used in measurementID, example: 21336080:maximum_width_water_level. See #18.
Diepte Gemiddeld (cm)	mof.measurementValue + mof.measurementType	Translated as average depth. Assigned measurementUnit: cm. Used in measurementID, example: 21336627:average_depth.
Diepte Minimum (cm)	mof.measurementValue + mof.measurementType	No values present. Translated as minimum depth. Assigned measurementUnit: cm. Same measurementID convention as for average depth will apply.
Diepte Maximum (cm)	mof.measurementValue + mof.measurementType	Translated as maximum depth. Assigned measurementUnit: cm. Used in measurementID, example: 21341689:maximum_depth.
stroming	mof.measurementValue + mof.measurementType	Translated as velocity. No measurementUnit. Used in measurementID, example: 21327837:current. See proposed mapping in #9

veldmetingen (FC)

Mapped to mof.

field	DwC field	comments
Monster ID MOW	none	Not used. See #19.
Deelmonster ID MOW	mof.id	used to JOIN with deelmonster_id from sheet kenmerken.
meetplaats	none	Same as event
monsternamedatum	none	Same as event
par	mof.measurementType	Mapping of the values in #. Used in measurementID. Examples: 21327837:Secchi_depth, 21327837:current, 21327837:dissolved_oxygen.
teken	part of mof.measurementValue if not =	Example: >40.
Resultaat	part of mof.measurementValue	Examples: 1215, 70 >40.
eenh	mof.measurementUnit	Examples: °C, cm, mg/L.
Secchischijf op Bodem	mof.measurementRemarks when measurementType = '"Secchi depth"'	Values: "Secchi disk at the bottom", '"Secchi disk not at the bottom"'.

EKC MAF

field	DwC field	comments
meetplaats	none	Same as avent
Deelmonster ID	mof.id	Link to events.csv via eventID. Example measurementID: 21327837:ecologic_quality_coefficient_with_gep.
Jaar	none	Same as event
monsternamedatum	none	Same as event
index ZONDER gep	mof.measurementValue + mof.measurementType	Translate as "ecologic quality coefficient without GEP". See #4.
index GEP	mof.measurementValue + mof.measurementTye	Translated as "ecologic quality coefficient with GEP". See #4.
type	none	Save at event level using info from sheet meetplaatsen, field waterlichaamcategorietype.
klasse	mof.measurementValue + mof.measurementType	Translated as "'ecologic quality coefficient class". See #4.
status	mof.measurementValue + mof.measurementType	Unchanged while translating to EN: status. See #4.
sterk veranderd	none	Not sure how to map it. See #4.
owl	none	Information at event level.
waterlichaam	none	Information at event level.
Bevestigingscode MF	none	See #4.
Deelmonster Geen Organisme	none	See #4.