FOSS4G 2019 Bucharest Workshops speaker: Astrid Emde

The speaker's profile picture


Learn how to create web applications for your needs with Mapbender

Mapbender is a content management system for geospatial data services and map applications. With Mapbender you can create applications without writing a single line of code. Mapbender is a flexible client for OGC services. Mapbender is based on Symfony, JQuery and OpenLayers.

Mapbender has an administration web interface to do all the work. Mapbender helps you to set up a repository for your OWS Services and to create individual applications for different user needs. An application can provide search modules, digitizer functionality, print & more.

You have access control and can provide applications for defined users and groups.

In this workshop you will learn how to create web applications with Mapbender.

We will create a great application for Bucharest with local WMS Services, search and digitize functionality.

PostgreSQL/PostGIS for Beginner

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 successfull and allows you many possibilities.

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

Setting up a Spatial Data Infrastructure (SDI) with Open Source Software using OSGeoLive

This workshop provides a practical, overview of key software used within a Spatial Data Infrastructure (SDI). It will be useful for a business people and techies with little or no experience with the range of Open Source Geospatial software, and who would like first hand experience with these tools.

In the workshop we will use OSGeoLive and the Open Source software and sample data shipped with it to get to know the components of an SDI. We will get our hands dirty using some of the leading applications, and will introduce the other applications on OSGeoLive and when they are used.

A Spatial Data Infrastructure (SDI) is a data infrastructure that provides geographic data and metadata, which is accessible for several users and incorporates a variety of tools to accomplish different processes. It helps make data accessible, maintainable and findable throughout your organization.

We will start with different types of geographic data and learn about how to store data in a PostgreSQL/PostGIS database.

As second step, we will have a look at a service based infrastructure and you will learn about OGC services like OGC Web Map Service and OGC Web Feature Service. You will learn how to create these services with software like QGIS Server, MapServer or GeoServer. We will practice with QGIS server.

A client is needed to view and analyse data from services. We will learn about Desktop GIS and WebGIS and load Services in QGIS and publish data to the web using OpenLayers, GeoNode and Mapbender.

We will learn about metadata and how to make data traceable in a metadata system like GeoNetwork or pycsw. We will practice with pycsw and GeoNode.

And you will learn how you can control the access to your data and setup a user management.

After the journey through all the components you will be familiar with the concept and the advantages of a Spatial Data Infrastructure, and will know where to look for deeper insights into the more powerful features of the various tools.