Save 37% off PRO during our Black Friday Sale! »

The Future of CartoDB is JS

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

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
21
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
170
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
82
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
2
200
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
96
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
71
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
1
94
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
120
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
82

Other Decks in Technology

See All in Technology
Ff0453fcbf27a84de92b9cc1f2aed9af?s=48 koike91
0
360
D907136acebc72f1df878541b26f271a?s=48 pichuang
1
160
A857277d74d4719f7f7751dca5ed553e?s=48 cmusudakeisuke
0
570
D1b28ca276bee52e56ba11785f70d2d6?s=48 makocchi
2
200
4649f3418cb4e7b951ca28e65003c7ac?s=48 sumi
1
210
484571ccba0db66b69dc11761afdd0c4?s=48 chiroito
1
170
8d80af14296180866264212adbfb587e?s=48 godan
0
150
1dc3bd1bd5485382541fcbfa225a9b22?s=48 tsubasa_umeuchi
2
590
88964b936e864ca7d326272eaa70fa9a?s=48 hgsgtk
11
3.6k
7cd783377515bdf8207062840b7b2f4e?s=48 soracom
PRO
2
180
26afa82334d1037f0ba602272b950c90?s=48 kazuhitotakahashi
0
210
Ab628671841774343b1020f22f712069?s=48 mouson
0
250

Featured

See All Featured
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
18
2.4k
C9b18d9dff88a9dd2393364c2b3b21bd?s=48 colly
191
14k
C4de88ea47538e4594750e3861a341c8?s=48 brettharned
96
3.6k
Aebc2d07a50011e2a30d38435fde564a?s=48 jrom
120
7.5k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
123
8.3k
1b75d89772b7eea1f6c89fbf362607d9?s=48 moore
129
22k
F57e2136eb9895eb95ff5dc8a1c02677?s=48 zakiwarfel
91
3.7k
812e1705ff0f8bc1bcf18587bde687d5?s=48 62gerente
595
210k
06f8b41980eb4c577fa40c41d5030c19?s=48 keathley
25
950
1ce0eb06fd6a9e9566a0cb310cfee635?s=48 jrick
PRO
1
19k
B3ace07412a5178ea778e7eec161fc0a?s=48 jcasabona
10
770
96270e4c3e5e9806cf7245475c00b275?s=48 addyosmani
497
110k

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