Skip to content

TimKroeger13/GERMA

Repository files navigation

GERMA - Geothermal Energy Resource Mapping and Analysis

GERMA is a software tool developed as part of a master's thesis at the Technical University of Berlin under the supervision of GASAG Solution Plus within the Urban Ground Heat project [1] (FKZ: 03EN3066).

image

Example view of the GERMA tool user interface

Public Data

GERMA enables automated geothermal potential analysis for borehole heat exchangers (BHE) for any area in Berlin. The tool utilizes publicly available geological and geothermal parameters provided through the geoportal [2] of the City of Berlin - Senate Department for Urban Development, Building and Housing (SenStadt).

All relevant geodata is automatically transferred to an internal database at regular intervals to minimize latency during data transmission. The transferred geometries are indexed using an R-tree structure to reduce database query times. The database is implemented using a PostgreSQL in combination with the PostGIS extension for managing geodata.

Determination of Usable Areas

To perform demand-based analysis in real-time, GERMA first determines the usable area of a selected region. Users can either select existing land parcels or interactively draw custom areas as polygons.

The usable area is defined as the area available for geothermal drilling for borehole heat exchangers, taking into account specified distances from property boundaries, buildings, and tree crowns. Subsequently, areas smaller than 15.88 m² are filtered out (This corresponds to the minimum area of an equilateral triangle with 6 m side length and represents a theoretical minimum probe arrangement with three BHEs). The remaining areas thus represent the zones where borehole heat exchanger fields can be realized.

Underground garages are taken into account, as their locations are recorded in the city of Berlin's ALKIS building data. However, whether drilling equipment can access inner courtyards through sufficiently wide driveways must be assessed by the user and is not automatically verified by the GERMA tool.

image

Calculation of usable areas - example with 2m distance to buildings and 3m distance to property boundaries. Graphic from [3]

Modeling of BHE Fields

The determined usable areas are then used to model a theoretical borehole heat exchanger field (BHE field). For this purpose, an algorithm developed in the associated master's thesis for optimizing probe positions is applied to the respective areas [3].

The algorithm iteratively generates a BHE field in the form of a multipolygon structure with the most compact area coverage possible. This results in an orderly, technically feasible arrangement of borehole heat exchangers, on the basis of which the thermal extraction capacity can subsequently be determined.

image

Step-by-step visualization of the area-minimizing point positioning algorithm for multipolygon structures. Graphic from [3]

BHE_plaement

Animated visualisation

Determination of Heat Extraction

To determine the specific heat extraction that can be provided by the modeled BHE field, reference BHE fields for various thermal conductivities were designed based on VDI 4640 Part 2 [4] and using the Earth Energy Designer (EED) program [5]. Based on these reference fields, approximation formulas were developed. These formulas calculate the specific extraction capacity per probe meter, taking into account the mutual thermal influence within a compact borehole heat exchanger field. For evaluating a BHE field with complete regeneration, the calculated specific extraction value of a single probe (according to VDI 4640) is extrapolated to the entire BHE field. The simulations can also consider thermally enhanced grouting material (thermal conductivity 2.0 W/(m·K)) and different flow conditions.

Simulation Parameters

The following initial parameters were defined for simulating the geothermal potential of borehole heat exchanger fields:

Parameter Value
Probe type Da 32 Double-U, PE100 RC
Ground temperature constant 11°C
Heat carrier Monoethylene glycol (25%)
Flow behavior laminar / turbolent
Probe spacing 6 m
Simulation period 25 years
Design 2400 full load hours
Temperature boundary condition of heat carrier at probe inlet -3°C

Groundwater flow in the respective investigation areas is not considered. The assumed drilling depth corresponds to the legally permissible drilling depth at the respective location, which is determined by limiting clay layers such as the Holstein layer or the Rupel clay layer [6].

The usable drilling depth was determined based on the "3D Geological Model of Berlin – Germany" [7] created by the Helmholtz Centre for Georesearch (GFZ). The respective thermal conductivities at the corresponding depths were taken from the Berlin Geoportal [8]. For depths greater than 100 m, where no values are specified, a thermal conductivity of 2.4 W/(m·K) is assumed, as water-saturated unconsolidated rocks commonly occur at these depths, for which an average thermal conductivity of this magnitude is plausible [9]. The thermal conductivities is proportionally calculated depending on their thickness.

image

Specific extraction performance for different BHE field sizes with various subsurface thermal conductivities. Data points based on VDI 4640 Part 2 [4] and EED [5] simulations

