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.
File in questo prodotto:
Non ci sono file associati a questo prodotto.
Pubblicazioni consigliate

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11368/3151438
 Avviso

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo

Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus ND
  • ???jsp.display-item.citation.isi??? ND
social impact