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
13
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
120
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
52
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
2
160
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
86
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
67
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
1
87
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
85
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
78

Other Decks in Technology

See All in Technology
93c80c388fe9d8f9df7d030549a0ff0b?s=48 chaspy
2
770
D4e1322988219d8aca9480c9ac2dda61?s=48 sylk
0
170
A645e7c3a6635ead8fa323c583769591?s=48 hololab
0
340
48712994d81fae89e671dd3f43b8b7a2?s=48 kappa4
4
2.5k
Bcbc80799bc32840662a366768318a9b?s=48 koba789
0
450
8284465a94bbdf1ea82cf1a67d55f447?s=48 kilometer
0
150
93c80c388fe9d8f9df7d030549a0ff0b?s=48 chaspy
1
410
246b59bbea7c40cbbbcbf94bfc6720ff?s=48 ozuma
0
110
6ed12627fec46a135f1bce5d56f3568e?s=48 nwiizo
1
160
79c9f45e8a3cd4bfa9d7292adb3a6dc0?s=48 kraj
0
5.4k
1bdd9c71c3e2bb8fe1fac700c6ba3b34?s=48 yamasaki696
0
360
3f5ae6480375e527d01ee337d6c30a5f?s=48 sasakendayo
2
440

Featured

See All Featured
C7393b7ba7ec9c8890dd77d209fbb3c9?s=48 maltzj
500
36k
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
684
180k
E76911cbe088e5b850d966de3fc7435b?s=48 robhawkes
52
2.8k
465724d73fe3a92c0879fdfb43a3a6f3?s=48 philhawksworth
190
17k
78b475797a14c84799063c7cd073962f?s=48 holman
288
130k
78b475797a14c84799063c7cd073962f?s=48 holman
448
130k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
119
7.8k
8ec1383b240b5ba15ffb9743fceb3c0e?s=48 philnash
8
500
20bfe76b3d6105641f879fe45cfc9272?s=48 bkeepers
408
57k
95d9f37115fbb0d13135d0f77132f856?s=48 morganepeng
17
1.1k
Dafc4723e9a1c067796c0fec6f509774?s=48 lemiorhan
627
43k
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
192
8.6k

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