This PhD course is part of the thematic path "Technologies, Techniques and Methodologies for Sustainable Development" of the PhD programme in Urban and Regional Development. The main goals of the course are: • Transitioning to advanced geodatabase management: to provide in-depth knowledge of geodatabases as a robust alternative to standard shapefiles. This transition is designed to overcome file-based limitations, improve data sharing, enable multi-user editing, and increase overall system performance. • Implementing advanced modeling and data integrity: to enable students to use "advanced" analysis models through complex data structures. This includes mastering tools like subtypes and attribute domains to constrain data values, relationship classes to maintain spatial and referential integrity between geographic objects, and network analyses based on a structured network dataset. • Mastering GIS interoperability and open data ecosystems: to develop practical skills across different software environments (specifically QGIS and ESRI ArcGIS Pro) and open standards like OGC GeoPackage. This includes learning how to effectively access, download, and actively contribute to community-driven data platforms like OpenStreetMap. The expected learning outcomes are: • In-depth knowledge of Geodatabase Design and Implementation: students learn to design and implement geodatabase structures (both GeoPackage and ESRI File Geodatabase) and utilise advanced functionalities like subtypes, attribute domains, and network dataset to ensure data integrity and improve performance. • Advanced Geospatial Modeling and Analysis: students gain expertise and skills in managing complex data structures to solve real-world problems. This includes implementing Relationship Classes to define how objects relate, managing multi-temporal imagery through Raster Mosaic Datasets, and building Network Datasets to perform network analyses. • Technical GIS Software Skills and Interoperability: the course builds practical skills in using both Free and Open Source Software (QGIS) and Commercial Off-The-Shelf software (ESRI ArcGIS Pro). A major focus is placed on interoperability, specifically managing GeoPackage formats across different platforms and performing Extraction, Transformation, and Loading (ETL) procedures.

N/A

The course topics are grouped into lectures and software exercises. The fundamentals of each subject are introduced through lectures and then applied to real datasets using two GIS software packages, open-source and commercial, namely QGIS and ESRI ArcGIS Pro. A course module will be in the form of Team-Based Learning (innovative teaching according to the guidelines of the University's Teaching Lab). The course program is structured around the following main topics: 1. Course Introduction and Geospatial Fundamentals (3 hours) 1a. Course Overview & Data Types: introduction to course goals, student expectations, and an overview of general geospatial data types. 1b. Geodatabase Basics: review of expected learning outcomes and the fundamental concepts of geodatabases. 2. OpenStreetMap (OSM) Ecosystem and Open Source Tools (4 hours) 2a. Introduction to OSM: initial overview of the OpenStreetMap project and its data structures. 2b. Data Access and QGIS: instruction on downloading OSM data via OverpassTurbo and the OSM website, followed by an introduction to QGIS and the QuickOSM plugin. 3. Advanced Geodatabase Management and Interoperability (7 hours) 3a. Software Interoperability: management of GeoPackage in QGIS and the use of ESRI Geodatabases within ArcGIS Pro. 3b. Advanced Functionalities: instruction on creating File Geodatabases, implementing feature class subtypes and domain values, and performing Extraction, Transformation, and Loading (ETL) procedures. 3c. Complex Data Structures: in-depth coverage of advanced geodatabase objects, including raster mosaic datasets and relationship classes. 4. Team-Based Learning (TBL) on network dataset and network analyses (6 hours) 4a. TBL Preparation: introduction to study materials and the formation of student teams. 4b. TBL Execution and Wrap-up: the final session is dedicated to the Individual Readiness Assurance Test (i-RAT), Team Readiness Assurance Test (t-RAT), appeals, the Individual Application (i-APP), and a final discussion and course wrap-up.

In presenza

Sviluppo di project work in team - Presentazione orale

P.D.1-1 - Gennaio