Data Management for the App UmweltNAVI of the Federal State of Lower Saxony in Germany

The App UmweltNAVI Niedersachsen (see the poster in session "4.10" or https://umwelt-navi.info/) communicates geospatial data to a broad user community of education, individuals or experts. In order to adequately present the data in a mobile context, the data must be harmonized, transformed, and combined with other sources. To achieve this, an infrastructure was created that allows editors to integrate data sources and enrich them with information. For example, Web Feature Services, ESRI Shapefiles, SensorThings APIs (STA) are under the data sources. A GUI-guided transformation process enables the mapping of raw data to the harmonized data schema. For the presentation, complex data is simplified, data reconciliation with additional data sources (i.e. Wikipedia or Observation.org) is performed, and the resulting data is stored in a scalable backend. Currently, the database contains 1.8 million records from 57 regional and national data sources and 178,000 images.
Only open source or freely usable software components are used, such as Elasticsearch, Postgres/PostGIS, Airflow or Directus. The delivery layer is designed redundantly for high-performance, fail-safe operation.
A standards-compliant interface (OGC-API Feautures) is being planned to provide access to the data for further processing.
The project was initiated by the Lower Saxony Ministry for the Environment, Energy and Climate Protection in Germany and was implemented together with the companies Bearingpoint and wemove digital solutions. The principle of presenting geodata can also be applied to other areas. The software is basically available for subsequent use.