Slide 1
Slide 1 text
CartoDB Workshop
@ANDREWXHILL
Slide 2
Slide 2 text
http://bit.ly/1bO1Pc0
ALL LINKS
Slide 3
Slide 3 text
Why did we build CartoDB?
Part 1
Slide 4
Slide 4 text
No content
Slide 5
Slide 5 text
No content
Slide 6
Slide 6 text
http://vizzuality.com/projects/protectedplanet
Text
Slide 7
Slide 7 text
No content
Slide 8
Slide 8 text
MAKE MAPS ONLINE
easier than ever before
Slide 9
Slide 9 text
What is it used for?
Part 2
Slide 10
Slide 10 text
http://aitor.is/iceland-contour/
Slide 11
Slide 11 text
No content
Slide 12
Slide 12 text
bit.ly/19fjB6R
Slide 13
Slide 13 text
SQL API
Slide 14
Slide 14 text
Data in
Slide 15
Slide 15 text
No content
Slide 16
Slide 16 text
http://cartodb.github.io/torque/
Slide 17
Slide 17 text
http://bit.ly/16SQXk5
Slide 18
Slide 18 text
http://nychenge.com/
Slide 19
Slide 19 text
No content
Slide 20
Slide 20 text
No content
Slide 21
Slide 21 text
No content
Slide 22
Slide 22 text
No content
Slide 23
Slide 23 text
No content
Slide 24
Slide 24 text
No content
Slide 25
Slide 25 text
Accounts + Upgrades
Part 3
Slide 26
Slide 26 text
.edu? email me your username!
Organization
upgrade to a magellan
coupon code: nacis-2013
Slide 27
Slide 27 text
Data downloads
Part 4
Slide 28
Slide 28 text
A rapid tour of the interface
Part 5
Slide 29
Slide 29 text
CARTODB FEATURE TOUR
Dashboard
Tables
Maps
Visualizations
Sharing
Embedding
Data editing
Map editing
CSS
SQL
Slide 30
Slide 30 text
Importing Data
Part 6
Slide 31
Slide 31 text
No content
Slide 32
Slide 32 text
https://github.com/nvkelso/natural-earth-vector
Slide 33
Slide 33 text
https://github.com/nvkelso/natural-
earth-vector/blob/master/zips/
50m_cultural/ne_50m_urban_areas.zip
import from url
Slide 34
Slide 34 text
http://bit.ly/
1bMAmaI
import shapefile
Slide 35
Slide 35 text
From maps to visualizations
Part 7
Slide 36
Slide 36 text
No content
Slide 37
Slide 37 text
http://bit.ly/15ujhxa
adding new layers
Slide 38
Slide 38 text
Publishing and sharing
Part 8
Slide 39
Slide 39 text
No content
Slide 40
Slide 40 text
Data editing
Part 9
Slide 41
Slide 41 text
No content
Slide 42
Slide 42 text
CartoCSS
Part 10
Slide 43
Slide 43 text
http://bit.ly/
1fqnYxF
custom cartocss
Slide 44
Slide 44 text
SQL - Filtering
Part 11
Slide 45
Slide 45 text
NYC’s BEST BLOCKS
something about bikability
Slide 46
Slide 46 text
create column
station_d
Slide 47
Slide 47 text
UPDATE nyc_bestbikeblocks bb
SET station_d =
(
SELECT
ST_Distance(the_geom::geography,
bb.the_geom::geography)
FROM citibike_stations
ORDER BY
the_geom <-> bb.the_geom LIMIT 1
)
Slide 48
Slide 48 text
No content
Slide 49
Slide 49 text
create column
station_d
Slide 50
Slide 50 text
STARTING THE ERIC FAN CLUB
i’ve never really met a seagull i’ve liked
Slide 51
Slide 51 text
Import the Data
Step 1
Slide 52
Slide 52 text
Create a Visualization
Step 2
Slide 53
Slide 53 text
No content
Slide 54
Slide 54 text
Duplicate the Visualization
Step 3
Slide 55
Slide 55 text
Add a column, day_of_year
Step 4
Slide 56
Slide 56 text
SQL!!
Step 5
Slide 57
Slide 57 text
UPDATE tracking_eric SET
day_of_year = extract(DOY FROM
date_time)
Step 5
Slide 58
Slide 58 text
SELECT
ST_MakeLine(the_geom_webmercator
ORDER BY date_time ASC) AS
the_geom_webmercator, day_of_year
FROM tracking_eric
GROUP BY day_of_year
Step 5
Slide 59
Slide 59 text
Make a choropleth*
Step 6
*see blog about time normalization
Slide 60
Slide 60 text
Introduction to CartoDB.js
Part 14
Slide 61
Slide 61 text
No content
Slide 62
Slide 62 text
Create a Visualization
Step 2
Slide 63
Slide 63 text
Create a Visualization
Step 2
Slide 64
Slide 64 text
Free form
Part 15