**3.3 LabICT and Data Management Center**

In a previous research phase, a prototype of a unified Data Management Center (DMC) was internally carried out at Lepida SpA R&D Laboratory, in order to receive data, normalize and validate them depending on operation thresholds according to their type and brand. A further analysis of data also allowed a cross-checking of different sensors to trigger alarms for values exceeding from defined thresholds, or for failures. An initial authentication foresaw a base profiling that determined primarily two types of users: basic and operator. for the basic one, thanks to a web interface, a real-time graph with the last samples gathered could be visualized, an historic archive including all measurement done could be consulted and these values could be sent, in a graphic format or through a pdf table, to an e-mail address. Moreover a map showed the location of the stations and the BlackBoxes installed all over the regional territory; for the operator one, in addition to the basic features, this type of user could

• Modularity: each block is independent and communicates through the exchange of XML

Environmental Monitoring Supported by the Regional Network Infrastructures 397

• Configurability: main operating parameters could be defined in a database, including the

All sensors have been schematized in a hierarchical way so that multiple sensors may depend, whether or not, on a BlackBox, which can be connected to another unit, too, for example proprietary stations. Each one of these elements is categorized as a sensor, this is because they are all able to send and receive signals, moreover each sensor can perform different types of measurement with different timing for the acquisition. Finally, measures may be punctual, aggregated or their avarage is calculated, depending on various time intervals. In addition to the tables dedicated to sensors management, the database also includes additional tables necessary to provide addresses, ticketing, alarms, profiling, logging. The Middleware, the Control Center and the Monitoring Center consist of opensource units (Figure 5): each one has its own characteristics, in order to satisfy all the features proposed and also maintain a huge flexibility, in fact each unit inside t he project is independent from the others. The whole managing of data within the Data Management Centre can be divided into three main phases, acquisition, processing, viewing, and this allows to describe each single functional unit. Heterogeneous data sources will be homogenized by the first standardizing unit and then the measures will be evaluated by the analysis unit that will validate them and will check all alarm thresholds. The alarm and diagnostic unit will be contacted by both units and manages and logs the events. Finally, the validated data will be displayed by the visualization unit through a web interface. Communications between two different units are done by using

This module is the interconnection and standardization middleware between the data and the central unit, therefore plays the role of collector and uniforms data sent from different sources

• Atomic modules for data retrieval: are used to retrieve the data, both automatically at a preset timeslot and on-demand, gathering data from various sources or databases. Inside each atomic unit the access procedure and the detailed commands used to retrieve data

• Atomic units manager: is always active and coordinates the required units. It also serves as a collector for messages sent by the individual atomic modules and redirects them through

• Communication unit: it allows the manager to communicate with other modules inside the platform, on one hand by collecting the total number of messages and errors from the manager, on the other hand receiving as input all requests sent by the DMC and directed

Output messages produced by this unit are: the standardized data subsequently stored on a centralized database, the notification messages that new data has been inserted in the database so that the proper unit could start to analyze them, errors and log messages that

storing them in the database of the DMC. It is based on the following elements:

the units of communication, alarming, diagnostics and data analysis.

• Scalability: each module can be implemented on different physical machines;

definition of new types of sensors, thresholds, alarms, and so on.

files;

Web Services.

**3.3.2 Data standardization unit**

to the manager.

from a specific source are specified.

are transmitted to the diagnostic unit.

insert new units and sensors pertaining to his entity or his partners. Finally he could define new alarm thresholds.

Although this system was quite complete, it had been implemented with the aim to show its potential in environmental monitoring and some features were in an embryonic stage of development. As a result of an increasing interest and a great satisfaction showed by the entities, at the end of the experimental phase, starting from this previous experience the prototype is evolved into a more complex and efficient solution taking advantage of the LabICT-PA (Laboratory for Information and Communication Technology for Public Administration). The LabICT-PA, created in 2007 by the Emilia Romagna region, is part of the Regional High Technology Network and aims to accelerate innovation in public administration. Since 2011 LabICT-PA is also a member of Europeean Network of Living Labs *ENoLL* (2011). The organizational model of LabICT-PA is based on the living labs, where the functional requirements and specifications are defined by and with the users, that is Public Administrations. Design and testing phases will be also carried out through a continuous dialogue with end users. The main partners and their roles in this living lab are: the Emilia Romagna Regional Government that determines the police through the ICT plan; Lepida SpA that, as in house providing company established by a regional law, coordinates activities and provides technical competences and effort; almost 400 public shareholders of Lepida SpA that represent end users; almost 100 business partners, called the club of stakeholders Lepida, that are the think tanks that create added value for PA and for the market; finally universities and research institutes serve as research partners for the laboratory. In this sensor networks context, LabICt-PA has created a fully working prototype, non-engineered, of data management center for sensor networks.

#### **3.3.1 Architecture**

Fig. 5. Data Management Center Architecture

This project aims to integrate all sensor networks deployed in the region through the implementation of a shared platform that could uniformly handle all kinds of environmental data. Firstly, the database of the previous prototype was completely revised to improve the management of the data, intended as a single measure detected by the sensor, making it the most generalized as possible. In fact, the main architectural features are:


