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 …