Upgrade to Pro — share decks privately, control downloads, hide ads and more …

The Future of CartoDB is JS

35f4d000a88cdbcf6392dfb206ebd5e2?s=47 Andrew W Hill
January 14, 2013
Technology
15
4.1k

The Future of CartoDB is JS

#JSGeo13 presentation
http://geojs.eventbrite.com/

http://cartodb.com/

35f4d000a88cdbcf6392dfb206ebd5e2?s=128

Andrew W Hill

January 14, 2013
Tweet

More Decks by Andrew W Hill

See All by Andrew W Hill
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
16
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
140
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
69
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
2
160
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
87
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
69
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
1
88
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
87
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
79

Other Decks in Technology

See All in Technology
8065fe5a0d33908c6f71c5ae28939dcd?s=48 ayatokura
0
260
69b93af68320a590f607c296e8edff73?s=48 k1low
13
2.5k
Ad2155c75c67c0100dd008ad10858de5?s=48 legalforce
PRO
0
170
40301c0affdf359eaca771713e22b71a?s=48 harshbothra
0
210
14d83dc17e2c893d7564b609ff8da4ca?s=48 techharmony
0
110
85da685d91fda190e2e3162d0de248a4?s=48 recruitengineers
0
240
4ca55ec64603f424638409b6e0ee7e65?s=48 halhira
1
110
1e4cac300be32ee4c840c1e69a5cb2e3?s=48 junendo
0
160
B2fefbb30aba7c25bbe0c8819791631a?s=48 gunnargrosch
0
210
00101a1274d1f92977f4e442ef73be86?s=48 ahana
0
400
7a54d6143169419fc6d4d9a0ff3056ea?s=48 maekawa123
0
570
098ad475722e3697ec2fba28c8654f9f?s=48 yuhta28
0
140

Featured

See All Featured
0bce06bd06ee7a2c4f5500f25dcf7f18?s=48 paulrobertlloyd
73
1.5k
7edec06b5435e0dac07a353b2cc26253?s=48 geeforr
333
29k
20bfe76b3d6105641f879fe45cfc9272?s=48 bkeepers
PRO
322
53k
79acae287842acf29084005533a7fb3b?s=48 hursman
107
9.3k
48c098b6579220a67a6ba949be6e4b5a?s=48 revolveconf
200
9.7k
Aff5641764408271f7bc398f2097edd0?s=48 denniskardys
220
120k
4394ceb8b277f35ee3da7030384efb5d?s=48 davidbonilla
70
3.6k
B3ace07412a5178ea778e7eec161fc0a?s=48 jcasabona
8
590
95d9f37115fbb0d13135d0f77132f856?s=48 morganepeng
19
1.3k
0c6fd6a08d0f898159cda7cafcacf07f?s=48 afnizarnur
176
14k
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
10
1.7k
5f83ef806155b403c3393160ce51f955?s=48 jlugia
217
16k

Transcript

  1. MAPS ON THE WEB 3 WAYS TO USE CARTODB TO

    CREATE @ANDREWXHILL Monday, January 14, 13

  2. A little background Monday, January 14, 13

  3. CLOUD HOSTED SAAS OPEN SOURCE Monday, January 14, 13

  4. APIS UI CLIENT LIBS Monday, January 14, 13

  5. Monday, January 14, 13

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

  7. ProtectedPlanet - World Database on Protected Areas Monday, January 14,

    13

  8. Monday, January 14, 13

  9. AN EASIER AND MORE POWERFUL DATA MAPPING SOLUTION FOR THE

    WEB WANTED Monday, January 14, 13

  10. Monday, January 14, 13

  11. Monday, January 14, 13

  12. SO WE BUILT CARTODB Monday, January 14, 13

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

  14. STILL YOUNG BUT GROWING FAST Monday, January 14, 13

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

    13

  16. Released CartoDB V1 April 2011 Monday, January 14, 13

  17. Included SQL API, Maps API, and numerous client libraries Monday,

    January 14, 13

  18. Monday, January 14, 13

  19. CartoDB 2.0 November 2012 Monday, January 14, 13

  20. TOTAL REDESIGN Monday, January 14, 13

  21. Monday, January 14, 13

  22. Monday, January 14, 13

  23. Monday, January 14, 13

  24. TOTALLY GUTTED Monday, January 14, 13

  25. Monday, January 14, 13

  26. Tile API Monday, January 14, 13

  27. SQL API Monday, January 14, 13

  28. CartoDB.js Monday, January 14, 13

  29. Monday, January 14, 13

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

  31. Monday, January 14, 13

  32. Monday, January 14, 13

  33. Monday, January 14, 13

  34. Monday, January 14, 13

  35. Viz.JSON Monday, January 14, 13

  36. simple Monday, January 14, 13

  37. growing Monday, January 14, 13

  38. growing Monday, January 14, 13

  39. Monday, January 14, 13

  40. flexible Monday, January 14, 13

  41. flexible Monday, January 14, 13

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

  43. flexible Monday, January 14, 13

  44. Torque HTML5 Canvas #2 Monday, January 14, 13

  45. Canvas Maps Monday, January 14, 13

  46. Vecnik Monday, January 14, 13

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

  48. SELECT * FROM YOUR_TABLE Monday, January 14, 13

  49. 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

  50. {    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

  51. 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

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

  53. growing Monday, January 14, 13

  54. SVG SVG #3 Monday, January 14, 13

  55. D3 + CARTODB SQL Monday, January 14, 13

  56. CartoDB.js SQL Monday, January 14, 13

  57. simple Monday, January 14, 13

  58. simple Monday, January 14, 13

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

  60. Monday, January 14, 13

  61. Monday, January 14, 13

  62. D3 + CARTODB SQL Monday, January 14, 13

  63. growing Monday, January 14, 13

  64. SVG TopoJSON #3.5 Monday, January 14, 13

  65. Monday, January 14, 13

  66. Monday, January 14, 13

  67. Raw GeoJSON 9.1MB Monday, January 14, 13

  68. SHAPEFILE 3.5MB Monday, January 14, 13

  69. Raw TopoJSON 1.7MB Monday, January 14, 13

  70. topojson Monday, January 14, 13

  71. topojson Monday, January 14, 13

  72. Monday, January 14, 13

  73. testing Monday, January 14, 13

  74. growing Monday, January 14, 13

  75. SVG Writable Tables BONUS Monday, January 14, 13

  76. Monday, January 14, 13

  77. Monday, January 14, 13

  78. Monday, January 14, 13

  79. Monday, January 14, 13

  80. Monday, January 14, 13

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

  82. @ANDREWXHILL Monday, January 14, 13