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.
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, 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…
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.
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.