PostGIS & the Hard Rock Café collection
summary
Builds a CSV catalog of about 20 Hard Rock Café T-shirts and retrieves global shop coordinates from OpenStreetMap (Nominatim/Overpass) and the official site via a curl one-liner. Loads two PostGIS tables, creates point geometries, and uses ST_Distance and ST_DWithin to match shirts to nearby shops, identifying exact matches, closed shops, duplicate listings, geocoding mismatches and missed visits (e.g., Miami). Produces a ranked list of next target cities (Cologne, London, Manchester) and demonstrates the pipeline working end-to-end.
AI-written summary · about
related talks
46mGetting Down To Earth: Geospatial Analysis With Rails
42mUsing Postgres to locate the best coffee near you!
50m–Mom, can we have G**gle Maps? –We have G**gle Maps at home
43mLocate all the things
23mDataEngBytes 2023 - BRI-T1-11 - Lizzie MacNeill
02h 18mTutorial
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
23mLocation Insights for Your Graphs with Neo4j, PostGIS, and Brickgraph