Skip to content

🌍 Blog#

Geotribu in English, translated or original blog posts around GIS and geo*.

Working with JSON in PostgreSQL

logo JSON

As part of a personal project, I wanted to store a large part of the INSEE's french census data in a PostgreSQL database with multi-millennial tables. The problem is that, within the same dataset, the fields can change over the years, which makes it impossible to create a fixed table structure. The solution? Use semi-structured data, i.e. store this data in JSON in a table field. This article is a summary of that experience.

Unscheduled obsolescence

This work was carried out before the release of PostgreSQL 17, which adds important features for JSON with JSON_TABLE, so it won't be mentioned here.

Since we're going to be talking about JSON and semi-structured data, I feel obliged to start this article with a warning.

The relational model is good, eat it up, and integrity constraints were invented for good reason.

This article is not intended to be an invitation to go into YOLO mode on data management: “all you have to do is put everything in JSON” (like a vulgar dev who would put everything in MongoDB, as the bad tongues would say).

Upcoming local FOSS4G in Bulgaria on 7th-8th March

QGIS.бг is an informal organization that brings together the Bulgarian FOSS geo enthusiasts. In the landscape dominated by proprietary software, the QGIS.bg is providing learning materials at beginner and advanced level, in Bulgarian language, for free to anyone who wants to know more about open source GIS and technologies.

QGIS.bg logo

Installing QGIS on Ubuntu: a simple and effective guide

Ubuntu logo

It may sound surprising, but installing the most widely used open-source GIS software on the most popular Linux distribution is still not as seamless as it should be. Even experienced users sometimes struggle with repository configurations, package dependencies, authentication keys and other system administration intricacies.

Geographer taming a penguin

The challenge isn't just technical. QGIS's official installation documentation, while thorough, can be difficult to navigate for those who aren't developers or seasoned Linux users. Plus, regular updates and changes in the software lifecycle can introduce unexpected hurdles for everyday users.

That said, there's no point in complaining, it’s free software and open-source contributors deserve appreciation, not frustration! And I speak from experience. 😉

Follow the Vendée Globe 2024 from a GIS

What is the Vendée Globe?

logo Vendée Globe

Before we start talking about GIS and technical aspects, let's talk about the Vendée Globe.

It is a solo sailing race, non-stop and without assistance, around the world. It has been held every 4 years since 1989. The start is in Les Sables d'Olonne. The course consists of going down the Atlantic, then passing successively under Africa and the Cape of Good Hope, under Australia and Cape Leeuwin and finally under South America and Cape Horn, to return to Vendée as quickly as possible. The record was set by Armel Le Cléac'h during the 2016-2017 edition with a journey of 74 days 3 hours and 35 minutes.

map

Creating a Python virtual environment for developing QGIS plugin with VS Code on Windows

Introduction

PyQGIS logo

Anyone who has tried it, knows that configuring a Python, PyQGIS, and PyQt environment on Windows for developing QGIS plugins is a real challenge. Often, it feels like a losing battle...

Well, not anymore! After scouring the depths of the internet and exploring tips provided by Julien, here is one method to have (almost) all the auto-completions for PyQGIS, PyQt and more in VS Code.

Introducing QChat: a chat room right into QGIS!

icône globe speech GIS Chat - Credits: Global Market by DARAYANI from Noun Project (CC BY 3.0)

We're excited to announce the release of a new feature integrated into our QTribu plugin for QGIS: QChat! This new addition allows you to collaborate in real time with your team or other GIS fellows directly from QGIS.

We're in 2024 (unless you're reading this in 2025, or 2026, or... well, you get the idea), and let's be honest, Teams or IRC have their cons. Plus, you can't even use the hashtag #GISchat there, you can't meet fellow GIS enthusiasts and you definitely can't win Geotribu stickers 😉... Honestly, it's time for something new.

Introducing a new way to chat directly in QGIS: QChat, a feature that lets you communicate with your peers within the best desktop GIS software around. The question is: why? And the answer: why not?