Tip of the Day – Ensure you have a Unique Identifier for each table in your database

Today’s Tip Ensure that you have a unique identifier attribute for each table in your database Discussion This is another tip that arises from me doing a task, and realizing I forgot something critical. In this case, the task involved creating a table, trying to perform an operation on said table, and encountering an error or limitation due to a …

GIS Enabled Database Part 1 – MySQL

The first step in putting together an open source suite of GIS software is to install some sort of storage medium for your spatial data.¬† There are many options out there, ranging from the ESRI personal geodatabase, which uses a Microsoft Access database, to a fully relational database management system like PostGreSQL with PostGIS.¬† Each post in this series will …

QGIS – Vector Data Connection

Update – April 2017 Many things have changed with QGIS over the last few years since this post was written. I thought it worth the time to revisit the topic and expand its scope. Please take a look at my new post: QGIS – Loading Data —————– One of the major differences between many COTS applications and Open-source is in …