All sensors have been schematized in a hierarchical way so that multiple sensors may depend, whether or not, on a BlackBox, which can be connected to another unit, too, for example proprietary stations. Each one of these elements is categorized as a sensor, this is because they are all able to send and receive signals, moreover each sensor can perform different types of measurement with different timing for the acquisition. Finally, measures may be punctual, aggregated or their avarage is calculated, depending on various time intervals. In addition to the tables dedicated to sensors management, the database also includes additional tables necessary to provide addresses, ticketing, alarms, profiling, logging. The Middleware, the Control Center and the Monitoring Center consist of opensource units (Figure 5): each one has its own characteristics, in order to satisfy all the features proposed and also maintain a huge flexibility, in fact each unit inside t he project is independent from the others. The whole managing of data within the Data Management Centre can be divided into three main phases, acquisition, processing, viewing, and this allows to describe each single functional unit. Heterogeneous data sources will be homogenized by the first standardizing unit and then the measures will be evaluated by the analysis unit that will validate them and will check all alarm thresholds. The alarm and diagnostic unit will be contacted by both units and manages and logs the events. Finally, the validated data will be displayed by the visualization unit through a web interface. Communications between two different units are done by using Web Services.

#### **3.3.2 Data standardization unit**

8 Will-be-set-by-IN-TECH

insert new units and sensors pertaining to his entity or his partners. Finally he could define

Although this system was quite complete, it had been implemented with the aim to show its potential in environmental monitoring and some features were in an embryonic stage of development. As a result of an increasing interest and a great satisfaction showed by the entities, at the end of the experimental phase, starting from this previous experience the prototype is evolved into a more complex and efficient solution taking advantage of the LabICT-PA (Laboratory for Information and Communication Technology for Public Administration). The LabICT-PA, created in 2007 by the Emilia Romagna region, is part of the Regional High Technology Network and aims to accelerate innovation in public administration. Since 2011 LabICT-PA is also a member of Europeean Network of Living Labs *ENoLL* (2011). The organizational model of LabICT-PA is based on the living labs, where the functional requirements and specifications are defined by and with the users, that is Public Administrations. Design and testing phases will be also carried out through a continuous dialogue with end users. The main partners and their roles in this living lab are: the Emilia Romagna Regional Government that determines the police through the ICT plan; Lepida SpA that, as in house providing company established by a regional law, coordinates activities and provides technical competences and effort; almost 400 public shareholders of Lepida SpA that represent end users; almost 100 business partners, called the club of stakeholders Lepida, that are the think tanks that create added value for PA and for the market; finally universities and research institutes serve as research partners for the laboratory. In this sensor networks context, LabICt-PA has created a fully working prototype, non-engineered, of data

This project aims to integrate all sensor networks deployed in the region through the implementation of a shared platform that could uniformly handle all kinds of environmental data. Firstly, the database of the previous prototype was completely revised to improve the management of the data, intended as a single measure detected by the sensor, making it the

most generalized as possible. In fact, the main architectural features are:

new alarm thresholds.

management center for sensor networks.

Fig. 5. Data Management Center Architecture

**3.3.1 Architecture**

This module is the interconnection and standardization middleware between the data and the central unit, therefore plays the role of collector and uniforms data sent from different sources storing them in the database of the DMC. It is based on the following elements:


Output messages produced by this unit are: the standardized data subsequently stored on a centralized database, the notification messages that new data has been inserted in the database so that the proper unit could start to analyze them, errors and log messages that are transmitted to the diagnostic unit.

Fig. 6. Data Management Center homepage

**4. Drainage consortium of western Romagna**

additional tabs are:

and so on.

using colors in agreement with those defined for the tree view icons. Clicking on a marker a description of the unit and a description of the sensors connected to it are shown. The

Environmental Monitoring Supported by the Regional Network Infrastructures 399

• Real-time monitoring: it provides a graphical and tabular representation of the last data sent by the sensors. The measures to be displayed can be selected through the tree view. The chart adapts its time scale according to a selection done in a drop down menu and then automatically updates itself every 5 seconds. In Figure 6, for example, a multiple real-time chart related to one inclinometer, the piezometer and one ARPA pluviometer is shown. • Analysis of historical data: in this tab, data could be analyzed with an historical depth that is greater than the one on the real time tab, selecting a start date and a period to display. It

• Logs viewing: provides a list in chronological order of all the significant events detected in relation to sensors failures (started or stopped), alerts (started or stopped), invalid values,

• Platform management: supplies some statistics about the current state of the system, for example the status of the various units involved and an overview of all detected events.

A Drainage Consortium is a public corporation that coordinates both public actions and private activites concerning the drainage of its territory of scope. For example, hydraulic

'can be downloaded locally both in a graphic and a tabular format.

#### **3.3.3 Data analysis unit**

Its purpose is to control the last data processed by the unit of standardization and to do periodic monitoring on the centralized database in order to trigger the following types of alarms:


When one of these alarms occurs, it is communicated to the alarm and diagnostic unit specifying which sensor has triggered the alarm event, the type of event and which alert message has been associated to the event, so that all information needed are forwarded to the dedicated unit, due to simplify and speed up its alarm procedures.

#### **3.3.4 Alarm and diagnostic unit**

In addition to alarms generated by the analysis unit, all units part of the system architecture could send error messages in case there is a generic malfunctioning in the DMC such as database connection errors, query failed, units that are not working and so on. The diagnostic unit is implemented using a web service SOAP and handles all the incoming XML requests storing and logging them properly. If they are associated with one or more alarm procedures the unit sends the warning message to one or more users by an email, an SMS or an SDS on a Tetra terminal. Finally, the unit manages generic events that could be scheduled at certain timeslots and which may be linked to the linear chart of a sensor so that when a value exceeds from its alarm, an e-mail should be sent not only including a warning message but also with the graph related to the sensor involved as attachment, due to have a visual feedback of the current situation.

#### **3.3.5 Data visualization unit**

