08-22, 09:00–13:00 (Europe/Rome), 208
PostgreSQL is a powerful, open source object-relational database system. It can be extended with PostGIS which allows you to store and handle geospatial data in the database.
This combination is very powerful and allows you many possibilities.
Everything is possible with some magic lines of SQL. This workshop will help you with the first steps.
Many processes that you did before with you Desktop GIS (f.e. intersection, union, buffer) can be easily done via SQL using PostGIS functions.
In the workshop you will get to know the databasemanagement sytem PostgreSQL and the extension PostGIS. There will be an introduction to PostgreSQL and SQL and you will learn SQL basics to create and modify data.
You also will get to know the concept of PostGIS and how geodata is stored in the database. You will get an overview about the enormous possibilities of PostGIS. In the workshops hands-ons we will concentrate on 2-dimensional data and we will use OSGeoLive for demonstration.
You will learn how to store, import and use geospatial data in the database. With QGIS you will discover how easy it is to bring your data to the database and out of it.
You will learn how to analyse and modify your data and learn how to make transformations, intersections, length/distance calculations, buffers, unions and more.
Everything is possible with some magic lines of SQL.
Find Workshop information and material:
- https://trac.osgeo.org/osgeolive/wiki/Live_GIS_Workshop_Install
- https://github.com/astroidex/foss4g-2022-workshop-manage-your-geospatial-data-with-postgresql-postgis-astrid-emde/blob/main/foss4g-2022-workshop-manage-your-geospatial-data-with-postgresql-postgis-astrid-emde.md
Workshop will use OSGeoLive Version 15.0.
Astrid Emde is a Geospatial Expert and works in Bonn at WhereGroup since many years and works as Senior GIS Consultant on WebGIS solutions with FOSSGIS. Astrid Emde is an active member of OSGeo and a Charter Member since 2010. From 2017-2021 she was in the OSGeo Board of Directors and is OSGeo Secretary. She recieved the Sol Katz Award in 2018 at FOSS4G 2018 in Dar es Salaam (Tanzania).
Enock is a craft OpenStreetMap contributor and community member from Ghana, West Africa and studying M.Sc. Cartography. He promotes and advocates using Free and Open Source Software and Communities of Practice. He was a member of the Local Organizing Committee for FOSS4G 2021 Dar es Salaam (Tanzania). He volunteers in the OSGeo Marketing Committee and OSGeoLive PSC as well.