the role of gfoss in environmental protection: the arpa piemonte experience · 2016. 10. 18. ·...

FOSS.4GIS.GOV – Brasilia 27 september 2016

Rocco PISPICO

The role of GFOSS in environmental protection:

the Arpa Piemonte experience

FOSS.4GIS.GOV – Brasilia 27 september 2016

Arpa Piemonte is the Regional Environmental Protection Agency of Piedmont (Italy)

Arpa is public body with own administrative, technical-juridical, asset management and accounting purposes

Arpa Piemonte

25.000 Sq Km

FOSS.4GIS.GOV – Brasilia 27 september 2016

to prevent, reduce and eliminate pollutionto address environmental problems according to integrated

multidisciplinary approachto provide information and training activities regarding the

conditions of the environment

The aim of our agency

Prediction and prevention of anthropic risks and natural risks

Measuring activities for purposes of conformity checksWater, soil and air quality monitoringReports on the environment conditions

Our activities

FOSS.4GIS.GOV – Brasilia 27 september 2016

WASTE

SOIL

NATURAL RISKS

PHYSICAL AGENTS

ENVIRONMENT AND HEALTH

AIR

WATER

WEATHER

WORK ENVIRONMENT

INDUSTRIAL ACTIVITIES

ECOSYSTEMS AND LANDSCAPES

URBAN ENVIRONMENT

CONTAMINATED SITES

NATURAL CONSERVATION

MICRO-POLLUTANTS

Environmental protection is in our nature

FOSS.4GIS.GOV – Brasilia 27 september 2016

2010 2011 2012 2013 2014 2015 2016

Test phase

Basic cartography

Weather Radar

Geology historical data

Landslides inventory

WaterFramework

Directive

Asbestos

Dams

River works

Seismiczoning

Environmental monitoring

Geology base map

Satellite data Territorial planning

Telephone and radio stations

Alluvial fanGeotechnical data

Flood risk

Landslide monitoring

Piezometric network

Database timeline

Post-earthquake assesment of building

FOSS.4GIS.GOV – Brasilia 27 september 2016

Database location

3 master/slave replica PostgreSQL 9.3

PostGIS 2.1 about 160Gb

Ubuntu 14.04 Server 64 bit

FOSS.4GIS.GOV – Brasilia 27 september 2016

Table and record

Half in users are in multiuser editing

Exchange (Brazil-EC) for free open source software for GIS – Brasilia 27 settembre 2016

Pro Cons

GIS multieditingFlexibilityEasy to usePower spatial analysisMultiple installationReplicaWell documented

Raster management

Geodatabase

Exchange (Brazil-EC) for free open source software for GIS – Brasilia 27 settembre 2016

e.g. landslide studing needs to analyze a lots of different kind of data:

Monitoring dataBorehole and geotechnical dataHystorical and archive dataField survey infromation

Data interconnection in a geodatabase

We try to automatise as much as as possible all repeating spatial analysis. After geometry digitalization Postgres derive the main statistics, like:

Permanent scatterers movement data;Landslide interaction with good, buildings and facilitiesOther data such as boreholes, monitoring systems, landuse, rainfall data ecc..

Exchange (Brazil-EC) for free open source software for GIS – Brasilia 27 settembre 2016

Complex symbolgy

Exchange (Brazil-EC) for free open source software for GIS – Brasilia 27 settembre 2016

Complex geometry

Exchange (Brazil-EC) for free open source software for GIS – Brasilia 27 settembre 2016

Pro Cons

●Easy to use●Full integration with PG/PGIS●Advanced styling●Atlas printer management●Powerful form editor●Python●Sharing instruments with external users

●Stability●Processing is not well integrated●Poor integration with Spatialite

QGIS

FOSS.4GIS.GOV – Brasilia 27 september 2016

Huge infrastructure projects

Builders of huge infrastructure require very structured monitoring plans, that last for several years

thousands of measurements taken every month, seldom every week

data from must be shared and accessible to all colleagues

analysis and reports on weekly, monthly and annual basis

FOSS.4GIS.GOV – Brasilia 27 september 2016

Data organization

The database contains:

master data infrastructure

master data monitoring

Description of Monitored environmental components

Description of measurement points

Values of measures

With data you can:

To manage time schedule compliance

To avoid twice measures

