CSV template for structuring water management measurement data

#water quality data #template #csv #standardisation #best practice
Photo of a print of the csv template
© Christian Malewski, Wupperverband

The CSV template allows heterogeneous, water management measurement data and their metadata to be brought into a uniform structure. This enables the creation of a standardised database and simplifies the further processing and analysis of the data.

Measurement programs in research projects or routine operations often involve several sources of data. The measurement data are collected with specialised equipment and are then available in heterogeneous files.

Often, not only the structure of the measurement data and its metadata, but also the naming of the measurement parameters and units, the decimal separation and the geographical and temporal reference systems are different. The aim is to bring all data of the measurement program into a structure that is as uniform as possible in order to standardise access and analysis of the information.

For this purpose, the Open Geospatial Consortium proposes standard models that either require a high level of training or cannot cover the complexity of water management data.

This CSV template specifies the structure for water management data and their metadata. It is not only possible to structure one-dimensional data, but also to map depth and height profiles, as well as measurement trajectories with the associated, essential metadata.

In the MuDak-WRM joint project, the collected measurement and model result data were successfully merged using this template and then stored in a relational database. This made manual or automatic further processing possible.

Water resource: Surface water
Type of product:
  • Standards & regulations
Application sector: Cities and municipalities, Natural water environment, Water resource management
Funding measure: GRoW
Project: MuDaK-WRM

Contact and partners


  • Wupperverband,
  • Untere Lichtenplatzer Str. 100,
  • 42289 Wuppertal
http://www.wupperverband.de

52°North Initiative for Geospatial Open Source Software GmbH,
Münster

This site uses third-party website tracking technologies to provide its services. I agree to this and can revoke or change my consent at any time with effect for the future.