Digital Geography

Import OSM Data Into A PostGIS Database (The Easy Way)

I often find myself in a situation where I want to work with large areas and datasets of OpenStreetMap data. No matter if you want to use them in a QGIS map or create custom map tiles in Tilemill, with the Overpass API you quickly run into performance issues. Imposm is a great tool to overcome that situation, so you can load OSM extracts (worldfiles in pbf format) with a custom data mapping into a PostGIS enabled PostgreSQL database. The downside: It is hard to set up if you are not a database and system admin guru. This is where…

Routing in QGIS… with OSM

Routing with Google is quite cool as the database/network is probably the best currently available. But the terms of services limit the possible usage. So what about OpenStreetMap? By figuring out how to use OSM for routing I found it much easier to get routes into QGIS with OSM compared to the Google way. Check it out….

Using OpenStreetMap on your GARMIN

Since most people working with digital-data they are always interested in obtaining their own data using a Global Positioning System (GPS). Therefore I’ll give a short introduction for all of you, using a GARMIN device and like to have a free background map on the screens. There’ll be also the possibility to make routings to certain addresses or Points of Interest. Although the OpenStreetMap Wiki gives some explanations and tipps on bringing OSM to your device, there are some easier ways to do so. But first we have to clarify the question if your device can handle with OpenStreetMap-data: The following devices…

geocoding addresses directly in LibreOffice Calc

In a recent post I’ve described a way to geocode in a Google Spreadsheet quite easily. Now let’s move a little bit away from this crazy web 2.0 stuff and get a little bit more desktop orientated: Let us geocode addresses directly in LibreOffice (and OpenOffice probably as well). We will do this using the googlemaps API. If you are really into open stuff we show OSM geocoding as well.

Kurznotiz: Hilfe zu OpenStreetMap

OpenStreetMap ist ein wunderbares Projekt, dass ähnlich dem Wikipedia-Prinzip arbeitet und eine freie Weltkarte erstellen will. Damit ist das Projekt auch schon ganz gut fortgeschritten. Wer sich über den derzeitigen Stand informieren will, wird hier fündig. Inzwischen hat sich OpenStreetMap auch zu einer unersetzlichen Quelle entwickelt, wenn man günstig Kartographie erstellen möchte, sowohl für Print als auch fürs Web.