A very common map people want to make is one that shows how two datasets are associated to one another. It used to be a pretty hard map to make and taking a bit more patience to pull off. With the latest release of CartoDB, we've made it insanely easy, so I wanted to show it to you now. This video will show you how to,
1. Upload a dataset to CartoDB
2. Create a visualization from your data
3. Combine multiple datasets into a single visualization
4. Perform a small query to draw links across the datasets
5. Publish your visualization
The latest release of CartoDB has a fundamental change in the way you think about your data. Instead of every dataset becoming a map, users can now manage many datasets each with there own map. When it comes time to publish maps though, users create Visualizations, which are composites of one to many layers.
This is going to allow users to get far more creative with their data, as well as more easily reuse data across.
In this tutorial, I'll show you how to set up a Google Form and use Google App Scripts to store results directly to a CartoDB. As a bonus, we also will use a function to geocode location data using the Google service.
In this screencast we go over an entire project creating a population map of California. The screencast is based on Mike Bostocks example using D3. In this case we go over downloading data from two datasets, the polygons and the census data, and we combine them on a map using CartoDB.