Blog GIS & Territories

GIS coaching for territorial management.

  • Blog – English
  • All Content
  • Old Maps
  • About/Contact
  • Forums.
  • EnglishEnglish
    • FrançaisFrançais
    • EnglishEnglish
    • EspañolEspañol
    • PortuguêsPortuguê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
  • Database
  • QGis
  • Spatialite

How to create a SpatiaLite database with QGis

If you start to feel tired of managing your data as shape files (this format dates back to the eighties!) and you yearn for a genuine database for your projects, most certainly, you will be looking…

Read More
  • Non classé
  • PostgreSQL

How to rectify the geometry of a Postgis table

We have already discussed the topic of geometry validation through a series of articles (in french): GIS tools for validation of geometries (1) Geometry validation GIS tools (2): Spatiality and PostGis Geometry validation tools (3): FME…

Read More
  • english posts
  • PostgreSQL

Start with PostgreSQL / Postgis -Introduction to pgAdmin 4

Following up a previous article (Débuter avec Postgres/Postgis ), we will address an introduction to Postgres/postgis database management. We will load a shapefile, connect and load the Postgis layer from QGis. The most  suitable method to…

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