Digital Geography

Colaborative Working in PostGIS

The last days I needed to work with other geoenthusiasts on a PostGIS database. Unfortunately, as you upload a layer from QGIS you will be the owner of the new created table and no one is able to alter it by default. Here I show you, how to change this using some “trigger functions” and some shared roles.

Short Note: export layers to PostGIS with Processing

When using QGIS along with PostGIS you might want to publish data directly from inside QGIS into your PostGIS database. This is not only convenient as you don’t need to change the software of use but also easier as it only takes a drag and drop in QGIS instead of any commandline/fancytool. Yet it comes with a disadvantage: the number of inserts from QGIS into the db is limited to 200 per transaction. So it will take some time to insert a bigger dataset with 150.000 points or so. So how to overcome this?

PostgreSQL and PostGIS: A brief introduction

You probably seen this already (maybe on your very own PC as well): A folder with shape files. Well we’re living in the 21st century and I do have and use those folders still. After a talk of Sebastian Meier at Maptime Berlin I was convinced and started to work with a databases instead of folders. So let me show you how to install PostgreSQL along with PostGIS on Ubuntu and Windows, how to get data into it, import OSM data and how to connect it with QGIS/ArcGIS.

How to organize geodata storage?

In the past I’ve learned one thing: the only chance to do efficient geodata-projects is to have a clean data structure.
In this post I’ll show you some tools and share my thoughts about organizing (geo)data to have more efficient project-workflows. After that I would be very interested in your solutions and approaches to do smart data-projects.

How to use OpenStreetMap, guides for beginners and advanced users on LearnOSM.org

OpenStreetmap is the fastest growing community mapping project of all times. Beside the “normal” map result, what you can use for your daily navigation through cities and countries like Google Maps, OpenStreetMap allows you to get the geodata and use it for your own ideas and projects (with some licence regulations). For many peoples the difficult part is not getting the data but the usage and adoption. Therefore the Humanitarian OpenStreetMap Team created LearnOSM.org.

HeidiSQL vs. pgAdmin III – a small speed-test

HeidiSQL, a free database-client, now supports PostgreSQL/PostGIS in the newest nightly builds. Using HeidiSQL with MySQL was always a pleasure and I often had the feeling that the pgAdmin III client of PostgreSQL is slow and not very user-friendly in some points. Because of this I had to test the difference of performance of these two clients. I don’t want to talk about features and handling because this is on the one hand a matter of taste and on the other hand the support of PostgreSQL is very new in HeidiSQL. Instead, I want to compare some simple SQL-queries in…

OpenSource QGIS + PostGIS installation: “the Windows way”

A short time ago I’ve posted an article on the installation of QGIS in combination with a PostGIS database in the background. As we all know, Windows is mostly used as OS on a PC so this is the Windowized version. This is a short summary that sums up the article of a site called Boston GIS. I’ll show you how to install QGIS version 1.8 (which will be updated in some days) and PostgreSQL with PostGIS extension and show you the first steps in the import of shapefiles and raster data.

OpenSource QGIS + PostGIS installation: “the Ubuntu way”

A lot of you out there are probably working on Windows Systems using ArcGIS and I have to admit that the possibilities with ArcINFO in the background and a proper GDB (GeoDataBase) are really big. But let’s be honest: A lot of your tasks are more or less everyday business, right?! So let us have a look on building a GIS workplace using QGIS 1.8 (which will be updated the big way in some days/weeks) and PostGIS which is a spatial enhancement of PostgreSQL.