This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2023

Add geocoordinates to your addresses in PostgreSQL

Date: 2023-12-14
Time: 13:40–14:30
Room: Nadir

Geolocation data is a hot topic. A lot of data includes an address, a street name, a zip code, and a country. But where exactly is this address? And what's around this address?

To solve these questions, addresses need to be resolved to geocoordinates. The better and more precise the address data, the better the chance to find the correct coordinates.

This talk shows how addresses can be resolved using OpenSteetMap data, from within the database, using Python functions.

We also talk about the accuracy of the data by comparing the results of different address formats to known coordinates.


This session has been made available on:


The following slides have been made available for this session:


Andreas Scherbaum