FOSS4G 2023

Pedaling towards Progress: An Analysis of Capital Bikeshare Trips in Washington D.C. using Open-Source Geospatial Tools
06-28, 16:30–17:00 (Europe/Tirane), UBT C / N110 - Second Floor

In this presentation, we showcase a unique approach to analyzing Capital Bikeshare trips in Washington D.C. using Open-Source Geospatial (FOSS4G) tools and technologies. Our project involved loading trip data into a PostGIS database, utilizing the Valhalla routing engine and OpenStreetMap data to find the optimal routes between each pair of stations, and then constructing a topogeometry table to represent these routes. Using this topogeometry table, we are able to estimate the number of Capital Bikeshare trips that occur on each road in Washington D.C.

The use of FOSS4G tools and technologies allowed us to perform this analysis in a cost-effective and efficient manner, while also providing high-quality results. The results of our analysis have important implications for urban planning and mobility research, as they can be used to understand the patterns and impacts of bike-share usage in cities.

Our presentation will provide an overview of the methodology used in our project, as well as a discussion of the results and their implications. We will also share our experiences using FOSS4G tools and technologies and provide insights on how these tools can be used in similar projects. This presentation is of interest to geospatial professionals, urban planners, and anyone interested in using FOSS4G tools for data analysis and mobility research.

Max Lindsay is a geospatial developer with a passion for cities and cycling. Hailing from Washington D.C., Max now calls Rotterdam, the Netherlands home. Max holds a Master's degree in Coastal Engineering from TU Delft, and currently works at Van Oord. With a background in both technology and urban studies, Max brings a unique perspective to the world of geospatial development.