CODE 98963 ACADEMIC YEAR 2023/2024 CREDITS 6 cfu anno 3 INGEGNERIA CIVILE E AMBIENTALE 8715 (L-7) - GENOVA 6 cfu anno 1 SCIENZE DELL'ARCHITETTURA 8694 (L-17) - GENOVA 6 cfu anno 2 SCIENZE AMBIENTALI E NATURALI 9916 (L-32) - GENOVA 6 cfu anno 3 SCIENZE GEOLOGICHE 8763 (L-34) - GENOVA 6 cfu anno 2 SCIENZE DELL'ARCHITETTURA 8694 (L-17) - GENOVA 6 cfu anno 3 SCIENZE DELL'ARCHITETTURA 8694 (L-17) - GENOVA SCIENTIFIC DISCIPLINARY SECTOR ICAR/06 LANGUAGE Italian TEACHING LOCATION GENOVA SEMESTER 2° Semester PREREQUISITES Propedeuticità in ingresso Per sostenere l'esame di questo insegnamento è necessario aver sostenuto i seguenti esami: Earth Sciences 8763 (coorte 2023/2024) EEXPERIMENTAL PHYSICS 25934 2023 PHISICAL GEOGTRAPHY AND CARTOGRAPHY 52415 2023 MINERALOGY 57251 2023 PALEONTOLOGY 64866 2023 GEOLOGY 1 72871 2023 ENGLISH 72877 2023 GENERAL AND INORGANIC CHEMISTRY WITH LABORATORY 87055 2023 ELEMENTS OF MATHEMATIC 95338 2023 Earth Sciences 8763 (coorte 2021/2022) EEXPERIMENTAL PHYSICS 25934 2021 PHISICAL GEOGTRAPHY AND CARTOGRAPHY 52415 2021 MINERALOGY 57251 2021 PALEONTOLOGY 64866 2021 GEOLOGY 1 72871 2021 ENGLISH 72877 2021 GENERAL AND INORGANIC CHEMISTRY WITH LABORATORY 87055 2021 ELEMENTS OF MATHEMATIC 95338 2021 Earth Sciences 8763 (coorte 2022/2023) EEXPERIMENTAL PHYSICS 25934 2022 PHISICAL GEOGTRAPHY AND CARTOGRAPHY 52415 2022 MINERALOGY 57251 2022 PALEONTOLOGY 64866 2022 GEOLOGY 1 72871 2022 ENGLISH 72877 2022 GENERAL AND INORGANIC CHEMISTRY WITH LABORATORY 87055 2022 ELEMENTS OF MATHEMATIC 95338 2022 TEACHING MATERIALS AULAWEB OVERVIEW The class illustrates the characteristics of digital cartography, where to find it and how to display, query, integrate it with the currently available geo-services and analyze it using GIS (Geographic Information System) free and open source software. The approach is very operational, with computer exercises dedicated to the natural (terrestrial and marine) and built environments, in different interdisciplinary areas of study. AIMS AND CONTENT LEARNING OUTCOMES The class provides operational GIS (Geographic Information System) tools for search, visualize, query, process, manage and analyze digital cartography and geo-referenced data. It allows to address practical applications in the different fields of study of the urban and natural (terrestrial and marine) environments. AIMS AND LEARNING OUTCOMES At the end of the class, the students will have acquired the theoretical and practical techniques to manage and analyze geo-referenced spatial data. Students will then be able to: use GIS software, with particular reference to free and open source software (in accordance with the directive of the Minister for Innovation and Technology of December 19, 2003 that encourages their use) to solve practical and interdisciplinary applications in different areas of study: land and environmental management, decision support, urban planning, geotechnic, hydrology, hydraulics, and transport, as well as management of surveys on digital cartographic support; find, visualize, process, integrate and analyze cartographic data from various sources (municipal, regional, national cartographic geo-portals, ...); identify the most suitable cartographic data and the necessary elaborations to obtain the expected result; evaluate the obtained obtained as a function of the metric resolution of the cartographical data and the expected accuracy. Students will also execise and develop the following transversal skills and competences (soft-skills): teamwork with a collaborative and constructive attitude; strategic and critical thinking; effective communication and argumentative skills. The class will thus enable Open Badges related to the previously mentioned soft-skills: functional literacy - advanced level personal competence - advanced level social competence - advanced level learning to learn competence - advanced level project creation competence - advanced level PREREQUISITES None. TEACHING METHODS Frontal theoretical lessons followed by lessons in the computer room to put into practice the concepts learned during the theoretical lessons. In the second half of the lessons, following the presentation of the topics on which the exercises will be carried out, the students will be divided into small groups (2-4 members) and asked to "lead" one of the exercises. The students will then have to work in groups and reflect on what data to look for, how to process it and what strategies to adopt in order to carry out the exercise to which they have been assigned, and pass on their findings to the rest of the class for constructive discussion. The class is taught in Italian but slides and references are available in English. Working students and students with certified SLD (Specific Learning Disorders), disability or other special educational needs are advised to contact the teacher at the beginning of the course to agree on teaching and examination arrangements so to take into account individual learning patterns, while respecting the teaching objectives. SYLLABUS/CONTENT Introduction to GIS tools Geographic Information Systems (GIS): operating logic and basic functionality, overview of application areas, existing software (especially free and open source) Numerical Cartography: conceptual and logical data models (raster and vector, fields and entities), nominal scale and resolution, topology, metadata and the European directive INSPIRE Recalls of Reference Systems and most used cartographic projections Reference systems and cartographic projections: their characteristics, the international EPSG codes, the process of georeferencing GIS Data Sources The official Italian cartography: features and availability Digital Terrain Models (DTM): characteristics, data structures, (interpolation methods) Photos and Orthophotos: notes on optical characteristics, acquisition procedures, storage formats; characteristics of orthophotos and satellite images LiDAR and GNSS data: hints Introduction to GeoWebServices: availability of geographic data and their use via web Introduction to GeoDataBases: their structure and SQL queries Introduction to QGIS Project setup and data import into QGIS Visualization and integration of multiple data sources Importing WMS services and OpenStreetMap data Management and simple analysis of DTMs in QGIS Image management and georeferencing Operational exercises Morphological analysis of a DTM Analysis of basins Management and analysis of river sections and/or flood areas Analysis of landslide susceptibility of a territory starting from geomorphologic, environmental and human factors predisposing to landslides Analysis of cartography of hydro-geological risk propensity and impact on built areas and/or population (ISTAT data) Analysis of the built area of a residential center from the point of view of age, type of structure, architectural constraints, ... Analysis of land transformations through comparison of technical and thematic cartography or georeferenced historical images Analysis of transport network for the territorial planning or the management of an emergency or the tourist fruition Spatial analysis of observed data for environmental monitoring Management of data from field surveys (GPS tracks and images) Example of publishing GIS maps on the web RECOMMENDED READING/BIBLIOGRAPHY Class notes and materials provided to students. Texts for further study: C. Cambursano, 1997. "Numerical Cartography." Ed. Progetto Leonardo, Bologna. F. Migliaccio, D. Carrion, 2016. "Spatial information systems. Principles and applications." UTET University. ISBN 978-88-6008-475-0 TEACHERS AND EXAM BOARD ILARIA FERRANDO Ricevimento: The office hours for students shlould be set with the teacher by email (ilaria.ferrando@edu.unige.it) or by message on Microsoft Teams. PAOLA SALMONA Exam Board ILARIA FERRANDO (President) ALESSANDRO IACOPINO ALI ALAKBAR KARAKI PAOLA SALMONA STEFANIA VIAGGIO BIANCA FEDERICI (President Substitute) DOMENICO SGUERSO (President Substitute) LESSONS LESSONS START https://corsi.unige.it/8715/p/studenti-orario Class schedule The timetable for this course is available here: Portale EasyAcademy EXAMS EXAM DESCRIPTION Oral exam (in Italian or in English), with the presentation and the discussion on an application realized by the students in small groups (2-4 components) and verification of the knowledge of the theoretical concepts of the class. ASSESSMENT METHODS The exam consists in an oral test in which students present (via slides) and discuss an application made in small group (2-4 components). The application is typically inspired to the guided exercises carried out during the lectures, with appropriate insights, but can be agreed with the teacher on the basis of specific interests of students, for example a GIS analysis to be carried out as part of other classes or preparatory for the final thesis. During the exam, the theoretical knowledge of the fundamental concepts for a correct management of geographic data is also ascertained (reference systems and cartographic projections, resolutions and precisions, basic processing techniques). The final grade takes into account the quality of the presented application (originality, type of application, employed processing techniques and analysis, strategies for solving any problems encountered), the critical discussion of the obtained results, the expositive capacity, and the knowledge of theoretical concepts. Exam schedule Data appello Orario Luogo Degree type Note 18/12/2023 12:00 GENOVA Orale 15/01/2024 12:00 GENOVA Orale Aula A6, Villa Cambiaso - padiglioni 15/01/2024 12:00 GENOVA Orale 07/02/2024 12:00 GENOVA Orale 07/02/2024 12:00 GENOVA Orale 15/02/2024 12:00 GENOVA Orale 28/05/2024 12:00 GENOVA Orale 25/06/2024 12:00 GENOVA Orale A6 (Villa Cambiaso - padiglioni) 17/07/2024 12:00 GENOVA Orale 10/09/2024 12:00 GENOVA Orale FURTHER INFORMATION It is preferred, but it is not mandatory, that the application is carried out in small groups consisting of 2-4 students. It is preferable, but it is not mandatory, that the entire group takes the exam in the same exam round. It is requested that the slides of the presented application are delivered during the examination, either by sending them by email or by delivering them on a CD, DVD or USB stick. Agenda 2030 - Sustainable Development Goals Quality education Gender equality Reduce inequality Sustainable cities and communities Life on land OpenBadge PRO3 - Soft skills - Alfabetica base 1 - A PRO3 - Soft skills - Personale base 1 - A PRO3 - Soft skills - Sociale base 1 - A PRO3 - Soft skills - Alfabetica avanzato 1 - A PRO3 - Soft skills - Personale avanzato 1 - A PRO3 - Soft skills - Sociale avanzato 1 - A PRO3 - Soft skills - Imparare a imparare avanzato 1 - A PRO3 - Soft skills - Creazione progettuale avanzato 1 - A