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: Postgis

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
6 May 20263 May 2026 Atilio Francois No Comments
  • Postgis

[EN]ST_Intersects vs ST_Within: Understanding Spatial Relationships in PostGIS

When working with PostGIS, understanding spatial relationships between geometries is essential for building efficient queries. Two of the most widely used functions—ST_Intersects and ST_Within—are often confused, yet they serve different purposes. In this guide, you’ll learn…

Read More
1 October 202514 October 2025 Atilio Francois No Comments
  • Postgis

PostGIS 3.6 released – 3D, raster, and topology take a leap forward

New version: PostGIS 3.6.0 (Released September 2, 2025) PostGIS 3.6.0 has been available since September 2, 2025. It is designed to work with PostgreSQL 12 through 18 beta 3, requires GEOS 3.8+ (with optimizations for GEOS…

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

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