Posts

Analysing crime statistics for Brisbane

crime

The Qld government’s Open Data Portal provides the crime location API. This API gives us a list of reported offence, type of office and geographic location (such as suburb…

Efficiently dissolving adjacent polygons by attributes in a large GIS database

GIS

PostGIS

Using PostGIS to efficiently dissolve adjacent polygons by attributes in a large-table with >750k rows of data.

Spatial KDE plots in Python

GIS

In this notebook, I generate spatial kde plots in Python using Matplotlib and Seaborn.

Animated scatter plot with size legend with matplotlib

animation

matplotlib

I have been looking at generating animated plots using Matplotlib, with the official documentation providing an excellent example for basic animations.

Zonal statistics: mean elevation of brisbane suburbs

GIS

DEM

As part of my geospatial analysis journey and the mapping of various things in Brisbane, in this notebook I will look at the digital elevation data of Brisbane suburbs.

Import GeoJSON files into a PostGIS database

python

gis

When importing data in a GeoJSON file to a PostGIS database, we will do so using Python and apply the following process:

Visualising preference flows in 2024 QLD state elections

sankey

elections

I have recently written a dashboard to explore the preference flows of votes during the 2024 QLD state elections. The dashboard is available here.

Converting long DOIs to short DOIs

go

When writing a paper recently, I came across the shortDOI service that creates short aliases for long DOIs. For example, instead of a long DOI like 10.1016/j.virusres.2019.19…

Running agent-based model simulations on the browser with Go

go

agent-based-modelling

I’ve been thinking about sharing interactive examples of some agent-based models for a while. And I had always thought of putting the code behind a running Python kernel…

Visualising Earthquakes in Nepal

python

notebook

gis

data analysis

In this notebook, we will download data about earthquakes in Nepal from USGS and produce a dashboard to explore the data interactively.

Visualising Earthquakes in Nepal

GIS

earthquakes

In this notebook, we will analyse the earthquakes that occurred in Nepal since 2010.

Testing DuckDB’s spatial extension’s Integration with GeoPandas

python

gis

notebook

Having read about DuckDB’s spatial extension, I wanted to check if I could integrate DuckDB into my workflow. I primarily use GeoPandas for my spatial tasks within the…

Using mamba solver with conda

note

python

How to use the mamba solver with conda without installing mamba

Amend last git commit

note

If we forget to include some file(s) with a git commit, or want to change the commit message, the git commit --amend is a convenient method.

Formatting markdown tables

note

We can easily format a markdown table in vim using pandoc. Starting with the below table

Moving matching lines to end of file in vim

note

In vim, we can move all matching lines to the end of the file using the global command (g).