Adding XYZ Tiles to a QGIS Project

QGIS natively supports adding XYZ tiles to projects as background layers, from multiple sources. Here is a basic walkthrough as to how to connect XYZ tile services to your QGIS project. Open a QGIS Project and navigate to the ‘XYZ Tiles’ option in the Browser panel. Right click and select ‘New connection…’ In the XYZ […]

Converting a String Field to a Numerical Field in QGIS

Numerical data saved as a string in a PostGIS table column needs to be converted to a numerical data type to be properly analyzed. Below is a process by which to convert string data to real numbers in QGIS. Open the layer with the improper string column in QGIS, and toggle editing mode by selecting […]

Translating Vector Geometries

Translating geometries involves displacing vector data using a pre-defined offset distance from the current position of the data. In this case, we will be using this data to alter UAV flight paths (vector line data). This will involve shifting the paths to the East, West, North, or South, depending on the orientation of the flight […]

Adding Mapbox Tiles to QGIS 3.4

Mapbox has an excellent tiling service that has both a ton of basemaps and an easy-to-use mapping system for web applications. It is possible to use their tiles in QGIS as a basemap. The steps are relatively simple and will be covered below. Create a Mapbox account by going to Login in and create […]

Adding basemaps to QGIS project

Web based basemaps can provide an excellent context for a mapping project. Map services such as OpenStreetMap and Bing provide tile services that can be used to fill in details such as topography, road networks, hydrography and satellite imagery for a map without having to provide your own set of base features. Quick note on […]

Creating user groups in PostgreSQL

In larger work environments it becomes essential to be able to assign similar permissions to groups of people for the database environment. PostgreSQL has a built in authentication system that easily allows for this. As with the rest of this documentation, this section assumes a PostgreSQL installation on a Debian based Linux distribution. We use […]

Logging in to PostgreSQL database on Linux terminal

This section assumes command line access to the PostgreSQL server from a terminal window. The server used in this section is running Ubuntu Linux 18.10. To Log into your user account in the database: psql -U <postgre username> -d <dbname> Logging in to root PostgreSQL user account If you are the database administrator and need […]

Changing user access permissions on PostgreSQL schemas

This section assumes command line access to the PostgreSQL server from a terminal window. The server used in this section is running Ubuntu Linux 18.10. Once logged into the terminal either locally or over SSH, log in as the root database user “postgres” by typing: sudo -i -u postgres Or if you don’t have access […]

Importing Common Static Data to QGIS

Importing Static Data to QGIS This section will focus on basic importing of static geospatial data to QGIS project files for use. This will not cover the use of PostGIS or PostgreSQL for data management. Common standard files types will be included. Adding Favorite Directories QGIS allows the user to add ‘favorite’ directories to the […]

Running a remote PostGIS database (Linux)

This document uses Ubuntu 18.10 in conjunction with PostgreSQL 10 with PostGIS. Similar concepts should apply to other installations. It assumes PostgreSQL has been installed with the PostGIS extensions already. Initializing the database to run on server startup Either open the terminal in your Linux server or open an SSH session to your server and […]