To highlight data anomalies

FOSS.4GIS.GOV – Brasilia 27 september 2016

What do we measure

Monitored environmental components

Water (river and underground water);Air (PM10, Nox, etc….);Noise (from traffic and from construction site);Asbestos;Ionizing radiations (from rocks);Soils;Vegetation;Fauna.

Every measure has its geographic information: Point, line, polygon

Exchange (Brazil-EC) for free open source software for GIS – Brasilia 27 settembre 2016

Other instruments

Raster analysis and topological controls

Statistical analysis

Vector analysis

Raster and Vector transformations

FOSS.4GIS.GOV – Brasilia 27 september 2016

Open source improvements

BUG FIXES

More than 30 bugs

CORE FUNCTIONS

Python macros

Style in database

FOSS.4GIS.GOV – Brasilia 27 september 2016

Open source improvements (2)

PLUGINS

PS Time Series Viewer

Processing PS Tools provider

Processing Permaclim provider

ARPAP Spatial report

Form value relation

OTHER

Python chart tool

ROAM/Intramaps

GPS Tracking

FOSS.4GIS.GOV – Brasilia 27 september 2016

Less than 30K € in six years

What we could have done with the same budget with proprietary software?

Open source improvements (3)

FOSS.4GIS.GOV – Brasilia 27 september 2016

The real strength of GFOSS: ERIKUS

Centro Italia 24/08/2016 a 6.0 Mw earthquake

FOSS.4GIS.GOV – Brasilia 27 september 2016

ERIKUSERIKUS is a QGIS project to help to collect data on evaluation of the buildings after an earthquake.It was tested during a simulation test on 3 municipalities at june 2016.

After the “Centro Italia earthquake” DPCN asks to use it on the field.Now more than 70 municipalities collect data with ERIKUS.

LAN with PostgreSQL Standalone on shapefile

FOSS.4GIS.GOV – Brasilia 27 september 2016

ERIKUS: data entry

QT forms on QGIS

FOSS.4GIS.GOV – Brasilia 27 september 2016

ERIKUS: reports

For the inspection teams

Administrative instances

FOSS.4GIS.GOV – Brasilia 27 september 2016

ERIKUS: data collection

The municipalities submit data for Arpa Piemonte in order to collect, to make formal controls, to create the entire area data

FOSS.4GIS.GOV – Brasilia 27 september 2016

ERIKUS: dissemination

WMS/WFS services

Web reports

FOSS.4GIS.GOV – Brasilia 27 september 2016

ERIKUS uses only open source software

QGIS Server

FOSS.4GIS.GOV – Brasilia 27 september 2016

Luca is working in the CRA municipalityemergency Computer Room

Customers care service

Midnight QGIS training party

...during the emergency

FOSS.4GIS.GOV – Brasilia 27 september 2016

Pros and cons

PROS CONS

PostgreSQLPostGISGDAL/OGRMultiuser editingQGISQGIS Processing Provider (GRASS,

SAGA...)Layout managerForm editorUser friendly

Too many releases sometimes astonish basic user and IT managerQGIS mindumpsPostgreSQL/PostGIS raster functions

FOSS.4GIS.GOV – Brasilia 27 september 2016

the future...

• RASTER

•RASDAMAN

• PostgreSQL/PostGIS

•Routing

•Address matching

•Local gazeteer

•2.5/3D

• Webgis

•Leaflet

•Lizmap

•Qgis server

FOSS.4GIS.GOV – Brasilia 27 september 2016

Website www.arpa.piemonte.gov.it

Bulletins www.arpa.piemonte.gov.it/bollettini/elenco-bollettini

Twitter @ArpaPiemonte

Relations with the pubblic Free phone number 800 518 800

App download from “Google Play Store”

Geoportale webgis.arpa.piemonte.it/geoportale/

Disseminating environmental informations

FOSS.4GIS.GOV – Brasilia 27 september 2016

Roberto CREMONINI, Luciano CRUA, Romina DI PAOLO,

Riccardo GAETA, Luca LANTERI

OBRIGADO!

Special thanks to

The ERIKUS TeamErika CERIANA MAYNERI, Luca LANTERI, Stefano CAMPUS, Carlo TROISI,

Paola BERNARDELLI, Carlo ROAGNA, Max SENESI