Multimedia Knowledge and Social Media Analytics Laboratory

Environmental Data Storage and Retrieval Service

The Environmental Data Storage and Retrieval Service is a software, which supports storage, spatiotemporal indexing and retrieval of environmental information (e.g. air quality and weather forecasts, observations, historical data) as this is provided by nodes (e.g. sensors, stations, websites) that contain environmental measurements (e.g. weather conditions, air quality, pollen).

This implementation follows the Sensor Observation Service (SOS) 1.0 standard and builds upon 52°North SOS. This service has been implemented in the context of the  European project PESCaDO, which deals with personalized orchestration and delivery of environmental information.



This code is based on 52°North SOS implementation and is extended in order to be able to cover the specific needs of the Data Retrieval Service (DRS) created within the context of  PESCaDO European Project. Despite the changes in both the code and the underlying database schema, the updated SOS service remains SOS1.0 compliant.

In general SOS (Sensor Observation Service) standard is applicable to use cases in which sensor data needs to be managed in an interoperable way. This standard defines a Web service interface which allows querying observations, sensor metadata, as well as representations of observed features. It also defines means to register new sensors and to remove existing ones and operations to insert new sensor observations. More information can be found here.

A brief overview of the supported SOS 1.0.0 operations implemented by 52North can be found here.

Regarding the main changes that were realized to cover PESCaDO needs, they can be summarized in the following points:
•    One aspect (e.g. O3) can take several type of values (string, float)
•    Different type of measurements with regard to the time the data refer to (i.e observed, forecast or historical values)
•    Different type of aggregation used for historical measurements, e.g. minimum, maximum or average value)
•    Time needs to capture not only a simple time instant which is the case in observed measurements), but also a time period (e.g. time start and time end) when forecast or historical values are measured.
•    More information needs to be captured for data nodes (sensors)

More information regarding the changes realized can be found in the document Short_Description_of_Changes.docx found inside the rar file.



1. Download the rar archive here.

2. Unzip the archive. The code exists under the folder 52N-SOS-3.1.1 and there is a detailed installation guide in the file how2install_SOS.pdf which can be found under 52N-SOS-3.1.1\doc\howto folder.

3. The datamodel.sql file contains sql create and insert queries that result in the creation of the database schema.

4. The testDB.sql file contains an example set of records of the schema model tables.

Note that in order to be able to build the source code Maven is required and for using it Tomcat and Postgres with PostGIS are required



This program is free software; you can redistribute and/or modify it under the terms of the GNU General Public License version 2 as published by the Free Software Foundation.

This program is distributed WITHOUT ANY WARRANTY; even without the implied WARRANTY OF MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. There is a copy of  the GNU General Public License along with this program  (under 52N-SOS-3.1.1\gnu-gpl v2.txt folder)



This work was supported by the EU FP7 project PESCaDO (FP7-248594).



You may contact Anastasia Moumtzidou (moumtzid AT iti DOT gr) for any question or remark you may have with respect to this tool.