Slide 1

Slide 1 text

Open Source Spatial Data Management: CartoDB

Slide 2

Slide 2 text

Table of contents: 1.............Considerations 2.............Big Data 3.............Art, Science, and The Scary Places in the Middle 4.............Why CartoDB? 5............Making a Map with CartoDB 6............Q & A

Slide 3

Slide 3 text

Spatial is special. “Everything is related to everything else, but near things are more related than distant things.” - Waldo Tobler (1970) Preface:

Slide 4

Slide 4 text

Geographic visualization should be forward thinking. Step 1: Look ahead. What is your goal? How will you accomplish it?

Slide 5

Slide 5 text

With CartoDB your map could be static... ...or animated.

Slide 6

Slide 6 text

Your map could stand alone... ...or be part of a larger story.

Slide 7

Slide 7 text

Big Data are more than just ‘big.’ “Big data is more than simply a matter of size; it is an opportunity to find insights in new and emerging types of data and content...” - IBM Step 2: Consider your data.

Slide 8

Slide 8 text

Volume Variety Velocity Vinculation of big data V’s The four

Slide 9

Slide 9 text

Geographic data are frequently big (one or more V’s).

Slide 10

Slide 10 text

Step 3: Decide if you’re looking for answers or communicating results. (or both) - Andy Woodruff, “Apart from being dead, Art and Science are strong in web cartography.”http://andywoodruff.com/blog/apart-from-being-dead-art-and-science- are-strong-in-web-cartography/ “Web cartography is not about maps; it’s about hacks for moving data around.” Graphic from MacEachren, A.M. (1994) “Visualization in modern cartography: Setting the agenda.” Redrawn by Roth (2011).

Slide 11

Slide 11 text

So how does this relate to CartoDB? To find out, let’s look at what other tools do.

Slide 12

Slide 12 text

Some tools are great for analysis.

Slide 13

Slide 13 text

http://at-cam.blogspot.com ArcGIS http://blog.ushahidi.com ✓ De facto standard GIS ✓ 10.1 on campus labs ✓ 1-year licenses for students ✓ Raster and vector analysis ✓ Hundreds of tools ✓ Model builder (see left) ✓ Python

Slide 14

Slide 14 text

ArcGIS Online http://www.arcgis.com

Slide 15

Slide 15 text

Quantum GIS (QGIS for short) ✓ Windows, OS X, Linux ✓ Open Source ✓ GDAL ✓ PostgreSQL/PostGIS, OSM ✓ Raster and vector analysis ✓ Hundreds of tools ✓ Python ✓ Increasingly mainstream

Slide 16

Slide 16 text

PostGIS Spatially-enabled PostgreSQL ✓ Windows, OS X, Linux ✓ Open Source (GPL) ✓ Very powerful. Very fast. ✓ Often used in conjunction with other tools No direct GUI

Slide 17

Slide 17 text

R With Spatial Packages ✓ A stats favorite ✓ Excels at point patterns, trends, and interpolation ✓ So-so visualization ✓ Recommend packages: ggplot2, maps, splancs, spatstat, mapproj R Studio w/ ggplot2 + maps http://www.statisfaction.wordpress.com

Slide 18

Slide 18 text

Other tools are great for communication.

Slide 19

Slide 19 text

TileMill ✓ A MapBox project ✓ CartoCSS for styling ✓ Smart selectors + compositing ✓ Shapefiles, PostGIS, SQLite, GeoJSON, CSV... ✓ Export to web, mobile, tiles, PDF, SVG, PNG... ✓ Publish to MapBox (free and $) ✓ Open Source

Slide 20

Slide 20 text

MapBox ✓ Cloud-based map design ✓ Add public layers, base maps ✓ Load data from TileMill ✓ Embed or share ✓ Free account = 3,000 views per month ✓ MapBox.js library

Slide 21

Slide 21 text

D3 ✓ JavaScript for SVG styled with CSS ✓ Huge (and growing!) set of examples ✓ Impressive geographic capability ✓ Steep learning curve ✓ Maps are only one facet of D3 Data-Driven Documents

Slide 22

Slide 22 text

Where does CartoDB fit in all of this? Communication Analysis Cloud-ready

Slide 23

Slide 23 text

Where does CartoDB fit in all of this? DB-driven (PostgreSQL, PostGIS) Scriptable tools and extensions Support for SHP, CSV, GeoJSON Tie into R for analysis Cloud-based online editor Pair with JavaScript libraries (D3, MapBox.js, etc) Base map from TileMill, MapBox SVG rendering Animation Interaction Communication Analysis Cloud-ready You guessed it!

Slide 24

Slide 24 text

Let’s make a map! 1 2

Slide 25

Slide 25 text

Let’s make a map! 3 Any plans for academics? “Yes we have. Contact us for getting more information. We are quite friends of academics so, you will get a lot of benefits.” - CartoDB

Slide 26

Slide 26 text

Let’s make a map! 4 Need data? No sweat: https://gist.github.com/jscarto/4541842

Slide 27

Slide 27 text

Let’s make a map! Need data? No sweat: https://gist.github.com/jscarto/4541842 5

Slide 28

Slide 28 text

Let’s make a map!

Slide 29

Slide 29 text

Let’s make a map!

Slide 30

Slide 30 text

Let’s make a map! Points, lines and polygons = geometric primitives essential to GIS + cartography

Slide 31

Slide 31 text

Let’s make a map! 6 Data type can be String, Number (float), Date, or Boolean

Slide 32

Slide 32 text

Let’s make a map!

Slide 33

Slide 33 text

Let’s make a map!

Slide 34

Slide 34 text

Let’s make a map!

Slide 35

Slide 35 text

Let’s make a map!

Slide 36

Slide 36 text

Let’s make a map!

Slide 37

Slide 37 text

Let’s make a map! Copy (ctrl- or ⌘-c) all 67 lines of MapStyle.css

Slide 38

Slide 38 text

Let’s make a map! Paste (ctrl- or ⌘-v) all 67 lines of MapStyle.css

Slide 39

Slide 39 text

Let’s make a map! More interesting heat map. Notice zoom level = 7.

Slide 40

Slide 40 text

Let’s make a map! Discrete points visible at zoom level = 10.

Slide 41

Slide 41 text

Let’s make a map! 1 2 3 CartoCSS Breakdown 1 2 3 + + +... = multilayer symbol for heat map Smart selectors enable variable-driven design

Slide 42

Slide 42 text

Don’t forget to share your map!

Slide 43

Slide 43 text

Thanks! Questions? Email: [email protected] Twitter: @jscarto Slides online at: speakerdeck.com/jscarto