2019 FOSS4G Bucharest Talks speaker: Astrid Emde

The speaker's profile picture


Fun with Foreign Data Wrappers (FDW) and PostgreSQL

With Foreign Data Wrappers (FDW) you can access remote objects from SQL databases. This feature is part of the SQL/MED (SQL Management of External Data) specification that was added to the SQL standard.

With PostgreSQL you can make use of this great functionality. You can access different remote datasources via FDW for example an ORACLE or MySQL database, JSON- or CSV-file, sources via ODBC and even twitter.

The list of FDW is very long: https://wiki.postgresql.org/wiki/Foreign_data_wrappers

There are also Geospatial Wrappers for GDAL/OGR, GeoJSON and OpenStreetMap. You can access your geospatial data for example geopackage or OGC WFS via FDW. That is easy and great fun.

Some of the wrappers support only read others support read/write access.

The presentation will give an overview on the possibilities of Foreign Data Wrappers and show how to setup a connection to remote data using some examples with geospatial data.

Create Web Application 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 is based on the frameworks Symfony, JQuery and OpenLayers.

Mapbender has an administration web interface to do all the work or if you prefer YAML you can configure applications via YAML-file.

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.

This presentation will give an introduction on Mapbender and the possibilities.

What’s new in OSGeoLive 13.0 ?

OSGeoLive is a self-contained bootable DVD, USB thumb drive or Virtual Machine based on Lubuntu, that allows you to try a wide variety of open source geospatial software without installing anything. It is composed entirely of free software, allowing it to be freely distributed, duplicated and passed around.
It provides pre-configured applications for a range of geospatial use cases, including storage, publishing, viewing, analysis and manipulation of data. It also contains sample datasets and documentation.
OSGeoLive is an OSGeo project used in several workshops at FOSS4Gs around the world.

OSGeoLive 13.0 will be released at the end of July 2019 ready for FOSS4G 2019.
Still working on the improvements initiated for OSGeoLive 12.0, it will embedded latest stable version of a vast choice of Open Source Geospatial software. The work on the geodata science with Python and R stacks have also been continued. Documentation is also a big building area and we made a proposal to Google Season of Docs in order to get it even better. We would like to encourage people around the world to help us translate it.
This presentation will reflect what we did for OSGeoLive 13.0, what choices have been made, what we plan to do for 14.0 and after.