GIS coaching for territorial management.
Starting with QGIS version 3.42, a subtle but powerful feature has been added to the context menu of vector layers: the “SQL Query…” option. This improvement provides a direct and user-friendly interface for running SQL queries,…
Read More
History of Parquet and GeoParquet 1. Apache Parquet – The original format History: Objective: GeoParquet – Geospatial extension of Parquet History : Year Event 2021 (April) First exchanges on GitHub and in open source communities to…
Read More
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
At the end of the Leaflet introductory course, the final mini-project looked like the following map: With a map displaying geojson data, a mini-map and a title. This screenshot was taken on a PC and looks…
Read More
Introduction: What is the MBTiles format? The MBTiles format is a file format for storing map tiles (raster or vector) in a SQLite database, a lightweight, stand-alone database engine. Initially designed by Mapbox, this format has…
Read More