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 4.0 Portable for Windows (Full & Lite Versions)5 June 2026

    Thank you for your feedback and for reporting these issues. The errors and the missing Processing functionality that you observed…

  2. Andrea on [EN]Download QGIS 4.0 Portable for Windows (Full & Lite Versions)5 June 2026

    I've downloaded today the 7z file from https://www.sigterritoires.fr/QGis4.0Lite, then unarchived it and then launched launch_qgis_portable.bat: various errors occurs https://dcmnt.eu/pad/#/2/pad/view/-6FZXEyJYV4SyZmDWWE4XW6M7l-1JGp0V67X4tBTdjg/embed/ and…

  3. Andrea on [EN]Download QGIS 4.0 Portable for Windows (Full & Lite Versions)5 June 2026

    It's not clear what are exactly the components that are missing in the "QGIS portable – lightweight version". Could you…

  4. Ed on [EN]Download QGIS 3.44 LTR Portable for Windows (Full Version)2 June 2026

    Thank you for your service to the community! Please know that you are greatly appreciated! We prefer using the Long…

  5. SERGIO SEBASTIAN VERDU on [EN]Download QGIS 4.0 Portable for Windows (Full & Lite Versions)27 May 2026

    Hi Atilio, I'm very interested in downloading these versions of QGIS, but I've tried several times and the download never…

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 (84)
    • Plugin (30)
    • 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