← All projects
DataUnited States·2024·4 months
Zip Code Radius Database Scraper
Selenium script that scrapes zip codes within 65km of 366 US city centers, checks drive times and ferry requirements, and outputs structured CSVs.
Overview
Built for a US company servicing 366 cities — they needed a comprehensive database of all zip codes within their service radius, excluding areas requiring a ferry.
Implementation
- FreeMap Tools scraping — Selenium selects 65km radius, enters each city, extracts zip codes
- DistanceCalculator scraping — determines drive time from city center to each zip code
- Ferry detection — flags routes containing "Take the ferry" in directions
- Output — single CSV with: Zip Code, City Name, State, Target City, Drive Time, Ferry (TRUE/FALSE)
Scale
366 cities × multiple zip codes each — thousands of individual lookups across two scraping targets.
Tech stack
PythonSeleniumPandasGeoPy