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]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