CODE 98963 ACADEMIC YEAR 2022/2023 CREDITS 6 cfu anno 3 SCIENZE GEOLOGICHE 8763 (L-34) - GENOVA 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 2 SCIENZE DELL'ARCHITETTURA 8694 (L-17) - GENOVA 6 cfu anno 3 SCIENZE DELL'ARCHITETTURA 8694 (L-17) - GENOVA SCIENTIFIC DISCIPLINARY SECTOR ICAR/06 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 2020/2021) EEXPERIMENTAL PHYSICS 25934 2020 PHISICAL GEOGTRAPHY AND CARTOGRAPHY 52415 2020 MINERALOGY 57251 2020 PALEONTOLOGY 64866 2020 GEOLOGY 1 72871 2020 ENGLISH 72877 2020 GENERAL AND INORGANIC CHEMISTRY WITH LABORATORY 87055 2020 ELEMENTS OF MATHEMATIC 95338 2020 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 current geo-services available via the web 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 environment, in different interdisciplinary areas of study. The use of free and open source geographic software (GFOSS) and the expertise acquired in the management of geographic data ensure that the teaching contributes to the following Sustainable Development Goals of the UN 2030 Agenda: Goal 4: Provide quality, equitable and inclusive education and learning opportunities for all Goal 10: Reduce inequality within and between nations Goal 15: Protect, restore and promote sustainable use of the Earth's ecosystem AIMS AND CONTENT LEARNING OUTCOMES The class provides operational GIS (Geographic Information System) tools for search, visualize, query, managet and simply analyze digital cartography and geo-referenced data. It allows to address concrete 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 of management and analysis of 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), for the resolution of concrete 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 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 work in a group and critically expose their work 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. 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 students by email (ilaria.ferrando@edu.unige.it). BIANCA FEDERICI Ricevimento: By appointment, by calling (+39) 010 335 2421 or sending an e-mail (bianca.federici at unige.it) or a message on Teams Exam Board ILARIA FERRANDO (President) ALESSANDRO IACOPINO ALI ALAKBAR KARAKI 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 groups (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 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 and the expositive capacity, and the knowledge of theoretical concepts. Exam schedule Data appello Orario Luogo Degree type Note 16/01/2023 09:00 GENOVA Orale 16/02/2023 09:00 GENOVA Orale 30/05/2023 09:00 GENOVA Orale 27/06/2023 09:00 GENOVA Orale 19/07/2023 09:00 GENOVA Orale 08/09/2023 09: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. 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