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):

In this article we will discuss, in detail, how to detect and rectify geometric problems in a PostgreSQL / Postgis table using SQL queries.
Continue reading “How to rectify the geometry of a Postgis table”

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 manage PostgreSQL databases is by using the pgAdmin4 GUI.

This tool is setup automatically during PostgreSQL installation. You can launch it from the programme bar:

Continue reading “Start with PostgreSQL / Postgis -Introduction to pgAdmin 4”

Geoserver avanzado: el teselado (puesta en práctica)

En el artículo anterior (Geoserver avanzado: las teselas (principios)) vimos los diferentes conceptos para el teselado de mapas.

En este artículo veremos cómo implementar estas funciones en Geoserver. Continue reading “Geoserver avanzado: el teselado (puesta en práctica)”

Advanced Geoserver : tiling (quick start)

In the previous article (Advanced Geoserver: tiling (principles) we have explored the different concepts regarding the tiling mapping.
In this article we will discuss how to implement those applications using Geoserver.
In order to run the tiling, Geoserver uses an external module called GeoWebCache. Continue reading “Advanced Geoserver : tiling (quick start)”