GIS coaching for territorial management.
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
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
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
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
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
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