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.


Andreas Scherbaum