TechChange Workshop on Real-time Mapping

At the invitation of Eva Adler and Norman Shamas, I gave a workshop on CartoDB's real-time mapping capabilities for the TechChange class `Mapping for Social Good`. I introduced the idea of using sync tables to create maps that update hourly with earthquake data pulled from the United States Geological Survey servers. Using PostGIS, I showed how to join earthquake dataset points with Nepal districts polygons to produce a map visualizing the largest intersecting earthquake in each district. This can be achieved by simply pasting custom SQL into the CartoDB Editor's SQL tray, which will run against tables to produce an up-to-date map every time it is viewed. The TechChange class offers additional training opportunities for learning next-generation skills such as mapping real-time data.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.