Determination of Demand Coverage

To compare the heat demand of buildings on the considered property with the geothermal heat that can be provided by the BHE field, the individual coverage of heat demand is calculated for each modeled BHE field.

For determining the expected annual heating work, data from "Energymap" [9] was used, which enables building-specific, AI-based estimation of annual heat demand. The Energymap data is integrated into GERMA via an API. By specifying a seasonal performance factor (SPF) of the heat pump, the proportion of heat demand that can be covered by the BHE field can then be calculated.

Codebase

The complete source code of GERMA is publicly available on GitHub at "TimKroeger13/GERMA: Geothermal Energy Resource Mapping and Analysis" and is published under the MIT License. The schema of the required database tables is also documented in the repository. Currently, a live version of the GERMA application runs on internal servers of GASAG Solution Plus and is therefore not publicly accessible.

image

Example of modeled BHE fields for multiple buildings

References

  1. Fraunhofer IEG. UrbanGroundHeat – Wärmewende in urbanen Bestandsquartieren [Internet]. Available from: https://www.ieg.fraunhofer.de/de/projekte/urbangroundheat.html. Accessed: 2024-06-20.

  2. Senatsverwaltung für Stadtentwicklung, Bauen und Wohnen. Geoportal Berlin [Internet]. Available from: https://gdi.berlin.de/viewer/main/. Accessed: 2025-11-20.

  3. Kröger T. Web-Based Geothermal Energy Potential Mapping and Analysis for Berlin: Estimating the shallow geothermal energy potential of Berlin [Master's Thesis]. Berlin: Technical University of Berlin; 2023. Available from: https://tkroeger.com/websites/masterarbeit.pdf. Accessed: 2025-11-24.

  4. Verein Deutscher Ingenieure. Thermische Nutzung des Untergrunds – Erdgekoppelte Wärmepumpenanlagen (VDI 4640). Berlin: Beuth Verlag; 2019.

  5. Building Physics. EED – Earth Energy Designer, Version 4.24 [Software]. Available from: https://buildingphysics.com/eed-2/. Accessed: 2024-06-08.

  6. Senatsverwaltung für Mobilität, Verkehr, Klimaschutz und Umwelt. Erdwärmenutzung in Berlin: Merkblatt für Erdwärmesonden und Erdwärmekollektoren mit einer Heizleistung bis 30 kW außerhalb von Wasserschutzgebieten. Berlin: Senatsverwaltung für Mobilität, Verkehr, Klimaschutz und Umwelt; 2025.

  7. Frick M, Bott [Sippel] J, Scheck-Wenderoth M, Cacace M, Haacke N, Schneider M. 3D geological model of Berlin – Germany [dataset]. 2020. Available from: https://doi.org/10.5880/GFZ.4.5.2020.005

  8. Segbers S, Küster-Inderfurth A, Nytsch-Geusen C. Revolutionizing Heating Planning: A Data-Driven Approach for Accurate and Scalable Energy Consumption Predictions. In: BauSim Conference 2024; IBPSA-Germany and Austria; 2024; Vol. 10. Verfügbar unter: https://energymap-berlin.de/en/. Zugriff am: 2025-10-22.

  9. Segbers S, Küster-Inderfurth A, Nytsch-Geusen C. Revolutionizing Heating Planning: A Data-Driven Approach for Accurate and Scalable Energy Consumption Predictions. In: BauSim Conference 2024; IBPSA-Germany and Austria; 2024; Vol. 10. Verfügbar unter: https://energymap-berlin.de/en/. Zugriff am: 2025-10-22.

License

MIT License


Notes for Creation

Scaffolding Request

Database scaffolding:

dotnet ef dbcontext scaffold "Host=localhost:5433;Database=germa;Username=germa;Password=germa" Npgsql.EntityFrameworkCore.PostgreSQL --no-onconfiguring --output-dir DataModel/Database --force --context DataContext --namespace GERMAG.DataModel.Database --startup-project Server --project Shared

Http Staus Codes:

Error Codes

Code Definition
429 To many Requests
512 Requested location is outside the covered area
513 Not Enough space is given to place BHE in the given requested area
514 The selected locations are not connected by a landparcel
515 Could not connect to Server
516 To much requests for the short-report. Rate is limited
517 To much requests for the full-report. Rate is limited
518 To much requests for the User assignment. Rate is limited

About

Geothermal Energy Resource Mapping and Analysis

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published