The Future of CartoDB is JS

Slide 1

Slide 1 text

MAPS ON THE WEB 3 WAYS TO USE CARTODB TO CREATE @ANDREWXHILL Monday, January 14, 13

Slide 2

Slide 2 text

A little background Monday, January 14, 13

Slide 3

Slide 3 text

CLOUD HOSTED SAAS OPEN SOURCE Monday, January 14, 13

Slide 4

Slide 4 text

APIS UI CLIENT LIBS Monday, January 14, 13

Slide 5

Slide 5 text

Monday, January 14, 13

Slide 6

Slide 6 text

WHY DID WE BUILD CARTODB? Monday, January 14, 13

Slide 7

Slide 7 text

ProtectedPlanet - World Database on Protected Areas Monday, January 14, 13

Slide 8

Slide 8 text

Monday, January 14, 13

Slide 9

Slide 9 text

AN EASIER AND MORE POWERFUL DATA MAPPING SOLUTION FOR THE WEB WANTED Monday, January 14, 13

Slide 10

Slide 10 text

Monday, January 14, 13

Slide 11

Slide 11 text

Monday, January 14, 13

Slide 12

Slide 12 text

SO WE BUILT CARTODB Monday, January 14, 13

Slide 13

Slide 13 text

CARTODB IS A LABOR OF LOVE Monday, January 14, 13

Slide 14

Slide 14 text

STILL YOUNG BUT GROWING FAST Monday, January 14, 13

Slide 15

Slide 15 text

CartoDB Beta released at FOSS 4G 2011 Monday, January 14, 13

Slide 16

Slide 16 text

Released CartoDB V1 April 2011 Monday, January 14, 13

Slide 17

Slide 17 text

Included SQL API, Maps API, and numerous client libraries Monday, January 14, 13

Slide 18

Slide 18 text

Monday, January 14, 13

Slide 19

Slide 19 text

CartoDB 2.0 November 2012 Monday, January 14, 13

Slide 20

Slide 20 text

TOTAL REDESIGN Monday, January 14, 13

Slide 21

Slide 21 text

Monday, January 14, 13

Slide 22

Slide 22 text

Monday, January 14, 13

Slide 23

Slide 23 text

Monday, January 14, 13

Slide 24

Slide 24 text

TOTALLY GUTTED Monday, January 14, 13

Slide 25

Slide 25 text

Monday, January 14, 13

Slide 26

Slide 26 text

Tile API Monday, January 14, 13

Slide 27

Slide 27 text

SQL API Monday, January 14, 13

Slide 28

Slide 28 text

CartoDB.js Monday, January 14, 13

Slide 29

Slide 29 text

Monday, January 14, 13

Slide 30

Slide 30 text

#1 CartoDB.js + UI Monday, January 14, 13

Slide 31

Slide 31 text

Monday, January 14, 13

Slide 32

Slide 32 text

Monday, January 14, 13

Slide 33

Slide 33 text

Monday, January 14, 13

Slide 34

Slide 34 text

Monday, January 14, 13

Slide 35

Slide 35 text

Viz.JSON Monday, January 14, 13

Slide 36

Slide 36 text

simple Monday, January 14, 13

Slide 37

Slide 37 text

growing Monday, January 14, 13

Slide 38

Slide 38 text

growing Monday, January 14, 13

Slide 39

Slide 39 text

Monday, January 14, 13

Slide 40

Slide 40 text

ﬂexible Monday, January 14, 13

Slide 41

Slide 41 text

ﬂexible Monday, January 14, 13

Slide 42

Slide 42 text

full power of postgis from js Monday, January 14, 13

Slide 43

Slide 43 text

ﬂexible Monday, January 14, 13

Slide 44

Slide 44 text

Torque HTML5 Canvas #2 Monday, January 14, 13

Slide 45

Slide 45 text

Canvas Maps Monday, January 14, 13

Slide 46

Slide 46 text

Vecnik Monday, January 14, 13