This unit is based on a web site consisting of several forms that allow the user to query and monitor the various data structures included into the DMC. All the forms have been integrated into a single portal and are made up of different tabs, available on the main screen of the site. A tree view in the left side of the web site represents all the system control stations and sensors connected to them, then each sensor will match one or more type of measures. This tree is generated according to the initial login: in fact an association is possible between a profile and a user, that specifies which sensors he could visualize. The icons of the tree have different colours to provide visual indications about the status of each sensor: green if the sensor works correctly, red in case of alert, yellow in case of failure and gray if is disabled. The tree view allows the selection of multiple components. A geo-referenced map of the region is also provided in the homepage and the markers shown on it indicate the stations installed 10 Will-be-set-by-IN-TECH

Its purpose is to control the last data processed by the unit of standardization and to do periodic monitoring on the centralized database in order to trigger the following types of

• Failures: they occur in two cases, when the unit detects that a certain sensor does not send values in a timeslot that is longer than the sampling rate specified for that sensor, or when the measure is not performed correctly in respect to the working range of the sensor. • Alerts: several alert situations can be assigned to a unique measure and they may depend on the overcoming of a minimum or maximum threshold, or on an excessive increase or decrease of the measure compared to the previous value stored. The amount of subsequent occurrences of the same state of alert, that must be verified before triggering the proper

• Simplex: this event is triggered as a result of the simultaneous testing of multiple alarm conditions. In a unique simplex both alerts and failures could be associated, linked together by logical operators (and, or, not) so that an event could be characterized by

When one of these alarms occurs, it is communicated to the alarm and diagnostic unit specifying which sensor has triggered the alarm event, the type of event and which alert message has been associated to the event, so that all information needed are forwarded to

In addition to alarms generated by the analysis unit, all units part of the system architecture could send error messages in case there is a generic malfunctioning in the DMC such as database connection errors, query failed, units that are not working and so on. The diagnostic unit is implemented using a web service SOAP and handles all the incoming XML requests storing and logging them properly. If they are associated with one or more alarm procedures the unit sends the warning message to one or more users by an email, an SMS or an SDS on a Tetra terminal. Finally, the unit manages generic events that could be scheduled at certain timeslots and which may be linked to the linear chart of a sensor so that when a value exceeds from its alarm, an e-mail should be sent not only including a warning message but also with the graph related to the sensor involved as attachment, due to have a visual feedback of the

This unit is based on a web site consisting of several forms that allow the user to query and monitor the various data structures included into the DMC. All the forms have been integrated into a single portal and are made up of different tabs, available on the main screen of the site. A tree view in the left side of the web site represents all the system control stations and sensors connected to them, then each sensor will match one or more type of measures. This tree is generated according to the initial login: in fact an association is possible between a profile and a user, that specifies which sensors he could visualize. The icons of the tree have different colours to provide visual indications about the status of each sensor: green if the sensor works correctly, red in case of alert, yellow in case of failure and gray if is disabled. The tree view allows the selection of multiple components. A geo-referenced map of the region is also provided in the homepage and the markers shown on it indicate the stations installed

signaling to the unit of alarms and diagnostics, could be also specified.

critical conditions based on multiple sensors in very complex relationships.

the dedicated unit, due to simplify and speed up its alarm procedures.

**3.3.3 Data analysis unit**

**3.3.4 Alarm and diagnostic unit**

current situation.

**3.3.5 Data visualization unit**

alarms:

Fig. 6. Data Management Center homepage

using colors in agreement with those defined for the tree view icons. Clicking on a marker a description of the unit and a description of the sensors connected to it are shown. The additional tabs are:


#### **4. Drainage consortium of western Romagna**

A Drainage Consortium is a public corporation that coordinates both public actions and private activites concerning the drainage of its territory of scope. For example, hydraulic

thirty minutes; every poll requires about 300 bytes for each data logger. Besides the polling scheduled activity, the central monitoring system has also the possibility of directly poll a specific data logger at any instant, for example in case of emergency; in this case the polled

Environmental Monitoring Supported by the Regional Network Infrastructures 401

The effort of Lepida SpA has been addressed to the communication technology used by the described system. In particular by offering the opportunity of exploiting the regional tetra radio infrastructure of the *ERretre* network as a data transportation driver. This represents for the Consortium an opportunity of economic and resource saving, by replacing the old analog radio with the modern digital tetra radio. Furthermore the *ERretre* network can offer other fundamental advantages: it can guarantee a full coverage inside the whole regional territory, allowing also intercommunications among the devices of different Drainage Consortiums in Emilia-Romagna region; it can offer guaranteed communications, avoiding the congestion events that instead may occur in a GSM network. Another role of Lepida will be the support in defining the technical specifics for a future furnishing of digital tetra radio to be used in a

The test bed activated in collaboration with the Drainage Consortium of the Western Romagna

Fig. 8. System architectures tested in collaboration with the Drainage Consortium of the

The test bed has been conducted through two phases. The first one has been realized at Lepida Spa R&D Laboratories, by implementing two different architectures, illustrated in Figures 8, which leads to two different network performances. In architecture *(a)* both the data logger and the monitoring system are connected to two tetra radio modem: in this case any data

Western Romagna

exploits the *ERretre* network, with single slot packet data communication policy.

data logger will send the data collected since the last polling.

long-term solution when the test-bed stage will be definitely ended.

Fig. 7. Drainage Consortiums in Emilia-Romagna region

security, management of the waters intended to the irrigation, involvement into urban planning, environmental and agricultural heritage protection can be considered typical activites and actions covered by a Drainage Consortium.

In Emilia-Romagna region eight Drainage Consortiums exist, subdivided depending on their area of scope, as illustrated in Figure 7. All of them are partners of Lepida SpA, therefore Lepida SpA is legitimized to be involved for the support of their activities, by favouring economies of scale.

