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. 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…

  2. 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…

  3. Atilio Francois on How to develop an application with pgrouting in Windows (1)25 August 2025

    You're right — since 2019 Geofabrik no longer provides plain `.osm` files, only the compressed `.osm.pbf` format. The tool **osm2pgrouting**…

  4. Simon on How to develop an application with pgrouting in Windows (1)25 August 2025

    The osm downloads don't appear to be available, just osm.pfb And osm2pgrouting on Windows doesn't like pbf "not well formed…

  5. Arno on Portable version of QGis 3.32.021 August 2025

    I just want to thank you. It works.

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 (80)
    • Plugin (26)
    • 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