From the course: Hands-On PostgreSQL Project: Spatial Data Science

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Spatial analysis: Identify nearby stations with a buffer

Spatial analysis: Identify nearby stations with a buffer

From the course: Hands-On PostgreSQL Project: Spatial Data Science

Start my 1-month free trial Buy for my team

Spatial analysis: Identify nearby stations with a buffer

“

- [Instructor] In the last few videos, we've tackled how to organize bike trip data geographically and conduct spatial joins to get a better understanding of trips across different census tracts. In this video, we'll take one step further by solving a logistical problem for the company. Our business objective in this video is to optimize van routes for replenishing bike stations. To maintain a balanced bike inventory at all of its stations, Big Apple Bike Share Inc. would like to dispatch vans that can frequently transport bikes between locations. It would be costly and inefficient for each van to visit only one station per trip. To save on operational cost, we'll use ST_Buffer to create a one-kilometer radius around the top three stations and then perform a spatial join to see which nearby stations could be replenished on the same trip. In geographical analysis, a buffer creates a zone around a geographic feature, allowing you to analyze what's nearby within a given distance. In…

Contents