Blog GIS & Territories

GIS coaching for territorial management.

  • Blog – English
  • Tutorials
    • Leaflet Initiation
  • All Content
  • Old Maps
  • Plugins QGis(en)
    • S57Manager(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

Recent comments

posts

  1. Atilio Francois on [EN]Download QGIS 3.44 LTR Portable for Windows (Full Version)4 August 2026

    Excellent, thank you for running this test! This is actually very good news. Your `curl` download completed successfully, downloading the…

  2. Robert Pace on [EN]Download QGIS 3.44 LTR Portable for Windows (Full Version)3 August 2026

    I added the -v flag to the curl for more verbose response. C:\Users\quepi>curl.exe -v -L -O https://www.nasca.ovh/downloads/QGIS%203.44.0.7z * Trying 213.186.33.16:443...…

  3. Atilio Francois on [EN]Download QGIS 3.44 LTR Portable for Windows (Full Version)3 August 2026

    Thank you again for your detailed feedback. I have now performed several additional tests from my side. The file downloads…

  4. Atilio Francois on [EN]Download QGIS 3.44 LTR Portable for Windows (Full Version)3 August 2026

    Thank you for the detailed feedback. The fact that the download fails at different points (258 MB, 359 MB, etc.)…

  5. Robert Pace on [EN]Download QGIS 3.44 LTR Portable for Windows (Full Version)3 August 2026

    Hi Atilio, I have tried the download from my home pc/network and at work via work laptop on the universities…

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 (13)
    • PostgreSQL (9)
    • Spatialite (3)
  • english posts (20)
  • Felt (3)
  • Geoserver (5)
  • Geospatial Technologies (4)
    • Spatial Analysis & GIS (4)
  • GIS and management (2)
  • IA(en) (3)
  • Lidar (10)
  • Logique floue (2)
  • Non classé (207)
  • Outils divers (2)
  • Outils et méthodes (5)
    • Images (5)
  • Postgis (4)
  • QGis (86)
    • Plugin (32)
    • Tutorial (6)
  • S57 (5)
  • 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