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
83
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
40
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
2
140
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
81
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
62
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
1
82
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
83
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
76
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
170

Other Decks in Technology

See All in Technology
D6fc8a819afa94f464fe322032a6687f?s=48 mahito
3
1.2k
8db231d3fe08b46242f6e0e45c95eee1?s=48 darkomesaros
0
120
Cd6e67775ba3275c466e9927ede23080?s=48 nk35jk
2
830
9e7a653ed313b3da4b263a772bfc5026?s=48 clustervr
0
200
Dacd98e0fcfc478b24f9cd7ec9208904?s=48 manabusakai
0
940
9ea422a61c1a69c888786830eee3dbe6?s=48 osonoi
0
140
7a37d60769f6f3004adee19a8ff2c219?s=48 tunepolo
4
1.4k
Cd891a89dfec6ca7bd278b5f5bd87c90?s=48 tzkoba
16
4.6k
2102a6b8760bd6f57f672805723dd83a?s=48 line_developers_tw
0
3.1k
Af61fe2beec7f195d7418e0a474a4dfc?s=48 kfujieda
3
1.2k
F68a145ec870bf173a932bc409b20fab?s=48 jyamamoto
0
250
Dd2fa99b9a9a3aa316986727ce8e134c?s=48 goccy
12
5.9k

Featured

See All Featured
11c84dff30266b907714802088852677?s=48 jasonvnalue
80
7.8k
25c7c18223fb42a4c6ae1c8db6f50f9b?s=48 mojombo
353
62k
4394ceb8b277f35ee3da7030384efb5d?s=48 davidbonilla
68
3.4k
B3d6434763caa0ef5dc4b792662c49f7?s=48 smashingmag
281
46k
78b475797a14c84799063c7cd073962f?s=48 holman
446
130k
9375a9529679f1b42b567a640d775e7d?s=48 schacon
144
6.4k
79acae287842acf29084005533a7fb3b?s=48 hursman
103
9k
C9b18d9dff88a9dd2393364c2b3b21bd?s=48 colly
65
2.9k
Dad095ea7038f89f760419ce475d5d14?s=48 michaelherold
224
8.2k
F57e2136eb9895eb95ff5dc8a1c02677?s=48 zakiwarfel
87
3.2k
7559f6cff1f5efc2d210965febd4d71c?s=48 bermonpainter
340
25k
Fde6c3a50ca518a909ef35c22c0ee0e4?s=48 destraynor
222
46k

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