-
Visualizing housing price trends with QGIS, part 1 - Data overview and some queries
So let’s have a look at the data! All property sales are stored as a row in a PostGIS enabled PostgreSQL database table. For every sale, there is information about e.g. the property type (villa, apartment, plot of land etc), the number of rooms, the sales date and price. And of course, since this will eventually be about geospatial analysis, the location is available as a PostGIS geometry datatype.
-
Visualizing housing price trends with QGIS, part 0 - Introduction
This is an introduction to a series of posts to document the results of some self-study sessions carried out during the Covid-19 pandemic period, with its times of isolation and short-term layoffs. Geospatial analysis is very useful for many industries and this was a great opportunity to deepen my knowledge in the field. I have focused on QGIS, which is a massive open-sourced piece of GIS software (Geographic Information System), providing a stack of tools from backend data access to visualization and map generation.
-
Notes on PostGIS, OpenStreetMap and QGIS
Preface: This post is mainly a collection of notes on installation and basic usage of a few important tools for geo-spatial analysis. It is a work in progress.