Blog GIS & Territories

GIS coaching for territorial management.

  • Blog – English
  • Tutorials
    • Leaflet Initiation
  • All Content
  • Old Maps
  • Plugins QGis(en)
    • FuzzyAttributes(en)
  • About/Contact
  • English
    • Français
    • English
    • Español
    • Português

Tag: sql

10 September 20258 September 2025 Atilio Francois No Comments
  • QGis

Union in GIS: choosing between overlay, merge, unary union, and dissolve

Understanding the different types of unions in GIS Spatial union is one of the fundamental operations in geomatics. It allows you to combine multiple layers or entities to produce new geometries or enrich attributes. However, behind…

Read More
18 June 202511 June 2025 Atilio Francois No Comments
  • QGis

QGIS: A New “SQL Query” Option in the Layer Context Menu

Starting with QGIS version 3.42, a subtle but powerful feature has been added to the context menu of vector layers: the “SQL Query…” option. This improvement provides a direct and user-friendly interface for running SQL queries,…

Read More
4 June 20254 June 2025 Atilio Francois No Comments
  • Postgis
  • PostgreSQL

ENC maps in QGis with Postgis(1)

This subject comprises two articles. The first deals with importing ENC S57 files into a Postgresql/postgis database. The second deals with setting up an automatic symbology equivalent to nautical charts. You can download all the scripts…

Read More
  • english posts
  • PostgreSQL

Spatial analysis with SQL: 5- aggregation function (ArcGis Union)

In Article previous we have discussed some SQL functions for spatial processing . In this article we will see a function a little more complicated to put at work: the aggregation function for two layers of…

Read More
  • Non classé
  • PostgreSQL

How to rectify the geometry of a Postgis table

We have already discussed the topic of geometry validation through a series of articles (in french): GIS tools for validation of geometries (1) Geometry validation GIS tools (2): Spatiality and PostGis Geometry validation tools (3): FME…

Read More

Mastodon Follow me on Mastodon
Voir le profil de atilio francois sur LinkedIn

Recent articles

  • Union in GIS: choosing between overlay, merge, unary union, and dissolve
  • Fuzzy logic and GIS (2/2): from transformation to aggregation of spatial data
  • Fuzzy logic and GIS (1/2): an alternative to all-or-nothing for geographic analysis
  • Exporting a QGIS layout to SVG: uses, limitations, and solutions
  • Associating points with their municipality or zone: simple spatial joins with MMQGIS

Recent comments

  1. Atilio Francois on How to develop an application with pgrouting in Windows (1)25 August 2025

    You're right — since 2019 Geofabrik no longer provides plain `.osm` files, only the compressed `.osm.pbf` format. The tool **osm2pgrouting**…

  2. Simon on How to develop an application with pgrouting in Windows (1)25 August 2025

    The osm downloads don't appear to be available, just osm.pfb And osm2pgrouting on Windows doesn't like pbf "not well formed…

  3. Arno on Portable version of QGis 3.32.021 August 2025

    I just want to thank you. It works.

  4. Atilio Francois on Portable version of QGis 3.32.015 May 2025

    What is the link between the qgis update and the portable version? A portable version cannot be updated; it must…

  5. Hugo on Portable version of QGis 3.32.014 May 2025

    For me, the error message complaining that qgis_app.dll is missing started appearing following the most recent QGIS update.

All articles by category (click on a category to display article extracts)

(You can copy the RSS link for each category separately)

  • ArcGis (1)
  • Arcgis Pro (1)
  • bibliography (1)
  • Database (12)
    • PostgreSQL (9)
    • Spatialite (3)
  • english posts (20)
  • Felt (3)
  • Geoserver (5)
  • GIS and management (2)
  • Lidar (10)
  • Logique floue (1)
  • Non classé (206)
  • Outils divers (2)
  • Postgis (1)
  • QGis (55)
    • Plugin (11)
  • webmapping (9)

  • Blog – English
  • Tutorials
  • All Content
  • Old Maps
  • Plugins QGis(en)
  • About/Contact
  • English
Copyright 2018. All rights reserved | Theme: Blog Mantra by LilyTurf Themes