Currently each Consortium manages a suitable small sensor network, consisting of a set of data logger, devoted to hydrographical detection and remote control functions, thanks to the use of Programmable Logic Controllers (PLCs) and sensors connected to the data loggers. Furthermore each Consortium has got a suitable monitoring system (typically a server hosting a software system of data management) devoted to the collection of all the gathered data. Data are exchanged between data logger and server and among the data loggers (often there is the need to spread some specific control command from a data logger to other data loggers, by following as a sort of tree communication path) by using analog or GSM technologies (generally GSM is used to send alarm messages to people that need to be activated in case of danger or alarm situations while analog communication channels are used for the data collected by the sensors). Economies of scale could be found in such a scenario, by exploiting the network infrastructures owned by Lepida SpA.

For this purpose Lepida SpA will support the Consortiums, by starting from the Drainage Consortium of the Western Romagna *Lugo* (2011), which has been involved in a test-bed stage. The condition of the equipement managed by the Drainage Consortium of the Western Romagna, before the mentioned test bed stage, can be summerized as follows. It is composed by fifteen data loggers, each one including a PLC with some sensors for the hydraulic data collection and an analog communication module. Each module communicates the monitored data trough UHF channel while the alarm signals are sent through GSM network, by means of Short Message Service (SMS). The monitoring activity is mainly performed by following a polling communication protocol: a central server, devoted to the data collection and elaboration, polls each data logger every thirty minutes, by receiving the data that the sensors connected to the data logger have recorded at a one minute frequency during the last 12 Will-be-set-by-IN-TECH

security, management of the waters intended to the irrigation, involvement into urban planning, environmental and agricultural heritage protection can be considered typical

In Emilia-Romagna region eight Drainage Consortiums exist, subdivided depending on their area of scope, as illustrated in Figure 7. All of them are partners of Lepida SpA, therefore Lepida SpA is legitimized to be involved for the support of their activities, by favouring

Currently each Consortium manages a suitable small sensor network, consisting of a set of data logger, devoted to hydrographical detection and remote control functions, thanks to the use of Programmable Logic Controllers (PLCs) and sensors connected to the data loggers. Furthermore each Consortium has got a suitable monitoring system (typically a server hosting a software system of data management) devoted to the collection of all the gathered data. Data are exchanged between data logger and server and among the data loggers (often there is the need to spread some specific control command from a data logger to other data loggers, by following as a sort of tree communication path) by using analog or GSM technologies (generally GSM is used to send alarm messages to people that need to be activated in case of danger or alarm situations while analog communication channels are used for the data collected by the sensors). Economies of scale could be found in such a scenario, by exploiting

For this purpose Lepida SpA will support the Consortiums, by starting from the Drainage Consortium of the Western Romagna *Lugo* (2011), which has been involved in a test-bed stage. The condition of the equipement managed by the Drainage Consortium of the Western Romagna, before the mentioned test bed stage, can be summerized as follows. It is composed by fifteen data loggers, each one including a PLC with some sensors for the hydraulic data collection and an analog communication module. Each module communicates the monitored data trough UHF channel while the alarm signals are sent through GSM network, by means of Short Message Service (SMS). The monitoring activity is mainly performed by following a polling communication protocol: a central server, devoted to the data collection and elaboration, polls each data logger every thirty minutes, by receiving the data that the sensors connected to the data logger have recorded at a one minute frequency during the last

Fig. 7. Drainage Consortiums in Emilia-Romagna region

activites and actions covered by a Drainage Consortium.

the network infrastructures owned by Lepida SpA.

economies of scale.

thirty minutes; every poll requires about 300 bytes for each data logger. Besides the polling scheduled activity, the central monitoring system has also the possibility of directly poll a specific data logger at any instant, for example in case of emergency; in this case the polled data logger will send the data collected since the last polling.

The effort of Lepida SpA has been addressed to the communication technology used by the described system. In particular by offering the opportunity of exploiting the regional tetra radio infrastructure of the *ERretre* network as a data transportation driver. This represents for the Consortium an opportunity of economic and resource saving, by replacing the old analog radio with the modern digital tetra radio. Furthermore the *ERretre* network can offer other fundamental advantages: it can guarantee a full coverage inside the whole regional territory, allowing also intercommunications among the devices of different Drainage Consortiums in Emilia-Romagna region; it can offer guaranteed communications, avoiding the congestion events that instead may occur in a GSM network. Another role of Lepida will be the support in defining the technical specifics for a future furnishing of digital tetra radio to be used in a long-term solution when the test-bed stage will be definitely ended.

The test bed activated in collaboration with the Drainage Consortium of the Western Romagna exploits the *ERretre* network, with single slot packet data communication policy.

Fig. 8. System architectures tested in collaboration with the Drainage Consortium of the Western Romagna

The test bed has been conducted through two phases. The first one has been realized at Lepida Spa R&D Laboratories, by implementing two different architectures, illustrated in Figures 8, which leads to two different network performances. In architecture *(a)* both the data logger and the monitoring system are connected to two tetra radio modem: in this case any data

Fig. 9. Draining pump located at "Mordano" city.

Fig. 10. Monitoring systema located at "Lugo" city.

region. Generally speaking, Civil Protection works around the whole national territory and it is divided in regional agencies, which are subdivided in smaller agencies, devoted to the

Environmental Monitoring Supported by the Regional Network Infrastructures 403

