10-16, 08:00–12:00 (Pacific/Auckland), WF413
The aim of this workshop is to learn creating, managing, and using a spatial database hosted in PostgreSQL server. We will see how to install and connect to PostgreSQL, and then how to create users and databases, install the PostGIS extension, and load data and manage them through QGIS.
PostgreSQL is the most powerful of the open-source databases, used widely in many organisations and with a wealth of training available for free online. Still, it can be daunting to be approached without previous experience.
This workshop aims to give a basic introduction of working with spatial data in a PostgreSQL database server by showing the attendants how to install a local PostgreSQL server, connect to it, create and manage users and privileges, and create a spatial database with the PostGIS extension. Then we will move to spatial data and learn how load spatial tables, assign primary and foreign keys, and manage the data both with QGIS and other open-source database management programs.
During the workshop, Elisa will also share all the lessons learned in the last 5 years of working with PostgreSQL and the dos and absolutely-don'ts that the attendants need to be aware of (capital letters, anybody?).
This workshop is hands-on.
Prerequisite skills:
- Attendees should be familiar with QGIS
Preparation required:
- Own laptop with enough memory and space to install and run
- PostgreSQL https://www.postgresql.org/
- QGIS LTR or v3.32+ installed https://www.qgis.org/en/site/
Book your ticket here: https://ti.to/osgeo-oceania/foss4g-sotm-oceania-2023-workshops.
A total of 25 spaces are available.
Elisa a senior GIS analyst and DBA with over 18 years of experience in GIS and database administration. She has been working with most of the proprietors and open-source GIS packages and recently moved all her company's spatial databases from MSSQL to PostgreSQL server, a feat that she's not looking to repeat soon!
Elisa was born in Italy and moved to New Zealand in 2008, where she currently resides.
She is a great supporter of GIS open-source software as she strongly believes that everybody should be able to know and use GIS, especially people belonging to minority groups or living in remote areas. For this reason, she's got involved with the OsGeo Oceania community, serving as board member for two years, and currently happily distributing its money to the community by running the Grant and TGP programs.