Elisa Puccioni

The existence of Free and Open Source Geospatial Software relies on its Community. Yet, the challenge persists: how can we accomplish this when our lives are filled with constant busyness? Join us to hear insights from our Community Leaders about initiating and nurturing a vibrant and active community.

Come together to focus our collective intelligence on making our Community better. We expect a lively exchange between our panelists and our audience. We will have Slido set up for you to submit your questions anonymously or you can ask from the floor, just signal to one of our volunteers to bring the mic to you. Afterwards, stay for the entertainment of the all-in lightning talks! Facilitator: Eli Puccioni

Come and learn the news about OsGeo Oceania grants from one of the Grant Committee most enthusiastic member. The grants are open to all community members and have already been used across the Pacific to help organising events and activities in the open source spatial field.

A 5 minutes summary about what is the Grant Program, what types of grants you can apply for, and how they can and have been used to help the Pacific open source community.

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.*