Blog GIS & Territories

GIS coaching for territorial management.

  • Blog – English
  • Tutorials
    • Leaflet Initiation
  • All Content
  • Old Maps
  • About/Contact
  • English
    • Français
    • English
    • Español
    • Português

Category: Database

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
25 May 202321 May 2023 Atilio Francois No Comments
  • Database
  • PostgreSQL
  • QGis

Loading Geopackage data into PostreQL/PostGis with QGis

Among the different options to load data in Postgresql, we will see here the one that, in my opinion, is the easiest and fastest. We will simply use QGis and its Database Manager.

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

Replicating a postgresql database in a windows workstation

We will configure a logic   replication of a database table of our linux server in a postgresql installation in a windows workstation. The replication allows us to keep an updated copy of the centralized database in a remote…

Read More

Posts pagination

1 2 Next »

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

Recent articles

  • Leaflet tutorial: session 6
  • Leaflet tutorial: session 5
  • Leaflet tutorial: session 4
  • Leaflet tutorial: session 3
  • Leaflet tutorial: session 2

Recent comments

  1. Atilio Francois on Portable version of QGis 3.32.015 May 2025

    What is the link between the qgis update and the portable version? A portable version cannot be updated; it must…

  2. Hugo on Portable version of QGis 3.32.014 May 2025

    For me, the error message complaining that qgis_app.dll is missing started appearing following the most recent QGIS update.

  3. Atilio Francois on Portable version of QGis 3.32.07 May 2025

    Hello The problem with the portable version is that it's very dependent on the particular configuration of the machine. The…

  4. NotFred on Portable version of QGis 3.32.07 May 2025

    I have never had QGIS installed in my machine (it's a brand new laptop) and I get the same error,…

  5. Atilio Francois on Portable version of QGis 3.32.028 April 2025

    The file is present in the download ...\QGIS 3.32.0\QGIS 3.32.0\apps\qgis\bin The error message probably comes from a previous installation of…

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 (10)
    • PostgreSQL (7)
    • Spatialite (3)
  • english posts (20)
  • Felt (3)
  • Geoserver (5)
  • GIS and management (2)
  • Lidar (10)
  • Non classé (207)
  • Outils divers (2)
  • QGis (36)
  • webmapping (6)

  • Blog – English
  • Tutorials
  • All Content
  • Old Maps
  • About/Contact
  • English
Copyright 2018. All rights reserved | Theme: Blog Mantra by LilyTurf Themes