FOSS4G 2022 general tracks

Pedological Information System of Piedmont Region in Italy
2022-08-24, 16:45–17:15 (Europe/Rome), Room 9

Over the last 35 years, the IPLA has collected data on soils, both soil samples and cartographic data, to create a database (physical and digital) that represents knowledge for all stakeholders, public and private, of the composition and state of soils. Piedmontese.
in the last 25 years the SIP (Pedological Information System) has been changed several times, to meet the new needs in terms of data collection but above all to update it to the new FOSS technologies.
in fact, in the last 5 years we have gone from non-connected proprietary systems (DB FoxPro and Esri geoDB personal) to a single integrated system with FOSS tools: PostgreSQL / PostGIS and QGIS.
An information system has therefore been created that allows technicians on the one hand to be able to collect the field data by inserting them, with a web interface in the database, and to be able to see in real time, the cartographic themes in QGIS, based on the data.just inserted and taking advantage of the geographical component of the database.
Also the implementation of the survey points can be done, using in this case internal functions of the DB, both in alphanumeric way and in QGIS in a geographic way, with real-time modification of the points based on the coordinates entered by one of the two tools.
And new implementations for field survey (QFiled) are under development, for the survey of the points and their visualization on the DB in real time.
The pedological observations are characterized by different levels of information among which more than 5000 soil profiles are the basic and fundamental data, subdivided into field data (descriptions and photos) and analytical data (physical-chemical determinations in laboratory). The elaboration of these data provides the main structure of the Pedological Information System, that is the description of more than 1200 Soil Types, used to build up the characterization of 7000 Geographical Units.

I started working with GIS in 1993 dealing with cartography projects and in particular with the integration of CAD and DB. Over the years I have been responsible for cartography projects and I have been interested in the development of GIS software, arriving in the last 5 years to deal with the transaction from proprietary software to software and DB FOSS. Currently I work on data analysis and big data in the GIS field, both with GIS tools such as QGIS, and with DB solutions such as PostgreSQL / PostGIS