The world of Geospatial is, like any other technology, going to have some inherent risk. Part of making a program stronger should be looking at those risks and planning strategies to mitigate them. This article covers risks and mitigations in three sections, Program, Technology, and Operational, then wraps up with a recap and final thoughts.
Tip of the Day – Create indexes for all spatial and attribute tables
Today’s Tip Create indexes for all spatial and attribute tables Discussion Today’s tip arises as a result of setting up layers using a Foreign Data Wrapper in Postgres. The layers were initially loading quite slowly, and I realized that I had not added a UniqueID, which I mentioned in TOTD 002, or any sort of an index. Before we get …
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 2 – PostgreSQL
This is the second in a series of posts that will look individually at a number of different database formats. I will discuss installing and basic configuration, as well as how to enable support of spatial data types in the database. This post will be on the open-source RDBMS, PostgreSQL. The first step is going to be obtaining the software. …
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 …
The Command Line – What’s the Use?
The title of this post is in some ways rhetorical because to some people, this is their primary means of interaction with a computer. With the majority of people, though, I think a safe assumption is that the command line is something they have heard about, but don’t really understand where it is, or even, why they would want to …
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 …