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