Posts

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

python

notebook

data analysis

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.

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