[JT] Jochen Topf's Blog


SotM 2022 and the OSM data model

It’s two weeks after the State of the Map 2022 in Florence and its high time I write this blog post. I had a great time and can only agree with what Ilya said in the closing session, how great it was to see everyone again (or for the first time) after such a long dry spell (Ilya’s words were much better though).

| Read more…

Tags: data model · openstreetmap · sotm

OSM and PostgreSQL/PostGIS talk at SoTM

I was recently at the State of The Map conference in Heidelberg. The SoTM is always a lot of fun, lots of old friends to see again and new people to meet. And lots of talks to listen to, which I mostly skip, because there are so many interesting people around to talk to in person. And all the talks are available on video, so I can watch them in the weeks and months ahead. I also gave a talk myself, on OSM Data Processing with PostgreSQL / PostGIS, a tour de force through “everything” related to OSM and PostgreSQL/PostGIS. In an hour I covered a huge amount of ground from basics of relational databases and spatial data formats to the tools used to importing OSM data into the database. I am glad this talk is available on video, too, and I hope it will help people getting an overview over this huge topic in years to come. You can watch the talk and get the slides on my web page.

| Read more…

Tags: openstreetmap · postgis · postgresql · sotm

SOTM Talks

A few weeks back I gave two talks at the State Of The Map 2013 conference. One about Osmium, the other called “Towards an Area Datatype for OSM”. The slides and videos from both talks are now available on my talks page. Thanks to Peter Barth for “liberating” the videos from the 8 hour long flash-only videos put up originally.

Tags: conference · event · openstreetmap · sotm · talk