# \#mapping **URL:** https://odm.discourse.group/tag/mapping/28.md [Latest](https://odm.discourse.group/latest.md) · [Categories](https://odm.discourse.group/categories.md) · [Tags](https://odm.discourse.group/tags.md) --- ## [Dealing with multiple values when mapping from multivalued source to singlevalued ODM column](https://odm.discourse.group/t/dealing-with-multiple-values-when-mapping-from-multivalued-source-to-singlevalued-odm-column/181)
**Author:** [@martinwellman](https://odm.discourse.group/u/martinwellman)\ **Replies:** 1\ **Last updated:** [October 8, 2026, 2:48pm UTC](https://odm.discourse.group/t/dealing-with-multiple-values-when-mapping-from-multivalued-source-to-singlevalued-odm-column/181 "2026-10-08T14:48:18Z")
When mapping from a source dataset to ODM there is often a case where the source dataset has a multivalued slot that we map to a singlevalued ODM slot. For example, when mapping from PHA4GE to ODM v2/v3, we map from “env… --- ## [New Wide Rules - AND vs OR, Tagging Related Attributes](https://odm.discourse.group/t/new-wide-rules-and-vs-or-tagging-related-attributes/186)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 3\ **Last updated:** [November 10, 2025, 2:52pm UTC](https://odm.discourse.group/t/new-wide-rules-and-vs-or-tagging-related-attributes/186 "2025-11-10T14:52:54Z")
@martinwellman has been working hard on building out the tool to automate transformation from wide to long data in ODM. For this process we’ve been using example data from the EU4S program, which use a ODM wide format. T… --- ## [Duplication in Mapping](https://odm.discourse.group/t/duplication-in-mapping/182)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 0\ **Last updated:** [July 21, 2025, 5:49pm UTC](https://odm.discourse.group/t/duplication-in-mapping/182 "2025-07-21T17:49:15Z")
@martinwellman has been working on developing the mapping tool to move PHA4GE data into ODM format. The current alpha version is working well, and I’ve reviewed the outputs, and they are quite clean. Where we encounter … --- ## [Integrating Epi week and Year avg into Measure Table](https://odm.discourse.group/t/integrating-epi-week-and-year-avg-into-measure-table/178)
**Author:** [@asmabahamyirou](https://odm.discourse.group/u/asmabahamyirou)\ **Replies:** 7\ **Last updated:** [April 23, 2025, 5:11pm UTC](https://odm.discourse.group/t/integrating-epi-week-and-year-avg-into-measure-table/178 "2025-04-23T17:11:59Z")
Hi, We would like support to ingest epi week and year average data into Measure Table. The table looks like the following: Location (site/City or PT) EpiYear EpiWeek Week Start Measure Value Toronto Ashbridges… --- ## [Additional fields? Or how best to capture diverse European data](https://odm.discourse.group/t/additional-fields-or-how-best-to-capture-diverse-european-data/175)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 9\ **Last updated:** [February 20, 2025, 8:54pm UTC](https://odm.discourse.group/t/additional-fields-or-how-best-to-capture-diverse-european-data/175 "2025-02-20T20:54:50Z")
The data structure that @Sorin has created for European Data based off the ODM is great and maps with relative ease. There are (of course) a few sticky areas. Wide format problems: There are five fields which Sorin has… --- ## [Wide-naming exceptions - when one value is pre-populated](https://odm.discourse.group/t/wide-naming-exceptions-when-one-value-is-pre-populated/174)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 1\ **Last updated:** [January 30, 2025, 5:44pm UTC](https://odm.discourse.group/t/wide-naming-exceptions-when-one-value-is-pre-populated/174 "2025-01-30T17:44:37Z")
Hey folks - I’m working on generating some wide names for the current structure for how the European Wastewater Observatory will ingest wastewater surveillance data from member states. Shout out to @Sorin for making this… --- ## [Data Quality Flag for Mapped data?](https://odm.discourse.group/t/data-quality-flag-for-mapped-data/171)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 3\ **Last updated:** [December 19, 2024, 9:36pm UTC](https://odm.discourse.group/t/data-quality-flag-for-mapped-data/171 "2024-12-19T21:36:51Z")
I bit of a one-off thought, but I was wondering what people thought about creating a data quality flag for mapped data. The idea came to me because as I have been developing the “translation keys” for mapping between th… --- ## [Protocol Relationship: V1 \<--\> V2](https://odm.discourse.group/t/protocol-relationship-v1-v2/170)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 4\ **Last updated:** [November 4, 2024, 2:25pm UTC](https://odm.discourse.group/t/protocol-relationship-v1-v2/170 "2024-11-04T14:25:52Z")
@martinwellman has been working hard on harnessing some of the existing infrastructure for linkml and their “linkml-map” library to do mapping from ODM to and from other data models. It has been quite successful, and has… --- ## [Geotype - WKT - Polygons](https://odm.discourse.group/t/geotype-wkt-polygons/169)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 1\ **Last updated:** [October 4, 2024, 4:17am UTC](https://odm.discourse.group/t/geotype-wkt-polygons/169 "2024-10-04T04:17:55Z")
It was brought up today at the working group meeting that it might be beneficial to have the geotype header in the polygons table standardized. Currently, the only two geography types that can be specified are “sewer sh… --- ## [NWSS Major Lab Method - Comparable Field](https://odm.discourse.group/t/nwss-major-lab-method-comparable-field/154)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 1\ **Last updated:** [May 16, 2024, 10:17pm UTC](https://odm.discourse.group/t/nwss-major-lab-method-comparable-field/154 "2024-05-16T22:17:00Z")
This is a topic that has been brought up at a few times in the last two working group meetings, but it centres around how best to map the “major\_lab\_method” field in NWSS to the ODM, and/or whether a similar field should… --- ## [Clinical Data in the ODM](https://odm.discourse.group/t/clinical-data-in-the-odm/146)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 2\ **Last updated:** [February 14, 2024, 6:13pm UTC](https://odm.discourse.group/t/clinical-data-in-the-odm/146 "2024-02-14T18:13:04Z")
A user requested support with integrating COVID-19 case counts and hospitalization data into the larger wastewater/environmental surveillance database that is in ODM format. They were wanting to integrate the data in a w… --- ## [NWSS to ODM Mapping - Issues & Questions](https://odm.discourse.group/t/nwss-to-odm-mapping-issues-questions/130)
**Author:** [@matthomson](https://odm.discourse.group/u/matthomson)\ **Replies:** 3\ **Last updated:** [June 19, 2023, 10:04pm UTC](https://odm.discourse.group/t/nwss-to-odm-mapping-issues-questions/130 "2023-06-19T22:04:47Z")
I have a good chunk of the work and the planning now done for how mapping would be done from NWSS to ODM, though acquiring NWSS-formatted data to test this is still on my to-do list. With that said, here is a a (non-exh…