At the invitation of Eva Adler and Norman Shamas, I had the pleasure of giving a workshop on CartoDB’s real-time mapping capabilities for the TechChange class Mapping for Social Good. Eva Adler’s course covers an impressive array of material on web mapping related to global development work.
I gave a short workshop introducing the real-time mapping available through CartoDB’s sync tables to create a map that updates hourly with earthquake data pulled from the United States Geological Survey servers. Using the spatial analysis functionality of PostGIS, I showed how to join the dataset of earthquakes (which comes as latitude/longitude points) with the districts of Nepal (which are polygons), producing a map from an on-the-fly calculation. The result visualizes the largest earthquake from the USGS dataset that intersects with a district in Nepal. This is the SQL that I used (names changed for readability):
All you need to do is paste your custom SQL into the SQL tray in the CartoDB Editor when you’re creating your visualization and it will run against your tables to produce the up-to-date map everytime someone looks at it. It’s pretty magical in my opinion! If you want to learn the basics of SQL, checkout our course on SQL and PostGIS in our Map Academy.
Mapping for Social Good will be taught again starting October 26, so don’t fret about missing Eva’s course this time around. If you want to get trained in other next-generation skills, check out TechChange’s awesome offerings.
Happy data Mapping!
Today, at the Spatial Data Science Conference, we presented the recently launched Data Observatory 2.0 (DO). A new platform to discover and consume location data for spatia...News
Data is an essential ingredient for spatial analysis—which is predicated on access to your own data, plus useful third-party data. In the end, spatial analysis is about put...News
The 3rd annual Spatial Data Science Conference is just three weeks away and we couldn’t be more excited. Being held at Columbia University, this year’s iteration of the for...News
Please fill out the below form and we'll be in touch real soon.