Blog

Viewing posts for the category PostGIS

Using NOTIFY to automatically refresh layers in QGIS

Posted by: Tim Sutton | in PostGIS, QGIS | 3 weeks, 4 days ago | Comments

One of the most brilliant but little-known features of QGIS is the ability to trigger layer refreshes and events in response to notifications from PostgreSQL. This was developed by the wizards from Oslandia and is easily added to any existing table in your PostgreSQL database - including PostGIS tables. This feature was added in version 3.0 (see https://qgis.org/en/site/forusers/visualchangelog30/#feature-trigger-layer-refresh-or-layer-actions-from-postgresql-notify-signal). Take for example this simple table:

Adding elevation to a line from a DEM in PostGIS and maintaining accurate measures

Posted by: Gavin Fleming | in PostGIS, QGIS | 8 months, 1 week ago | Comments

This is the second in a three part series on the behind-the-scenes GIS work that can go into planning a complex event, in this case the Cape Town Marathon.

How to create a point distance marker layer along a line in PostGIS

Posted by: Gavin Fleming | in GRASS GIS, PostGIS, QGIS | 8 months, 2 weeks ago | Comments

This is part 1 of a 3-part series.

Setting up geogig in a production environment

Posted by: Admire Nyakudya | in Docker, GeoServer, PostGIS | 10 months ago | Comments

GIS practitioners and developers have long been interested in versioning spatial data. Luckily the folk at LocationTech have enabled us to do so through the provision of GeoGig (formerly geogit). Moreover, Geogig can interact with GeoServer seamlessly. At Kartoza we use Docker for orchestration of our services and as such it will form the backbone of this article.

Alternatives to Google Maps Engine

Posted by: Gavin Fleming | in Boundless Suite, FOSSGIS, GeoServer, PostGIS | 4 years, 2 months ago | Comments

Google will be supporting Google Maps Engine (GME) for only one more year. If your company uses GME or was thinking about it, you'll need to consider alternatives. Kartoza offers various alternatives depending on your use case. We are BoundlessGeo partners and offer support for the OpenGeo Suite in southern Africa. For more details of the Google announcement, including various scenarios where you should consider the OpenGeo Suite, see BoundlessGeo's take on it.  Kartoza also offers development, support and training services across other components of the FOSS GIS stack that offer alternatives to Google and other proprietary products - we'd love to hear from you!

Orchestrating GeoServer with Docker and Fig

Posted by: Gavin Fleming | in Docker, FOSSGIS, GeoServer, PostGIS | 4 years, 4 months ago | Comments

In this article I will detail how to set up a simple orchestrated system of docker containers using:

Template by Blacktie Mezzanine theme by CodingHouse