Open-Source GIS Architecture for Small Municipalities
Why GIS for a Local Municipality This post presents a case study on building an open-source GIS for municipalities - specifically, a small municipality in Bosnia and Herzegovina. Like most…
QGIS and PostgreSQL: Schema-Based Access Control for Multi-Department Workflows
In the previous article, we demonstrated how to configure basic data access control in a PostgreSQL/PostGIS database by defining editor and viewer roles. This approach built a solid foundation for…
Street Lighting Warranty Monitoring – PostgreSQL Upgrade with Interactive Dashboard
📝 Introduction Street lightning warranty monitoring is essential for improving maintenance planning and reducing operational costs. In my previous post Monitoring Street Lighting Warranties in QGIS, I showed how to…
QGIS and PostgreSQL: Setting Up Editor and View Access for Multi-User Data Management
In modern GIS workflows, multiple users often need to access the same spatial data without compromising its integrity.Combining QGIS with a PostgreSQL/PostGIS database provides a secure and efficient solution. This…
Monitoring Street Lighting Warranties in QGIS
Monitoring street lighting warranties in QGIS provides an efficient way to manage public infrastructure. This tutorial showcases a practical example that tracks bulb type, installation date, and warranty expiration using…
Geographic Coordinate Conversion Tools – WGS84 ↔ MGI Map Converter
Looking for a simple and accurate way to convert coordinates from WGS84 to MGI? This free online coordinate conversion tool is designed for geospatial professionals, surveyors, and GIS analysts. Whether…
How to Connect a PostGIS Database to GeoServer – Guide
Introduction This guide explains how to connect a spatial database in PostgreSQL/PostGIS with GeoServer, publish spatial layers as a WMS service, and then display them on a web map using…
How to Connect PostGIS to QGIS – Guide
Need to connect PostGIS to QGIS and access your spatial database directly inside your GIS project? This guide shows you how to quickly add PostgreSQL/PostGIS layers into QGIS using the…
Creating Arrows in QGIS Following Digitization Direction
When it's important, you can use QGIS symbology to display the digitization direction of lines.To do this, follow these steps: first, open QGIS and add your vector file.Right-click on the…