tramission requires the activation of two radio links (the first one between the data logger and the *ERretre* base station covering the area in which the data logger is located and the second one between the monitoring system and the *ERretre* base station covering the area in which the monitoring system is located). A more efficient usage of the network resources is presented by architecture *(b)*, that exploits the existent cabled connection (optical fiber) between the *ERretre* Switching Central Node and the Lepida network infrastructure. The main advantage of this solution is represented by the reduction of the traffic routed inside the *ERretre* network, which institutional role is mainly represented by emergency communications, and the exploitation of the bandwith offered by the optical fiber link. concerning the data logger element, this has been emulated during the tests realized at the Lepida Laboratories, with a specific data simulator connected to the PLC of a real data logger. Both the two architectures have shown very good results when tested at the laboratories. These are both fundamental: one optimizing the network performances, the other enabling the implementation of sequential commands to more data loggers.

The second experimental phase has been activated with a real data logger, collecting real data from the sensors connected to it. The remote data logger was located at "Mordano" city and the central monitoring system was located at"Lugo" city, each one equipped with a tetra radio. The network architecture implemented is the *(a)* type (by referring to Figure 8 *(a)*, the only difference in terms of the real sensors that were used instead of the data simulator appliance), mainly because of two reasons: the head office of the Drainage Consortium of Western Romagna, located at "Lugo", was not yet connected to the Lepida optical fiber; the Drainage Consortium needs to activate also communications among each single data logger, by following a sort of tree path, in order to allow a data logger to send particular commands directly to other data loggers (for example a data logger being able to sequentially command a more draining installations).

Basically the communication is realized by following a polling communication protocol: the central server polls the data logger every thirty minutes, by receiving the data that the sensors connected to the data logger have recorded at a one minute frequency during the last thirty minutes; every poll requires about 300 bytes. Nevertheless the communication is bidirectional: the PLC is devoted both to the data gathering from sensor like temperature, water levels and water flow and to the reception of commands from the central server, like bulkheads closing or pumps activations; similarly the server receives the data gathered by the sensors and it can send remote commands to the PLC.

Figure 9 shows the place where the draining pump of "Mordano" is located, the control systems with PLC and data loggers and the tetra modem used for the test bed. Figure 10 shows the panel observable at "Lugo" with the monitoring system. The data management software and the data logger have been implemented and supplied by private enterprises that directly collaborate with the Drainage Consortium of Western Romagna.

This experimental phase has shown optimal results in terms of network performance and communications reliability. The test bed will be soon extended to fifteen other PLCs. The long-term installation will see the architecture *(b)* for the connection of the monitoring system and the architecture *(a)* among the single data loggers.

#### **5. Civil protection**

A further test bed has been created with the aim of realizing integrated systems for data and video communication on the Emilia-Romagna Regional territory, particularly for hydro geological and hydraulic risk, in cooperation with the Civil Protection of the Emilia-Romagna 14 Will-be-set-by-IN-TECH

tramission requires the activation of two radio links (the first one between the data logger and the *ERretre* base station covering the area in which the data logger is located and the second one between the monitoring system and the *ERretre* base station covering the area in which the monitoring system is located). A more efficient usage of the network resources is presented by architecture *(b)*, that exploits the existent cabled connection (optical fiber) between the *ERretre* Switching Central Node and the Lepida network infrastructure. The main advantage of this solution is represented by the reduction of the traffic routed inside the *ERretre* network, which institutional role is mainly represented by emergency communications, and the exploitation of the bandwith offered by the optical fiber link. concerning the data logger element, this has been emulated during the tests realized at the Lepida Laboratories, with a specific data simulator connected to the PLC of a real data logger. Both the two architectures have shown very good results when tested at the laboratories. These are both fundamental: one optimizing the network performances, the other enabling the implementation of sequential commands to

The second experimental phase has been activated with a real data logger, collecting real data from the sensors connected to it. The remote data logger was located at "Mordano" city and the central monitoring system was located at"Lugo" city, each one equipped with a tetra radio. The network architecture implemented is the *(a)* type (by referring to Figure 8 *(a)*, the only difference in terms of the real sensors that were used instead of the data simulator appliance), mainly because of two reasons: the head office of the Drainage Consortium of Western Romagna, located at "Lugo", was not yet connected to the Lepida optical fiber; the Drainage Consortium needs to activate also communications among each single data logger, by following a sort of tree path, in order to allow a data logger to send particular commands directly to other data loggers (for example a data logger being able to sequentially command

Basically the communication is realized by following a polling communication protocol: the central server polls the data logger every thirty minutes, by receiving the data that the sensors connected to the data logger have recorded at a one minute frequency during the last thirty minutes; every poll requires about 300 bytes. Nevertheless the communication is bidirectional: the PLC is devoted both to the data gathering from sensor like temperature, water levels and water flow and to the reception of commands from the central server, like bulkheads closing or pumps activations; similarly the server receives the data gathered by the sensors and it can

Figure 9 shows the place where the draining pump of "Mordano" is located, the control systems with PLC and data loggers and the tetra modem used for the test bed. Figure 10 shows the panel observable at "Lugo" with the monitoring system. The data management software and the data logger have been implemented and supplied by private enterprises

This experimental phase has shown optimal results in terms of network performance and communications reliability. The test bed will be soon extended to fifteen other PLCs. The long-term installation will see the architecture *(b)* for the connection of the monitoring system

A further test bed has been created with the aim of realizing integrated systems for data and video communication on the Emilia-Romagna Regional territory, particularly for hydro geological and hydraulic risk, in cooperation with the Civil Protection of the Emilia-Romagna

that directly collaborate with the Drainage Consortium of Western Romagna.

and the architecture *(a)* among the single data loggers.

more data loggers.

a more draining installations).

send remote commands to the PLC.

**5. Civil protection**

Fig. 9. Draining pump located at "Mordano" city.

Fig. 10. Monitoring systema located at "Lugo" city.

