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.3k

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
Space Race 2 - Slingshot
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
23
Intro to Filecoin - Building apps with Powergate
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
200
Into the Powergate
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
91
Future of Pinning - storing Threads and Buckets at Textile
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
2
220
Maps of Today/Tomorrow
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
100
PopMaps - EcoViz Presentation
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
73
What is a Map
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
1
110
SCGIS Webinar
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
160
Harvard Workshop - 01-2015
35f4d000a88cdbcf6392dfb206ebd5e2?s=48 andrewxhill
0
86

Other Decks in Technology

See All in Technology
Oracle Base Database Service 技術詳細
3115a782126be714b5f94d24073c957d?s=48 oracle4engineer
PRO
3
9.2k
プログラマがオブジェクト指向しても幸せになれない理由
Bf7fe621f4fe1615c228ef8a79b87282?s=48 shirayanagiryuji
0
170
UIKitのアップデート 
#WWDC22
9d1961575e45a8286cdde5f86dbba312?s=48 akatsuki174
4
360
サーバレスECにおける Step Functions の使い方 〜ステートマシン全部見せます！〜
74cec195bfb6cb5165256d88cb7fcf0f?s=48 miu_crescent
0
200
oakのミドルウェアを書くときの技のらしきもの
6ab47a68ee78e84c34731ce12333deff?s=48 toranoana
0
140
Design for Humans: How to make better modernization decisions
4d71670118785e492d724ba8c0ae54ad?s=48 indualagarsamy
2
130
Data in Google I/O - IO Extended GDG Seoul
3bd69093dbe39b14603242b96cfbd7c6?s=48 kennethanceyer
0
170
Inside out - abusing archive file formats
261a01e1b07b7387b0d675322199fb58?s=48 ange
3
580
Apple M1 CPUの脆弱性「PACMAN」について解説する
A40160195344f29eace8239fda27d3b5?s=48 kuzushiki
0
110
Apa itu DevOps & Kenapa perlu belajar DevOps?
349a7f52975989094c75c055f9f6ba25?s=48 dicodingevent
0
120
SwiftUI Layout
0863933c047ef45d283fe4e1d26bbddc?s=48 auramagi
1
120
Oracle Cloud Infrastructure：2022年6月度サービス・アップデート
3115a782126be714b5f94d24073c957d?s=48 oracle4engineer
PRO
0
170

Featured

See All Featured
Six Lessons from altMBA
766b9746b59e6f09e280cd33cf4ed419?s=48 skipperchong
14
1.4k
The Pragmatic Product Professional
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
19
3k
Designing the Hi-DPI Web
C157b16234f1e75e8eac3698c1d4414a?s=48 ddemaree
272
32k
Making the Leap to Tech Lead
32de0bd2ba869609d26fd052a4622778?s=48 cromwellryan
113
7.4k
Music & Morning Musume
A60068bce2e73de3a37ca9d2dbe36092?s=48 bryan
35
4.2k
Building Adaptive Systems
06f8b41980eb4c577fa40c41d5030c19?s=48 keathley
25
1.1k
BBQ
761be20b5ebd271008bcee1244fc5b52?s=48 matthewcrist
74
7.9k
Creatively Recalculating Your Daily Design Routine
48c098b6579220a67a6ba949be6e4b5a?s=48 revolveconf
207
10k
How GitHub Uses GitHub to Build GitHub
78b475797a14c84799063c7cd073962f?s=48 holman
465
280k
Automating Front-end Workflow
96270e4c3e5e9806cf7245475c00b275?s=48 addyosmani
1351
200k
Navigating Team Friction
245cee81a9c424266e5e401d844ea881?s=48 lara
175
11k
No one is an island. Learnings from fostering a developers community.
6bb82b13cda86d3b821fa44100335ddf?s=48 thoeni
9
1.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