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

I hope you enjoy. The SQL I used in the query is,

gist.github.com/andrewxhill/5979532

The data I used was downloaded from,

imls.gov/research/public_libraries_in_the_united_states_survey.aspx

and

citibikenyc.com/stations/json (you will need to convert json to csv)

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…