region. Generally speaking, Civil Protection works around the whole national territory and it is divided in regional agencies, which are subdivided in smaller agencies, devoted to the

Fig. 11. Design of camera installation at the railways bridge over the "Savio" river, near

on the specific use case (temporary or permanent monitoring station).

equipments already used during the first stage of the project.

infrastructures. A full description of the architecture realized for this first stage test-bed is illustrated in Figure 12. More precisely, Lepida SpA fiber network has been used as a backbone between the camera and the centralized server located at Operating Center of the Civil Protection of the Emilia-Romagna Region, while the connection between each single camera and the closest point of presence of Lepida network has been designed and implemented as an ad hoc wireless link, with the proper and better technology (Hiperlan, TETRA...), depending

Environmental Monitoring Supported by the Regional Network Infrastructures 405

For this reason, this stage has represented for Lepida SpA mainly a test bed in which testing the network performances serving as collector of many data/video distributed all over the regional territory. The cameras used for the test bed stage are professional Megapixel IP cameras supporting H.264 video streaming. As far as the centralized system of data recording and management is concerned, the first stage used a solution based on a commercial product

The item monitored by the camera is the "Savio" river. The amount of traffic over the network is about one image of thirty kBytes every fifteen minutes. When the TETRA channel is used, each image is sent by exploiting the single slot packet data type of communication, that offers a 3kbits/sec of bandwith. The amount of traffic exchanged is compliant with the performances

The first stage test bed has shown positive and promising results, leading to the definition of guideline for a second stage of this project. This second stage will involve the realization of at least thirty other video camera located at different river area already defined and spread all over the Emilia-Romagna regional territory. The main requirement of the future new installation is the full compatibility with the infrastructures, the hardware and software

During the test bed realized in collaboration with the Civil Protection, the role of Lepida SpA has been mainly focused over the definition of the proper architecture of the communication

"Cesena" city.

(Genetec Omnicast).

offered by the TETRA channel.

**5.1 Video management center**

execution of pregressively more local aspects. Its main working acivities are forecasting and preventions, rescue activities, emergency trainings.

The project, promoted by the Civil Protection of the Emilia-Romagna region, aims to the realization, with the technologies at disposal nowadays, of a set of integrated systems devoted essentially to the monitoring and to the communication of data/video over the Emilia-Romagna Regional territory, to fulfill the requirements of the Civil Protection: prevention and management of hydrogeological-hydraulic risk, emergencies, disasters, trainings. More precisely, the project includes the following items:


The project has started with a first stage implementation that has been developed and employed as an experimental test bed, usefull to understand the limits and strength of the architecture of the whole system. More in detail, this first stage has realized the videowall and a sort of "mini network" of video monitoring, which specfications are explained as follows:


Lepida SpA has been involved in this first stage of the project for the definition of network architectural specifics and for the configuration of the network active devices involved (switches, routers...), besides offering to the Civil Protection the usage of its network 16 Will-be-set-by-IN-TECH

execution of pregressively more local aspects. Its main working acivities are forecasting and

The project, promoted by the Civil Protection of the Emilia-Romagna region, aims to the realization, with the technologies at disposal nowadays, of a set of integrated systems devoted essentially to the monitoring and to the communication of data/video over the Emilia-Romagna Regional territory, to fulfill the requirements of the Civil Protection: prevention and management of hydrogeological-hydraulic risk, emergencies, disasters,

• system for the visualization of large area and for the visual integration of images and data, both newly generated than preeexistant, trough a rear projection videowall located at the Operating Center of the Civil Protection of the Emilia-Romagna Region, in Bologna City; • capturing systems of territorial images for the permanent monitoring of critical area such as bridges or other infrastructure located near rivers or torrents or dry detention basins; • capturing systems of territorial images for emergency or temporary situations, devoted to the monitoring of rivers or landslides or disasters area or even training activities, by

The project has started with a first stage implementation that has been developed and employed as an experimental test bed, usefull to understand the limits and strength of the architecture of the whole system. More in detail, this first stage has realized the videowall and a sort of "mini network" of video monitoring, which specfications are explained as follows: • One video camera and related data/video transmission systems (in Hiperlan technologies at 5.4GHz) devoted to the permanent video monitoring of the river "Savio" near "Cesena"

• One kit of video monitoring and recording and related data/video multistandard transmission systems (Hiperlan, TETRA, UMTS, Ethernet, etc...). This kit has been installed over a transoprtable device (a trailer truck) devoted to temporary video monitoring activities in area such as rivers, torrents, landslides or other situations of

• One kit of video monitoring and data/video transmission installaed over a motor vehicle (in this case a vehicle owned by the Group of Amateur Radio Operators Volunteers of the city of "Imola" was used) devoted to monitoring activities during training exercises or

• One hardware and software centralization system (server) for the centralized recording and management of the data/video collected by the remote video systems listed in the previous items; the mentioned server was located at the Data Elaboration Center of the

• Four workstations related to the four systems listed above: two located at the Operating Center of the Civil Protection of the Emilia-Romagna Region, together with the videowall; one located at the of Operating Center of the River Basin Consortium of the city of "Forlí"; the last one located at the Operating Center of the River Basin Consortium of the city of

Lepida SpA has been involved in this first stage of the project for the definition of network architectural specifics and for the configuration of the network active devices involved (switches, routers...), besides offering to the Civil Protection the usage of its network

preventions, rescue activities, emergency trainings.

trainings. More precisely, the project includes the following items:

exploiting a transportable device and a motor vehicle.

city and located at the railways bridge over this river 11.

emergency or temporary training exercises.

Emilia-Romagna Region, in "Bologna" city;

disasters or emergency situations.

"Cesena".

