↓Skip to main content
  1. Tags/

PostGIS

GEOG 868: Mapping the Class Roster

·6 mins
GIS SQL CLI database design map design cartography PostGIS pgcli ogr2ogr QGIS

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.