INSPIRE conform Borehole Data Provision in the Federal Republic of Germany based on BoreholeML (BoreholeML2INSPIRE)

Country / Region: Federal Republic of Germany

Begin of project: December 1, 2018

End of project: May 31, 2020

Status of project: August 13, 2019

INSPIRE Logo Source: https://inspire.ec.europa.eu/

The European INSPIRE directive demands all data on boreholes of the European countries including those from Germany until the 10.21.2020. The data needs to be provided in compliance with the INSPIRE Data Specification on Geology. This means in details that the data needs to be European-wide freely available as a view service (digital map of the boreholes) as well as a download service. The BGR was commissioned by the GSO (Geological Survey Organisations) to execute this task.

The previous project “Interoperable borehole Data on the Nation-wide Geoportal” achieved a national wide data harmonisation of borehole data from the respective source format (e.g. SEP3) of the GSO to the Borehole Markup Language Version 3. In this project, the data needed to be brought together at a central location. Consequently, the BGR developed in cooperation with the GSO a solution to unite the INSPIRE relevant borehole data at the BGR as a physical copy in the BoreholeML format. The collection of the data shall be achieved by implementing a Harvesting Process. For this purpose, a program is currently being developed requesting the standardised WFS (Web Feature Service) interface of each individual GSO in order to download the Data in the XML format and to store it in the internal BGR database.

BGR Borehole Harvester Source: BGR

Afterwards, the borehole data is transformed to the INSPIRE target format. Initially, the mapping rules are defined. The attributes in the INSPIRE target format can be identical as those in BoreholeML or different. A team of experts defines the mapping rules as a preparation for the subsequent technical mapping (transformation). The execution of the transformation is realised with the program (FME) which is capable to transform the XML in a GML for the INSPIRE Download Service on the one hand and, on the other hand to create a geodatabase for the View Service.

BGR Transformation Process Source: BGR

After the successful transformation to the INSPIRE conform GML target format, a final Download Service (ATOM) is created. Parallel to this, a View Service of the drill point map is provided.

Literature:

• INSPIRE Data Specifications Annex 2 Geology
• Official website of the data standard Borehole Markup Language (BoreholeML)

Partner:

Geological Survey Organisations (GSO) - Staatliche Geologische Dienste (Deutschlands)

• Regierungspräsidium Freiburg
  Abt. 9: Landesamt für Geologie, Rohstoffe und Bergbau (RPF-LGRB)
• Bayerisches Landesamt für Umwelt
  Abt. 10: Geologischer Dienst, Wirtschaftsgeologie, Bodenschutz (LfU)
• Senatsverwaltung für Umwelt, Verkehr und Klimaschutz
  - Landesgeologie II B 3
  www.berlin.de/senuvk/umwelt/wasser/geologie/index.shtml
• Landesamt für Bergbau, Geologie und Rohstoffe Brandenburg (LBGR)
• Geologischer Dienst für Bremen (GDfB)
• Freie und Hansestadt Hamburg, Behörde für Umwelt und Energie, Geologisches Landesamt Hamburg
  www.hamburg.de/geologie
• Hessisches Landesamt für Umwelt und Geologie,
  Abt. Geologie und Boden, Geologischer Landesdienst (HLUG)
• Landesamt für Umwelt, Naturschutz und Geologie Mecklenburg-Vorpommern (LUNG)
• Landesamt für Bergbau, Energie und Geologie (LBEG)
• Landesamt für Umwelt- und Arbeitsschutz (LUA)
• Sächsisches Landesamt für Umwelt, Landwirtschaft und Geologie,
  Abteilung 10 Geologie (LfULG)
• Landesamt für Geologie und Bergwesen Sachsen-Anhalt (LAGB)
• Landesamt für Landwirtschaft, Umwelt und ländliche Räume Schleswig-Holstein,
  Abt. Geologie und Boden (LLUR)
• Thüringer Landesamt für Umwelt, Bergbau und Naturschutz
  Abt. 8: Geologie, Bergbau (TLUBN)