Fig. 11. Design of camera installation at the railways bridge over the "Savio" river, near "Cesena" city.

infrastructures. A full description of the architecture realized for this first stage test-bed is illustrated in Figure 12. More precisely, Lepida SpA fiber network has been used as a backbone between the camera and the centralized server located at Operating Center of the Civil Protection of the Emilia-Romagna Region, while the connection between each single camera and the closest point of presence of Lepida network has been designed and implemented as an ad hoc wireless link, with the proper and better technology (Hiperlan, TETRA...), depending on the specific use case (temporary or permanent monitoring station).

For this reason, this stage has represented for Lepida SpA mainly a test bed in which testing the network performances serving as collector of many data/video distributed all over the regional territory. The cameras used for the test bed stage are professional Megapixel IP cameras supporting H.264 video streaming. As far as the centralized system of data recording and management is concerned, the first stage used a solution based on a commercial product (Genetec Omnicast).

The item monitored by the camera is the "Savio" river. The amount of traffic over the network is about one image of thirty kBytes every fifteen minutes. When the TETRA channel is used, each image is sent by exploiting the single slot packet data type of communication, that offers a 3kbits/sec of bandwith. The amount of traffic exchanged is compliant with the performances offered by the TETRA channel.

The first stage test bed has shown positive and promising results, leading to the definition of guideline for a second stage of this project. This second stage will involve the realization of at least thirty other video camera located at different river area already defined and spread all over the Emilia-Romagna regional territory. The main requirement of the future new installation is the full compatibility with the infrastructures, the hardware and software equipments already used during the first stage of the project.

#### **5.1 Video management center**

During the test bed realized in collaboration with the Civil Protection, the role of Lepida SpA has been mainly focused over the definition of the proper architecture of the communication

correlated to the video data. Lepida SpA, in order to readily face and solve the necessities that arise from the regional territory has designed a global architecture for an efficient management of all the video data that potentially could be generated by the cameras and videosurveillance

Environmental Monitoring Supported by the Regional Network Infrastructures 407

systems installed by all the Public Administrations in Emilia-Romagna region.

Fig. 13. Architecture for the management of camera strems produced by the Public

least one week old (in accordance to the italian law), downloading of recorded video.

The architecture proposed by Lepida SpA is illustrated in the Figure 13: Lepida SpA will provide a central server (or a proper cluster of servers) devoted to the storage of all the video streams recorded by the cameras, that will be collected by exploiting the Lepida network infrastructures; this centralized system will host also a full video management service, completely designed and implemented by Lepida SpA with the exploitation of open source technologies, that thanks to the Lepida network infrastructures, will offer to the remote Public Administrations client workstations features like: live streaming view, recorded video of at

Lepida Spa has implemented these features in a Video Management Center prototype. Figures 14 and 15 show some snapshot. More precisely this prototype is composed by a streaming server that collects all the streming video produced by the cameras and streams them to a management server. The management server functions as a web broadcaster of the data streamed by the streaming server, a choice that allows a big scalability in terms of network traffic: each client can watch a live video directly from this streaming server, avoiding the multiplication of network traffic that would be necessary if each client would refere directly to each camera stream. Management and streming server can be hosted in the same hardware server (specifically, the prototype realized follows this policy). The management server is implemented with web services technologies (php, apache, html, javascript, ajax) and it provides a web interface with tabs for the live view, for the recorded video view and for the downloading of the recorded video. In order to be compliant with all the requirements contemplated by the italian law in terms of privacy related to the management of video

Administrations.

Fig. 12. Architecture of the first stage of the test bed realized in collaboration with the Civil Protection.

network to be used, in terms of the selection of the proper communication driver technology (hiperlan, TETRA, fiber...) and in terms of the proper addressing policy to be adopted among the different Entities (Regional Administrations and Regional Data Elaboration Center, Civil Protections...) involved. During the first stage test bed, differently than during the activity with the River Basin Consortium, no central data management system has been proposed and tested by Lepida SpA, since a commercial one was currently at disposal of the Civil Protection, at least for the purpose of the first stage activity.

As the census results has shown, a lot of Public Administrations in the Emilia-Romagna region are equipped with videosurveillance cameras for the purpose of public security maintenace. As the census activity has highlighted, these video show the same behavior of the environmental sensors installations (temperature, landslides, pollutions...): they often have been installed in former times by each single Administration, as separate and independent systems, resulting in a lot of camera managed by autonomous, independent and very expensive videosurveillance appliances. Furthermore, during the more recent years, expecially the smaller Public Administrations located in the Emilia-Romagna region, have expressed the necessity of providing themeselves with videocamera systems, asking support to Lepida SpA, the natural and institutional reference for the resource efficient development of their activities. More precisely these Administrations needs support concerning the definition of the technical specifics to include in public announcements devoted to the cameras, ad hoc communication infrastructures and video management systems. Such a scenario, like the scenario explored with the River Basin Consortium, points out the necessity of a central management system that could help resource saving policies in the management activities 18 Will-be-set-by-IN-TECH

Fig. 12. Architecture of the first stage of the test bed realized in collaboration with the Civil

network to be used, in terms of the selection of the proper communication driver technology (hiperlan, TETRA, fiber...) and in terms of the proper addressing policy to be adopted among the different Entities (Regional Administrations and Regional Data Elaboration Center, Civil Protections...) involved. During the first stage test bed, differently than during the activity with the River Basin Consortium, no central data management system has been proposed and tested by Lepida SpA, since a commercial one was currently at disposal of the Civil Protection,

