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.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
18
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
160
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
76
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
2
180
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
90
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
70
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
1
92
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
100
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
80

Other Decks in Technology

See All in Technology
380bcd2ab751f5838abd8219df53e5fe?s=48 tomoki10
5
3k
Fd38d7ee40295f6361aa059008288731?s=48 shyaginuma
0
720
0277e4d384d261c8734241aadc23f139?s=48 muit
3
310
842515eaf8fbb2dfcc75197e7797dc15?s=48 sat
12
9.3k
96c31fe94f5e9b0eef4a606eaadcbc04?s=48 yoshiiryo1
2
320
A84b3c763c9c543069b7c02551e2720e?s=48 yuyamada
6
1.5k
93dcbac1a838bbec898747bb92aa47cc?s=48 sadonosake
0
100
657ac87f75c375156e5f79cdadebed4d?s=48 yasuoyasuo
1
740
1ff811939fd0923df8321ec6d8bf9d4b?s=48 jxck
1
650
Fb69af32a1d6d3ea3bc002b7718a7166?s=48 tomotaka_yamasaki
1
780
Eeac2f3b51b69b3cd6fb14ed348f0c6e?s=48 limes2018
0
150
5b47136bedcba2799edf4fcd27ea66d7?s=48 yaegashi
3
900

Featured

See All Featured
32de0bd2ba869609d26fd052a4622778?s=48 cromwellryan
107
6.4k
A415db3ac9e9668acbc1fb36eead84ac?s=48 mthomps
43
2.4k
11c84dff30266b907714802088852677?s=48 jasonvnalue
87
8.3k
245cee81a9c424266e5e401d844ea881?s=48 lara
26
3.2k
2f5463832ccb768ccb4a1ca3607c27ef?s=48 jacobian
260
20k
Be9caeb9d4ef9944d151af909063ed6e?s=48 samlambert
238
10k
E4f5d494ebdc9e7cce1aecf3ce3e8bc1?s=48 shpigford
167
19k
5f50f94346fbcb23706f0707169317a4?s=48 aarron
261
36k
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
17
2k
3d6ace9554821d552146413bcdf874f6?s=48 trishagee
34
4k
812e1705ff0f8bc1bcf18587bde687d5?s=48 62gerente
591
210k
E76911cbe088e5b850d966de3fc7435b?s=48 robhawkes
55
3k

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