Skip to main content
  1. Tags/

PostGIS

weeknotes 64: torrential rain

Stuff from the last week:

I’ve been running through my ankiboxes and considering the purposes of my different IW queues and associated ankiboxes a little more closely.

I redesigned part of my homepage. The “recent feed” part now has two columns – one for blog posts and another for weeknotes. Both of these things live under the /blog/ section of my site but I figured out a way to list them separately as well as altogether, as demonstrated by my new homepage and my new index pages: blog.html and weeknotes.html and archives.html

I started a new lab page – my first since 2019 apparently – for “geolab” my personal PostGIS server. I’ll be adding to this incrementally as I refine my slightly messier note I’ve been working on for the last few weeks.

I managed to get caught in torrential rain twice in the last week. The second time I was slightly more prepared and had an umbrella, but honestly I didn’t end up that much better off ha!

GEOG 868: Mapping the Class Roster

class roster map

In Lesson 3 of GEOG 868 I played around with PostgreSQL and PostGIS for the first time. For the project at the end you are given a class_roster.txt file that contains a list of students and their postal codes. The task was to join that with data provided earlier in the lesson and then plot the students’ locations on a map in QGIS. Here’s how I went about doing that.