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
Category: Database
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 MoreReplicating 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 MoreHow 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 MoreHow 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 MoreStart 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