Skip to content

Instantly share code, notes, and snippets.

Last active Jan 3, 2016
What would you like to do?
DataKind mapping crash course

Short link to this document

Data for today's course is available from Instead of downloading the data locally, we are just going to copy the URL to the public CSV of data, Select the URL and copy to your clipboard.

Importing data

There are a few options in CartoDB for adding data to your account.

  1. Drag and drop files to your dashboard (CSV, KML, SHP, etc.)
  2. Paste URLs into the import menu
  3. Use the file import API (see
  4. Write data with SQL using the dashboard or API (see

Bubble Map

  1. Sizing and customizing style
  2. Quick look at comp op


  1. Adding
  2. Advanced editing


	#ssoreports [ volume_gallons = null] {
	   marker-fill:  white;
	   marker-opacity: 0.4;
	   marker-comp-op: dst-over;


  1. Importing from common data
  2. Labels
  3. Combining layers



See a version of the map live here,

Extra resources

Map Academy

Learn along with us in these free, live, monthly courses.

CartoDB Documentation

See a lot of great material here, including videos and writen content.

GIS StackExchange

The best place to get answers to your technical questions is through the GIS StackExchange. Tag your questions with the cartodb tag and they get answered pretty quick!

Useful Spatial SQL

There is a ton of useful SQL out there. I put together some fun examples using the tornadoes dataset availabel from the first class of the Map Academy.

<!DOCTYPE html>
<title>DataKind Workshop | Demo</title>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
html, body, iframe {
height: 100%;
padding: 0;
margin: 0;
<iframe width='100%' height='100%' frameborder='0' src='*%20FROM%20ssoreports%20ORDER%20BY%20volume_gallons%20DESC&sw_lat=40.53050177574321&sw_lon=-81.4306640625&ne_lat=44.49650533109345&ne_lon=-70.8837890625'></iframe>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment