This release contains a SQL/PostGIS pipeline developed to support a Decision Support System (DSS) for the analysis and planning of the regional school network in Friuli Venezia Giulia, Italy. The pipeline integrates administrative, school-building, demographic, financial, accessibility, environmental and territorial information within a PostgreSQL/PostGIS database. It produces thematic tables, materialized views and geospatial structures designed for GIS-based analysis and comparative representation. The main operational unit is the localised Point of Service Delivery (PES), represented in the implementation by the cod_units identifier, while preserving the distinction between PES, school sites, buildings, school institutions and territorial context. The analytical framework relates indicators across seven interdependent domains: demographic dynamics, allocation of funding, territorial distribution, school buildings, accessibility of school locations, relationships with the surrounding context, and educational poverty. Beta 1 is a reference implementation for Friuli Venezia Giulia. Its methodological architecture and general processing logic are designed to be transferable to other regional contexts; however, application to another Region requires adaptation to local datasets, database structures, identifiers, available indicators, coordinate reference systems and organisational characteristics of the school network. The DSS is not intended to automatically produce rankings, judgements or decisions concerning individual school sites. Indicators must be interpreted jointly and in relation to territorial context, analytical scale, and the quality and completeness of the available information. Following methodological revision, the corrected Beta 1 pipeline was validated on 15 September 2026 using PostgreSQL 17 and PostGIS 3.5.3. The package includes dependency checks, methodological audit procedures, final output validation, technical documentation and the methodological report. Source datasets are not included in the deposit and remain subject to their respective rights and conditions of use.
Pipeline per un Sistema di Supporto alle Decisioni dell'assetto scolastico regionale / Peraz, A.. - ELETTRONICO. - (2026), pp. 1-22. [10.5281/zenodo.22765165]
Pipeline per un Sistema di Supporto alle Decisioni dell'assetto scolastico regionale
Andrea Peraz
Software
2026-01-01
Abstract
This release contains a SQL/PostGIS pipeline developed to support a Decision Support System (DSS) for the analysis and planning of the regional school network in Friuli Venezia Giulia, Italy. The pipeline integrates administrative, school-building, demographic, financial, accessibility, environmental and territorial information within a PostgreSQL/PostGIS database. It produces thematic tables, materialized views and geospatial structures designed for GIS-based analysis and comparative representation. The main operational unit is the localised Point of Service Delivery (PES), represented in the implementation by the cod_units identifier, while preserving the distinction between PES, school sites, buildings, school institutions and territorial context. The analytical framework relates indicators across seven interdependent domains: demographic dynamics, allocation of funding, territorial distribution, school buildings, accessibility of school locations, relationships with the surrounding context, and educational poverty. Beta 1 is a reference implementation for Friuli Venezia Giulia. Its methodological architecture and general processing logic are designed to be transferable to other regional contexts; however, application to another Region requires adaptation to local datasets, database structures, identifiers, available indicators, coordinate reference systems and organisational characteristics of the school network. The DSS is not intended to automatically produce rankings, judgements or decisions concerning individual school sites. Indicators must be interpreted jointly and in relation to territorial context, analytical scale, and the quality and completeness of the available information. Following methodological revision, the corrected Beta 1 pipeline was validated on 15 September 2026 using PostgreSQL 17 and PostGIS 3.5.3. The package includes dependency checks, methodological audit procedures, final output validation, technical documentation and the methodological report. Source datasets are not included in the deposit and remain subject to their respective rights and conditions of use.Pubblicazioni consigliate
I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.


