For this project, I created a Python pipeline in Jupyter Notebooks that ran through a large database provided by MnDOT. This pipeline generated 200+ informational layouts about intersections, road curves, and road segments and exported them to PDFs. Each layout had 30+ fields that were filled out using a SearchCursor that ran through the database. This pipeline reduced workload and allowed the team to make changes easily and efficiently.

Click to Open in New Window

Image Source: The Scholary Kitchen

Freeway removal is a topic in transportation that is often opposed due to fears of increasing commute times. This project explored the changes in vehicle service area and length, or how far someone can get from one point or how far someone can be away to reach a point. The change was compared before and after the removal of I-94 between downtown Minneapolis and downtown Saint Paul. This report summarized the methods used to build the network dataset and service area analysis layers. It showcased the results and compared the differences in service areas before and after the removal of the freeway. This report also validated the results by comparing the network to ESRI’s network dataset and discussed the results and lessons learned.

This was a Survey123 form I created manually using an XLS Form. The purpose of this form was to enable project managers to request data. This data came in the form of videos of intersections that needed vehicle and/or pedestrian turning movememts counted. This tracking form enabled project managers to select the exact locations they wanted counted, input deadlines, billing information, client information and what type of turning movement needed to be counted. This form also connected to a web map on ArcGIS Online, which allowed project managers to visualize where data has been collected to avoid redudancy. This form allowed the traffic department to streamline data collection tracking.

In this research project, I explored the critical topic of transportation equity in the Twin Cities region, utilizing the power of GIS to analyze planned transitways and demographics. This project focused on transit routes, including the Orange Line, Blue Line Extension, Green Line Extension, Gold Line, and Rush Line. Through the application of GIS tools and spatial analytics, I gained valuable insights into how these transit routes would serve transit-dependent populations. By analyzing demographic data of people living near these transit stops and comparing it to county-level statistics, I uncovered crucial information about the equity of these transit services. My project underlines the significance of equitable access to public transportation and the need to hold government agencies accountable for meeting the diverse needs of the community.

For this project, I was part of a team designated to do data collection work for the University of Minnesota at the Saint Paul Campus. For my team, I created a Survey123 form that collected locations of road crossings and their ADA compliance. This survey collected location, condition, and an image of each crossing. After the data was collected, the data was randomly sampled and validated by other members. Once the data was confirmed to be accurate, the data was cleaned up and submitted as a geodatabase. A report was prepared that outlined the data collection process and any significant findings.

Click to Open in New Window