New Course: QField Quickstart

QField is an open-source Android based mobile data collection and/or viewing application that is tightly integrated with QGIS.

QGIS is used to set up the project using standard QGIS tools.

If the layers in your project are stored in a PostGIS database and a mobile data connection is available then changes made in QField are made directly to your database and visible in real-time to anyone that has a client to your database. This, in my view, is the mobile data collection killer app.

Continue reading “New Course: QField Quickstart”

Working with PostGIS data from within Leaflet.js (or any other client side mapping API)

This 3-part mini-course is my attempt to explain the basic concepts of working with PostGIS data from within the Leaflet.js mapping API.  Technically this is not Leaflet programming. In this scenario Leaflet.js simply becomes the canvas on which your geospatial data is displayed on a web map.  All of the interaction with the geospatial data occur through very common and standard methods of working with enterprise level databases, but with a geospatial twist. Continue reading “Working with PostGIS data from within Leaflet.js (or any other client side mapping API)”

Deploying a PostGIS Database Parts 5 and 6 – Performance considerations

In these two videos I discuss performance considerations when choosing a hosting service for your PostGIS database, how to determine if you should invest in higher download speeds on the client side or better performance on the server side, and strategies for mitigating slow response times. Continue reading “Deploying a PostGIS Database Parts 5 and 6 – Performance considerations”

Deploying a PostGIS database Part 4 – The AcuGIS Cloud

In this video I show how to deploy your PostGIS database to a second remote server option, the AcuGIS Cloud.  In general my perception is that getting started with AcuGIS was much easier for general GIS use than A2 hosting. They focus on GIS and they know GIS. Installing PostGIS was a breeze, they have the latest versions of both PostgreSQL and PostGIS available, they have all the extensions for PostGIS, and they have shp2pgsql and raster2pgsql available right in their control panel which simplifies loading your data. Continue reading “Deploying a PostGIS database Part 4 – The AcuGIS Cloud”

Deploying a PostGIS database Part 2 – Web hosting service

This video goes through the process of signing up for a web hosting service with A2 hosting. You can literally have an instance of PostGIS up and running in half an hour for under $5/month that can be accessed from your own web map or from other clients such as QGIS.

What makes A2 Hosting so good for GIS applications is that they offer PostgreSQL databases in their standard cPanel package which means that you can easily install and use PostGIS. Most web hosting services only offer MySQL although you may be able to have them install PostgreSQL for you. Continue reading “Deploying a PostGIS database Part 2 – Web hosting service”

Getting started with PostGIS

For many years I had been hearing about spatial databases. I knew that some of the frustrating issues I was dealing with as the GIS specialist for small environmental consulting companies could be addressed with the technology.  But consulting is all about billable hours and its really hard to convince your boss to give you the unbillable time needed to figure it all out. And its really hard and probably unethical to expect a client to let you figure it all out on their dime. So until a few years ago I kept chugging away with single-user file-based data storage and wasted an enormous amount of time managing data and people to prevent conflicts that could have easily been prevented with a spatial database.  Continue reading “Getting started with PostGIS”

Working with SpatiaLite databases in QGIS 3.0

This video provides a brief introduction into what a SpatiaLite database is, why you might want to use one, and how to load data and create virtual layers in QGIS 3.0. (If you are using QGIS 2.xx you’ll be able to figure it out as well)

This is one lecture of an entire course on QGIS 3.0 for GIS professionals that will be available on Udemy.com when QGIS 3.0 is released (currently expected Dec 8) so keep an eye out for it if that will interest you.

If you want to learn more, check out What can a spatial database do for you? and Quick start to spatial databases with QGIS and SpatiaLite