QGIS and PostGIS Labs

The following project links are labs that I performed with a combination of QGIS and PostGIS softwares. The extent that each software is used is outlined within each lab.

Return to Main Index Page.

Lab One

Here, I developed a replicable model to measure the distance and direction of census tracts from a single location. In this lab, I use Chicago as my example.

Lab Two

Employing the spatial model outlined in Lab One, I examine if rent prices in the greater Burlington, Vermont urban area follow a spatial pattern based around Burlington’s center business district (CBD).

Lab Three

In this lab, I used OpenStreetMap (OSM) data of Dar es Salaam, Tanzania, to measure the urban resiliency of the most flood prone regions of the city. To do so, I developed an annotated and replicable SQL analysis workflow to take the original OSM input data sets outlined in the lab and create the analyzed output data, which I then used to create an interactive map hosted by Leaflet.

Lab Four

A question of replicability. For this lab, I attempted to replicate the Malcomb et al. study on Malawi’s environmental resilience. As a group, my class colleagues and I collaboratively brainstormed to develop a probable SQL analysis flow to replicate the paper’s results. Through the process of this lab, I encountered two different issues related to the unclear methodology of Malcomb et al. and use of inaccessible data sources which only enabled me to create a partial replication.

Lab Five

In this week’s lab, I used geospatial Twitter data, collected from a Twitter API in rStudio, to compare the spatial effect of Hurricane Dorian’s projected path and the Sharpiegate controversy on Twitter activity. I analyzed this data using rStudio functions, a SQL script I developed on PostGIS, and the Getis-Ord G* spatial statistic to find the normalized difference between different groups of tweets.

Lab Six

How long does it take to walk to school? In this lab, I conducted a network analysis topology of roads and pathways in Dar es Salaam, TZ and a measurement of their intersection frequency using data from OpenStreetMap.

Return to Main Index Page.