Exchange of scientific data and metadata between single users or organizations is a challenging task due to differences in data formats, the genesis of data collection, ontologies and prior knowledge of the users. Different data storage requirements, mostly defined by the structure, size and access scenarios, require also different data storage solutions, since there is no and there cannot be a data format which is suitable for all tasks and needs that occur especially in a scientific workflow. Besides data, the generation and handling of additional corresponding metadata leads us to the additional challenge of defining the "meaning" of data, which should be formulated in a way that it can be commonly understood to get out a maximum of expected and shareable information of the observed processes. In our domain we are able to take advantage of standards defined by the Open Geospatial Consortium, namely the standards defined by the Sensor Web Enablement, WaterML and CF-NetCDF working groups. Even though these standards are freely available and some of them are commonly used in specialized software packages, the adaption in widespread end-user software solutions still seems to be in its beginnings. This contribution describes a software solution developed at Graz University of Technology, which targets the storage and exchange of measurement data with a special focus on meteorological, water quantity and water quality observation data collected within the last three decades. The solution was planned on basis of long-term experience in sewer monitoring and was built on top of open-source software only. It allows high-performance storage of time series and associated metadata, access-controlled web services for programmatic access, validation tasks, event detection, automated alerting and notification. An additional web-based graphical user interface was created which gives full control to end-users. The OpenSDM software approach makes it easier for measurement station operators, maintainers and end-users to take advantage of the standards of the Open Geospatial Consortium, which usage should be promoted in the water related communities.
Camhy, David; Gruber, Günter; Steffelbauer, David; Hofer, Thomas; and Muschalla, Dirk, "OpenSDM - An Open Sensor Data Management Tool" (2014). CUNY Academic Works.