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

Category: Database

13 May 20268 May 2026 Atilio Francois No Comments
  • Database
  • Postgis

[EN] Optimizing PostGIS Queries: A Practical Guide to Improving Performance

Spatial databases can contain millions of geographic objects. In some cases, a PostGIS query may take several seconds — or even several minutes — to execute. This problem often occurs when: In this article, we will…

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
28 May 202528 May 2025 Atilio Francois No Comments
  • PostgreSQL

Postgis:table with multiple geometries

List partitioning in PostgreSQL/PostGIS is a declarative partitioning method that divides a large table into several sub-tables, according to the discrete values of a column (e.g. by region, type, year, etc.). This is particularly useful in…

Read More
27 June 202325 June 2023 Atilio Francois No Comments
  • PostgreSQL
  • QGis

Topology, did you say topology?

This article explores the fundamental concept of topology in GIS (Geographic Information Systems) and its application in the modeling and analysis of geospatial data. It examines in detail the different aspects of topology, such as spatial…

Read More
22 June 202318 June 2023 Atilio Francois No Comments
  • QGis
  • Spatialite

Eliminate overlaps and gaps between polygons in a layer (with QGis and Geopackage)

We’ll take up the example covered in the article Eliminating overlays and gaps between polygons in a layer (with QGis and Postgis) to see the same type of solution when you don’t have a PostgreSQL/Postgis database.…

Read More
20 June 202322 June 2023 Atilio Francois No Comments
  • PostgreSQL
  • QGis
  • Spatialite

Eliminate overlaps and gaps between polygons in a layer (with QGis and Postgis)

For those unfamiliar with the joys of working with the French cadastre, you should know that if you have the opportunity to work with cadastral data corresponding to “Lieux-dits” (a subdivision of communes) you’ll find that…

Read More

Posts pagination

1 2 Next »

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

Recent articles

Recent comments

posts

  1. Atilio Francois on [EN]Portable QGIS 4.0 for Windows – Download and use QGIS without installation5 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]Portable QGIS 4.0 for Windows – Download and use QGIS without installation5 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]Portable QGIS 4.0 for Windows – Download and use QGIS without installation5 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 Portable version of QGis 3.44.0 – Updated Version with Python Fixes and Authentication Support2 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]Portable QGIS 4.0 for Windows – Download and use QGIS without installation27 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 (81)
    • Plugin (27)
    • 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