Digital Geography

Geospatial cloud solutions: Software-as-a-Service vs Roll-your-own

Over the last couple of years, we have seen an increase in demand and offerings of geospatial solutions in the cloud for tasks like web map creation, centralized data storage and management, data vizualization and so on. There is a lot of Software-as-a-service (SaaS) options to explore, but in this article I want to briefly discuss if SaaS is the right thing for you, or wether you should look into rolling your own.

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…

Geodatabases

In my years at the university i was playing around with a lot of data. These were sorted “somehow” and totally distributed. after a short while i have lost control and my pc behaved like HAL… One advice: USE GEODATABASES! YOu can see here how to do that using ArcCatalog