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
8
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
100
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
49
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
2
160
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
83
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
66
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
1
86
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
84
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
77

Other Decks in Technology

See All in Technology
1820130315ee3f2e970aeeef918b264a?s=48 yuzoshigematsu
2
1.2k
9e7a653ed313b3da4b263a772bfc5026?s=48 clustervr
0
170
0d29d155ce5c5a93ed46363626da3ea7?s=48 ocise
1
1.9k
7689d16bbad8f2fa05a5e9afb8527675?s=48 fatsushi
2
1.1k
93fc2d713bc4d0e9c594bf8c9e6bcc62?s=48 oztick139
0
130
F6ceb15fb20b52f49e375cec868a0107?s=48 tokitakumi
4
920
1817c3d5995710d04506a17cc9b5c9ba?s=48 runrunsan
1
210
2102a6b8760bd6f57f672805723dd83a?s=48 line_developers_tw
0
650
17d762ae166e66cab39e9b2e3df7d198?s=48 ysakashita
0
130
5af8e5bd2f24e4ea0cee732c6cc259b3?s=48 haruharuharuby
0
210
11d3072d628a7b976cd2f4e6a3cf750f?s=48 yuyaabo
0
580
F0ec1a6cb9e7be1911ed97b6561ed5ac?s=48 k1nakayama
0
130

Featured

See All Featured
95d9f37115fbb0d13135d0f77132f856?s=48 morganepeng
90
13k
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
682
180k
A9704266587836f7e784235e5073b93e?s=48 jmmastey
5
380
B47b288784fda77a94aeb234ca743c24?s=48 keavy
105
14k
D83926c323d4f9289f947b4b4e76b939?s=48 jensimmons
205
10k
A16eb159db895e3b01d3dc95767ad595?s=48 jonyablonski
6
750
A60068bce2e73de3a37ca9d2dbe36092?s=48 bryan
100
11k
B3d6434763caa0ef5dc4b792662c49f7?s=48 smashingmag
281
46k
016edace78ffe826f2348d1e0c504afd?s=48 maggiecrowley
5
310
91cefdf141106fa10674aae74ce05890?s=48 yeseniaperezcruz
297
31k
E190023b66e2b8aa73a842b106920c93?s=48 zenorocha
296
39k
Aebc2d07a50011e2a30d38435fde564a?s=48 jrom
113
7k

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