The course of Computer Science and GIS within the three-year degree in Geological Sciences aims to provide students with the basic principles of geomatics as a study of geosciences through the use of computer methodologies supported by digital acquisition technologies of complex and plurimathematical data (e.g. geological soil data, digital aero-photogrammetries, satellite images, GPS data, hydrogeological data, geotechnical parameters, lithological, etc ...). The course also aims to provide an overview of the GIS environment operating instruments, with particular reference to the operation of Georeferencing; Digitization; interpolation; Extraction and Statistical processing. More specifically, the course aims also to provide students with useful and versatile tools, transversal to all geosciences, aimed at acquiring; integrating; analyzing; treating; storing; distributing and making geo-referencing spatial data also from an interoperable point of view.
PROGRAM OF INFORMATICS AND GIS
A.A .: 2017/18
Degree Course in Geological Sciences Class L34
GIS Front Lectures: 3 CFUs (21 Hours)
GIS Computer Classroom Laboratory: 3 CFUs (36 hours)
1st part: Introduction and IT basics for GIS applications
Meaning of the concept of geomatics and its actualization and potential evolution. Geological mapping: the former geological maps and evolution of the concept of geological mapping up to the CARG project. Overcoming of the static monothematic cartography and the advent of the dynamic pluritematic cartography. Digitizing cartographic data: raster data, vector data, shape and kml files. Basic concept of geodesy and use of the major georeferencing systems and relative georeferncing methods. The advent of GIS: open source and proprietary GIS. Data storage techniques: the relational databases; geoscientific data with potential geographic primitive. Interoperable databases and the use of markup languages: GeoSciML and the INSPIRE protocol.
Practical exercises in the classroom
Discretization and Data-Storage of Geological Information: Directory and Sub-Directory of the Earth Sciences Database. A practical tutorial on georeferencing systems and methods. Building and managing relational databases in the Access environment and GIS environment. Visualization and consultation of the main geoscientific portals: PCN, One Geology, Auscope, SITR, geological map of Piemonte region, Earthchem, PetDB, MetPetDB, Georoc, Sesar.
2nd part: Design and implementation of a GIS in the field of geoscience
The different GIS Platforms: ArcGIS vs. QGIS. The environment and the menus of QGIS and ArcGIS; ArcCatalog vs. QGIS browser. ArcGIS extensions vs. QGIS plugins; Toolboxes vs. SAGA. Geological data: basic map data, official geological maps, local detailed mapping maps and specialized geosciences cartographies. Sampling Techniques: the informatic conceptualization of outcrop and field measuring station. In situ analysis: penetrometric tests, hydrogeological and geophysical data etc ... Laboratory analysis (sample and sub-sample concepts, Lab techniques at different observation scales) and the concept of redundant information, different typologies and examples of analysis and related typologies of data storage. The transition from the Geographic Information System to the Local Information System. Interpolation techniques: Spline, IDW and Kriging, the use of IG-mapper for statistical interpolation of geochemical data.
Practical exercises in the classroom
Managing the Table of Contents (ArcGIS) and the Layers Panel (QGis). View map data and operations on the associated alphanumeric databases. Sequential operations for the extrapolation of derivative maps (e.g. Slope, Exposures etc...) using the ArcGIS model builder. Vectorization and creation of shape files. Overlapping of diversified geothematical maps and extrapolation of derived data. The connection between projects with variable reference systems: the GIS-LIS passage. Examples of geostatistical interpolations: Spline, IDW and Kriging. The use of the IG-Mapper and the statistical interpolation of geochemical data.
Titolo ECDL GIS. La rappresentazione cartografica e i fondamenti del GIS
Autore Caiaffa Emanuela
Editore McGraw-Hill Education (collana College)
Titolo Python Scripting for ArcGIS
Autore Paul A. Zandbergen
Editore ESRI press