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 – Use Descriptive Database Table Names
Discussion Today’s tip came to me after I was trying to link some tables into my database, from another database. What I saw in that database looked something like this: ce410ap sf200xp jj310fe Repeat this for a couple of hundred tables. This structure, I feel, is a holdover from the old days of taking a database and normalizing it to …
QGIS – Loading Data
Accessing data in QGIS A few years ago now, I wrote a post covering adding vector layers to QGIS. Much time, development, and improvement has passed since then. Since the usefulness of QGIS increases proportionally with your ability to actually add data to it, it is time to revisit this topic. QGIS has a toolbar strictly for adding data. It …
Tip of the Day – Use only the data layers you need to make your point
Today’s Tip Use only the data layers you need to make your point Discussion This tip arises as a way of fighting the shiny object syndrome. You know how it goes, you get a new data layer, or new aerial photos, and you want to include them in everything. So, you do, whether they should be there or not. I’m …
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 …