Company
Date Published
Author
CARTO Contributors
Word count
306
Language
English
Hacker News points
None

Summary

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.