[JT] Jochen Topf's Blog


OSMData on Cloud Servers

Since March the OSMData Service has been running on new servers sponsored by FOSSGIS e.V. I wrote about the switch in an earlier blog post. Now, half a year later, I want to write about my experiences with the new setup.

| Read more…

Tags: openstreetmap · openstreetmapdata · osmdata

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