[DEMIS2SORMAS] Map Regions and Districts

FredrikSchaefer commented 3 years ago

Presiquisite: https://github.com/hzi-braunschweig/SORMAS-Project/issues/3254

Situation Description

A DEMIS-Notification includes information about two health departments.

The Gemeindekennziffer of the health department responsible for the place of residence ("Wohnort") of the affected person. This can be found in the Bundle.meta.tag.ResponsibleDepartment. It shows as "Zuständiges Gesundheitsamt".
The "Gemeindekennziffer" of the health department responsible for the region where the report takes place. This can be found in the Bundle.meta.tag.ResponsibleDepartmentSubmitter. It relates to "Gesundheitsamt des Einsenders" in the HTML representation of a labMessage.

Feature Description

[ ] Make sure that the information above is correct. This includese checking whether the entries in the Bundle really relate to the mentioned parts in the HTML representation, as well as checking if we really get the "Gemeindekennziffer" as values. In the test data, mostly values like 1.test-oegd08 show up.
[ ] Map 1. to region and district when a new contact, case or event participant is created while processing a labMessage
[ ] Map 2. to responsible region and responsible district when a new case is created while processing a labMessage

Additional Information

This mapping has a downside, it is confusing: In SORMAS, there seems to be a region for a case, which refers to the case persons place of residence ("Wohnort"). Then, there is responsible region in SORMAS, which relates to a region that is not the case persons place of residence, but still responsible. According to the german IfSG, foremost the health department of the persons place of residence ("Wohnort") is supposed to be responsible. Thus, we map what is mostly called responsible department in DEMIS to something explicitly not called responsible region (but just region), while we map something explicitly not called responsible department (but submitting department) in DEMIS to something called responsible region in SORMAS. The same is true for district.

Open Questions

How to relate the Gemeindekennziffer or whatever equivalent is contained in a DEMIS-Notification to Districts and Regions?

FredrikSchaefer commented 3 years ago

Statements from RKI indicate that currently the Gesundheitsamtskennung(alias SurvNet-Code) which is based on the Kreiskennziffer is used instead of the Gemeindekennziffer, but they are working on also allowing the Gemeindeschlüssel (which hopefully is the same as the Gemeindekennziffer). A webservice to determine the Gemeindeschlüssel of a health department is in development right now.

FredrikSchaefer commented 3 years ago

To intensify the confusion: In some DEMIS-notifications from a test server, there are three health departments specified. with the according XML:


   <meta>
      <lastUpdated value="2021-02-11T16:45:32.654+01:00"/>
      <profile value="https://demis.rki.de/fhir/StructureDefinition/NotificationBundleLaboratory"/>
      <tag>
         <system value="https://demis.rki.de/fhir/CodeSystem/ResponsibleDepartment"/>
         <code value="1.test-oegd08"/>
      </tag>
      <tag>
         <system value="https://demis.rki.de/fhir/CodeSystem/ResponsibleDepartmentSubmitter"/>
         <code value="1.test-oegd08"/>
      </tag>
      <tag>
         <system value="https://demis.rki.de/fhir/CodeSystem/ResponsibleDepartmentNotifier"/>
         <code value="1.test-oegd03"/>
      </tag>
      <tag>
         <system value="https://demis.rki.de/fhir/CodeSystem/ResponsibleDepartmentPrimaryAddress"/>
         <code value="1.test-oegd08"/>
      </tag>
   </meta>

JaquM-HZI commented 3 years ago

We discussed the community part: @FredrikSchaeferVitagroup sormas_gemeinden_master.xlsx

ndevln commented 3 years ago

Hi,

for Berlin the Gemeindekennziffer and Kreiskennziffer are the same. Berlin uses Lebensweltlich orientierte Räume (LOR) instead. These are already implemented in SurvNet and are stored in [Data].[AdditionalAttribute] with [AttributeName] = 'PLZ-LOR'. The corresponding XML entry in the export file looks like this:

<Group Name="AdditionalAttribute"><Field Name="AttributeName" Value="PLZ-LOR" /><Field Name="AttributeValue" Value="<AttributeValue><TextItem Name="PLZ" Label="PLZ" Sort="1" Max="20" Value="11111" /><TextItem Name="LOR" Label="LOR" Sort="2" Max="20" Value="11111111" /></AttributeValue>" /></Group>

or without replaced HTML entities:

<Group Name="AdditionalAttribute"><Field Name="AttributeName" Value="PLZ-LOR" /><Field Name="AttributeValue" Value="&lt;AttributeValue&gt;&lt;TextItem Name=&quot;PLZ&quot; Label=&quot;PLZ&quot; Sort=&quot;1&quot; Max=&quot;20&quot; Value=&quot;11111&quot; /&gt;&lt;TextItem Name=&quot;LOR&quot; Label=&quot;LOR&quot; Sort=&quot;2&quot; Max=&quot;20&quot; Value=&quot;11111111&quot; /&gt;&lt;/AttributeValue&gt;" /></Group>

The 8-digit LOR number can be generated from coordinates or from the address and are available here: https://www.stadtentwicklung.berlin.de/planen/basisdaten_stadtentwicklung/lor/de/download.shtml

Currently, the 2019 version is still being used because no demographic information is available for the current version (2021).

Could this be implemented in Sormas and exported to SurvNet for Transmission? I am happy to provide more details.

Greetings, Alex

SORMAS-Foundation / SORMAS-Project