As the census results has shown, a lot of Public Administrations in the Emilia-Romagna region are equipped with videosurveillance cameras for the purpose of public security maintenace. As the census activity has highlighted, these video show the same behavior of the environmental sensors installations (temperature, landslides, pollutions...): they often have been installed in former times by each single Administration, as separate and independent systems, resulting in a lot of camera managed by autonomous, independent and very expensive videosurveillance appliances. Furthermore, during the more recent years, expecially the smaller Public Administrations located in the Emilia-Romagna region, have expressed the necessity of providing themeselves with videocamera systems, asking support to Lepida SpA, the natural and institutional reference for the resource efficient development of their activities. More precisely these Administrations needs support concerning the definition of the technical specifics to include in public announcements devoted to the cameras, ad hoc communication infrastructures and video management systems. Such a scenario, like the scenario explored with the River Basin Consortium, points out the necessity of a central management system that could help resource saving policies in the management activities

Protection.

at least for the purpose of the first stage activity.

correlated to the video data. Lepida SpA, in order to readily face and solve the necessities that arise from the regional territory has designed a global architecture for an efficient management of all the video data that potentially could be generated by the cameras and videosurveillance systems installed by all the Public Administrations in Emilia-Romagna region.

Fig. 13. Architecture for the management of camera strems produced by the Public Administrations.

The architecture proposed by Lepida SpA is illustrated in the Figure 13: Lepida SpA will provide a central server (or a proper cluster of servers) devoted to the storage of all the video streams recorded by the cameras, that will be collected by exploiting the Lepida network infrastructures; this centralized system will host also a full video management service, completely designed and implemented by Lepida SpA with the exploitation of open source technologies, that thanks to the Lepida network infrastructures, will offer to the remote Public Administrations client workstations features like: live streaming view, recorded video of at least one week old (in accordance to the italian law), downloading of recorded video.

Lepida Spa has implemented these features in a Video Management Center prototype. Figures 14 and 15 show some snapshot. More precisely this prototype is composed by a streaming server that collects all the streming video produced by the cameras and streams them to a management server. The management server functions as a web broadcaster of the data streamed by the streaming server, a choice that allows a big scalability in terms of network traffic: each client can watch a live video directly from this streaming server, avoiding the multiplication of network traffic that would be necessary if each client would refere directly to each camera stream. Management and streming server can be hosted in the same hardware server (specifically, the prototype realized follows this policy). The management server is implemented with web services technologies (php, apache, html, javascript, ajax) and it provides a web interface with tabs for the live view, for the recorded video view and for the downloading of the recorded video. In order to be compliant with all the requirements contemplated by the italian law in terms of privacy related to the management of video

Fig. 15. Video Management Center prototype (CGV): video recorded on demand feature available on the web interface. The camera shown and listed are used in Lepida SpA R&D

Environmental Monitoring Supported by the Regional Network Infrastructures 409

This publication has highlighted some interesting aspects of environmental monitoring mainly related to the Public Administrations context. Let us stress that, expecially in the Public context, an effective usage of the available resources and a development based on economies of scale are fundamental. The research method proposed and adopted by Lepida SpA has represented, as the described test-beds have shown, a valid instrument for the efficient planning, without any resource wasting, both phisical and economic, of all the environmental monitoring activities managed at a regional level. In particular the method proposed has given the opportunity of increasing the knowledge of all the infrastrucutures and system concerning the environmental monitoring field, active and used inside the whole regional territories, resulting in a more aware development of new hardware and software solutions able to face with the practical problems and necessity raised by the Public Administrations of the Emilia-Romagna region. The test-beds activated and described in this chapter will offer in the next months the chance to properly set and define all the systems variables and parameters in order to become useful models for the definition of future full services devoted to the Public

This chapter was prepared in collaboration with Eng. Stefania Nanni, Laboratories ICT Manager at Lepida SpA, Eng. Anna Lisa Minghetti, Lepida network Manager at Lepida SpA, Eng. Federico Marcheselli, ERretre network Manager at Lepida SpA, Eng. Fabio Brunelli,

laboratories as a test-bed.

**6. Conclusions**

Administrations.

**7. Acknowledgment**

Services Development area at Lepida SpA.

Fig. 14. Video Management Center prototype (CGV): streaming live view feature available on the web interface. The camera shown and listed are used in Lepida SpA R&D laboratories as a test-bed.

data, the prototype also implements other features such as: strong authentication of all the users that can access the web interface; profilation of the users that can access the web interface, in order to limit and specifically select the features each users is enabled to access; logs collection related to all the operations that each user makes on the web interface. The authentication is performed by exploiting the "fedERa" system. "FedERa" *fedERa* (2011) is the regional authentication system designed and promoted by Lepida SpA; it is a federated authentication system that allows the access to all the online services offered by the federated Public Administrations, with the usage of a single username-password that is valid for all the federated services. The profilation system has been implemented ad hoc for this prototype and it allows to differentiate the features that are available to each user: live view, view on demand of the recorded video, download of the recorded video. The profilation system, strictly correlated to the authentication system, allows the creation of logs to trace the activities of video data managements, as required by the italian privacy laws: the log systems collects information about the timestamp, identity of the user and specific operation made on the Video Management Centre (live view, on demand view, download). Actually the Video Management Center prototype has been tested by Lepida SpA internally. In a couple of months it is scheduled the start of a test bed usage of such a system in collaboration with a small Public Administration of the Emilia-Romagna region, for public security purpose. The architecture designed for security videosurveillance purpose and the developed prototype could nevertheless also be used in scenarios such as the one described by the project of the Civil Protection, so for environmental monitoring purposes that are based on video images.


Fig. 15. Video Management Center prototype (CGV): video recorded on demand feature available on the web interface. The camera shown and listed are used in Lepida SpA R&D laboratories as a test-bed.
