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: Analyzing patterns with spatial join

Spatial analysis: Analyzing patterns with spatial join

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

Start my 1-month free trial Buy for my team

Spatial analysis: Analyzing patterns with spatial join

“

- [Instructor] Let's work on the next step in our geospatial analysis. The business objective in this video is to determine how many back trips originated in each census tract. In a previous video, we explored temporal aspect of riderships and found the distribution of trip volume by half hour intervals. And in this video, we'll explore the spatial aspect of our spatio-temporal analysis, where we can answer not only when, but where trips occur. Then we'll visualize our findings in QGIS by creating a choropleth map. Here's the step-by-step project workflow. Step one, we'll be performing a spatial join of the points in the station's table and polygons in the census tract table. By the end of this step, we'll know which census tract each bike station falls in. We're joining the bike station with the census tract because this makes it easier to see overall patterns across the city rather than getting lost in the detail of individual station usage. The concept of a spatial join is similar…

Contents