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 …

Esri 2014 – Recap

The Esri conference is over for another year. I wanted to write something about it.  It is almost a requirement to write a recap of a conference. At the same time, there are really enough of those, and who honestly wants to read another missive about what sessions, or parties, or workshops I went to? Fortunately, while at a networking …

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 …