In this presentation, a unique approach to analyzing Capital Bikeshare trips in Washington D.C. using Open-Source Geospatial (FOSS4G) tools and technologies is show cased. This 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 this 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. This presentation will provide an overview of the methodology used in our project, as well as a discussion of the results and their implications. Experiences using FOSS4G tools and technologies and provide insights on how these tools can be used in similar projects will be shared. This presentation is of interest to geospatial professionals, urban planners, and anyone interested in using FOSS4G tools for data analysis and mobility research.