Lightweight community mapping sites, powered by spreadsheets

on YouTube ↗21m

" summary

Builds lightweight maps by using Google Sheets as DB published to the web and read via the CSV API, fetched with d3 and converted in-browser to GeoJSON then rendered with Mapbox GL JS. Shows live sites (community listings, LGBT friendly doctors, Good Karma Network) that update on sheet publish, notes Carto pricing kills freelancing and uMap is overpowered, explains optional polling for near‑real‑time updates and using a Sheets geocoding plugin for non‑technical users.

AI-written summary · about

" chapters (6)

1. 0:00Introduction and background
2. 2:10Community mapping challenges
3. 5:46Limitations of existing platforms
4. 8:18Power of spreadsheets for mapping
5. 11:30Building the mapping site
6. 14:19Q&A session

" related talks

• 01h 34mBuild a Web Map with Open Source ToolsLyzi Diamond · Open Source Bridge 2015
• 30mStreamlined Map Development: Part 1Matthew Anthony, Rebecca Herren · BUILD with Mapbox 2025
• 07mSimple and sustainable web developmentGaetanBoisson · Svelte Summit Spring 2024
• 32m"A Developer's Guide to Open Source Web Mapping Libraries"Courtney Yatteau · Frontrunners 2025
• 21mSpreadsheets, Forms and ForksJessica Lord · Render Conference 2017
• 41mA Developer's Guide to Open Source Web Mapping LibrariesCourtney Yatteau · Øredev 2025
• 21mMake a map in minutes: How Mapbox is streamlining map developmentMatthew Anthony, Rebecca Herren · BUILD with Mapbox 2025
• 46mDiscovering 40 Geo-APIs in 40 MinutesRaúl Jiménez · Codemotion Madrid 2015