Digital Geography

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.

Show your Photos in QGIS and ArcGIS: a small example

Hi guys. Once again I found an interesting question in our Geoscientists group on facebook. One user wanted to show her photos in QGIS as she is it used from Google Maps: See a point, click on it and see the great image you’ve taken on your journey. Unfortunately the most obvious plugins failed to do it in QGIS. So check out our “at least” two usage scenarios for QGIS and ArcGIS where we will handle geotagged photos…

ArcGIS Earth

When I visited university (I have t admit, this was some years ago 😉 ) I was told ArcGIS cannot “do” 3D. This was the part where CAD enters the arena… But time goes by and together with ArcGIS 10.4. we will get 3D as it is meant to be.

AHP for ArcGIS 10.x using Python

When it comes to site selection problems or suitability models, the spatial Multi-Criteria Analysis (Weighted Overlay) is the most commonly used method. It’s easy, simple and popular. However, if it’s your first time to come across this method, it’s highly recommended to have a look at this link. After defining the problem you want to solve, the next 4-steps are followed to perform this method. Determine significant layers. Reclassify the layers. Weight the input layers. Sum up the weighted layers My concern was always about how I can assign a weight to each layer in a kind of scientific way.…

Geocoding Addresses in ArcGIS: the other approach

Today I stumbled upon a post from the German ESRI office and their blog gisIQ and a little tutorial (English translation) on how to geocode addresses in the ArcGIS platform. I was asking, whether there is a possibility to use other geocoders as well and so I tried to build my own solution without credits and with the possibility to choose a geocoder. Fortunately the Python world offers some nice little scripts. So let’s use geopy!

ArcGIS Open Data

For a year, ESRI’s open data initiative is online. As I’ve heard about it for the first time I was just thinking: nice move to get people into their ArcGIS online environment. But I have to admit: I was not looking and exploring their platform. Now I stumbled upon a recent post on reddit and there it was again: opendata.arcgis.com has 25,000+ open datasets all accessible by a common API. Full disclosure: I work on the team that builds the product. So let’s have a look at it…

GISconnector for Excel

GISconnector for Excel – the beginning of a beautiful friendship between ArcGIS and Excel The GISconnector transforms ArcGIS and Excel into an ingenious overall system: The power of Excel is available in ArcGIS and vice versa – ArcGIS and Excel turn into an integrated working environment. This unique combination enables a smooth transfer of data and functions between the two programs – this works without an editing session. The GISconnector for Excel software completely revolutionizes the way you work with ArcGIS – a giant step towards time saving and error minimization. 2 Add-ins communicate with each other: Use the shortest…

Posts 2014: our Top Ten List

Yesterday I received the mail from Anita Graser’s blog about the best 10 articles on QGIS planet. Therefore I decided to have a look on our own top ten list of most read articles this year. And I have to admit: It’s not the open source world who leads this list…

ArcGIS 10.3

Yesterday the new major release of worldwide leading GIS solution ArcGIS was released: 10.3. Most users upgraded already to the version 10.x and enjoyed Python support as well as other enhancements. So what is to expect from this new version? 64 bit support, Twitter integration, free support? Let’s have a look!

SciPy integration in ArcGIS

Most of GIS users today will probably work with ArcGIS. Since version 10 the implementation / integration of Python into the ArcGIS framework and ArcPy it’s important for ArcGIS users to be aware of the capabilities of using Python in batch processing tasks, data manipulation and the broad possibilities of Python itself (eg. Numpy, Sympy etc.). SciPy will another topic for the future…