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

Summary

Improve your (musical) timing with CartoDB Time Isolines and derive the best data insights The CartoDB platform now offers a new feature called Time and Distance Isolines, which allows users to measure time directly through SQL statements. This feature provides insight and analysis on how long it takes pedestrians to move from one hotspot to another, making tactical business planning easier. By visualizing this data, businesses can determine the most efficient way to spend their time, as time is money. The feature was tested with SXSW music events, where it showed how much time it takes to get from each venue and hotel to other entertainment spots. To use this feature, users must scrape data from a website using node.js and libraries like request, cheerio, and underscore, then upload the data to a PostgreSQL table using CartoDB's Import API. The addresses of the venues are automatically geocoded in the process, converting raw data into geo-data that can be put on a map with the CartoDB Editor. Users can create isolines for each hotspot by calling the cdb_isochrone function, and they can also use this feature to show synthetical lists of closest events from a given venue. The app also incorporates data from Spotify's REST API to match SXSW artist names to song samples and artist visuals. The app is built using CartoDB.js as the nerve center, with heavy use of templating using underscore.js to allow for dynamic HTML elements and SQL requests to CartoDB SQL APIs.