Slide 47

Slide 47 text

http://goo.gl/TsGsr Monday, January 14, 13

Slide 48

Slide 48 text

SELECT * FROM YOUR_TABLE Monday, January 14, 13

Slide 49

Slide 49 text

WITH hgrid AS (SELECT Cdb_rectanglegrid(Cdb_xyz_extent(8, 12, 5), Cdb_xyz_resolution(5) * 4, Cdb_xyz_resolution(5) * 4) AS cell) SELECT x, y, Array_agg(c) vals, Array_agg(d) dates FROM (SELECT St_xmax(hgrid.cell) x, St_ymax(hgrid.cell) y, Count(i.cartodb_id) c, Floor(( Date_part('epoch', built) -‐ -‐10418716800 ) / 32837875) d FROM hgrid, us_po_offices i WHERE St_intersects(i.the_geom_webmercator, hgrid.cell) GROUP BY hgrid.cell, Floor(( Date_part('epoch', built) -‐ -‐10418716800 ) / 32837875) ) f GROUP BY x, y packing SQL Monday, January 14, 13

Slide 50

Slide 50 text

{ rows: [ { x: 0, y: 0, vals: [2], dates: [457] }, { x: 1, y: 0, vals: [1,1,4], dates: [2,3,4] } ] } Monday, January 14, 13

Slide 51

Slide 51 text

1 10 100 1000 3mb 70mb 300mb 1.5 2 1.2 300 70 3 Raw Datacube Payload sizes Simon Tokumine Monday, January 14, 13

Slide 52

Slide 52 text

http://goo.gl/TsGsr Monday, January 14, 13

Slide 53

Slide 53 text

growing Monday, January 14, 13

Slide 54

Slide 54 text

SVG SVG #3 Monday, January 14, 13

Slide 55

Slide 55 text

D3 + CARTODB SQL Monday, January 14, 13

Slide 56

Slide 56 text

CartoDB.js SQL Monday, January 14, 13

Slide 57

Slide 57 text

simple Monday, January 14, 13

Slide 58

Slide 58 text

simple Monday, January 14, 13

Slide 59

Slide 59 text

d3.geo = so cool Monday, January 14, 13

Slide 60

Slide 60 text

Monday, January 14, 13

Slide 61

Slide 61 text

Monday, January 14, 13

Slide 62

Slide 62 text

D3 + CARTODB SQL Monday, January 14, 13

Slide 63

Slide 63 text

growing Monday, January 14, 13

Slide 64

Slide 64 text

SVG TopoJSON #3.5 Monday, January 14, 13

Slide 65

Slide 65 text

Monday, January 14, 13

Slide 66

Slide 66 text

Monday, January 14, 13

Slide 67

Slide 67 text

Raw GeoJSON 9.1MB Monday, January 14, 13

Slide 68

Slide 68 text

SHAPEFILE 3.5MB Monday, January 14, 13

Slide 69

Slide 69 text

Raw TopoJSON 1.7MB Monday, January 14, 13

Slide 70

Slide 70 text

topojson Monday, January 14, 13

Slide 71

Slide 71 text

topojson Monday, January 14, 13

Slide 72

Slide 72 text

Monday, January 14, 13

Slide 73

Slide 73 text

testing Monday, January 14, 13

Slide 74

Slide 74 text

growing Monday, January 14, 13

Slide 75

Slide 75 text

SVG Writable Tables BONUS Monday, January 14, 13

Slide 76

Slide 76 text

Monday, January 14, 13

Slide 77

Slide 77 text

Monday, January 14, 13

Slide 78

Slide 78 text

Monday, January 14, 13

Slide 79

Slide 79 text

Monday, January 14, 13

Slide 80

Slide 80 text

Monday, January 14, 13

Slide 81

Slide 81 text

THE FUTURE OF CARTODB IS JAVASCRIPT Monday, January 14, 13

Slide 82

Slide 82 text

@ANDREWXHILL Monday, January 14, 13