Civic Hacking & Urban Informatics: Mapping Data with GeoPandas

on YouTube ↗10m

" summary

Converts Healthy Ride CSV station coordinates into a GeoDataFrame using GeoPandas and shapely, fixes a bad negative latitude, and overlays violet station points on a county-level choropleth of poor housing rates. Loads two shapefiles (census tracts and poor housing), merges by tract, sets CRS, and plots the choropleth with station markers on the same axis. Provides a working Jupyter Notebook and GitHub repo with code and an extra analysis of bike rack counts.

AI-written summary · about

" chapters (11)

1. 0:00Intro
2. 0:30SHOUT OUT TO OPEN SOURCE DATA SPONSORS!
3. 1:33CHOOSING YOUR DATASET
4. 2:30IMPORTING LIBRARIES
5. 2:44LOADING IN DATA
6. 3:57CLEANING THE DATA
7. 5:04PREPARING THE DATA
8. 6:30CLEANING GEODATAFRAMES
9. 7:09TURNING INTO A CHOROPLETH MX
10. 8:28CHOROPLETH MAP & OVERLAY
11. 8:51FULL CODE

" related talks

• 03h 59mGeospatial Public Policy Analysis with GeoPandasSergio Sanchez · PyCon US 2020
• 42mTackling Homelessness with Open DataEric Busboom · PyData Los Angeles 2019
• 05mSpatial Mapping in Python with GeoPandas and OpenStreetMapErich Purpur · State of the Map US 2023
• 30mMaps, Maps, Maps!Geir Arne Hjelle · PyData Global 2022
• 26mWho Said Wrangling Geospatial Data at Scale was Easy?Brendan Collins · PyCon US 2022
• 29mGeospatial Analysis using PythonKrishna Lodha · XtremePython 2021
• 37mSpatial Data Analysis With PythonDillon R Gardner, PhD · PyData Berlin 2018
• 20mOpen Source Software in Action: Expanding the Spatial Equity Data ToolGabriel Morrison · posit::conf(2024)