Are you working with geospatial data, or have you been wondering why we even use it? Then, this article might be for you.
Introducing & showcasing its ubiquitous use. Exploring DuckDB's spatial capabilities, transforming complex geographic analysis into simple SQL queries. Hacking on Foursquare.
Introducing & showcasing its ubiquitous use. Exploring DuckDB's spatial capabilities, transforming complex geographic analysis into simple SQL queries. Hacking on Foursquare.
Comments
↠ What is GIS or Geospatial?
↠ Why Geospatial Processing Matters
➕ SQL-joins vs. Spatial-Joins: From 100 billion reduced to 10 million
➕ Geospatial Data Formats and Operations: GeoJSON, WKT, ...
➕ Business Use Cases
↠ Geospatial in Action
➕ Converting Coordinates to Addresses
➕ Foursquare Dataset Analysis
➕ Chocolate Store Density Analysis: ‼️ Discovering the highest density of chocolate stores in Switzerland ‼️
➕ Finding Store Clusters
Comprehensive overview of Python libraries for geospatial visualization, from Folium to Plotly.
No specialized and complex GIS tools are required. I hope you enjoy it.
Shoutout to Matt for his great videos and @mehdio.com for his fantastic collaboration, input, and 🎨-skills.