CartoDB and the Curious Power of Maps

CartoDB and the Curious Power of Maps

35f4d000a88cdbcf6392dfb206ebd5e2?s=128

Andrew W Hill

October 14, 2014
Tweet

Transcript

  1. THE CURIOUS POWER OF THE MAP @ANDREWXHILL

  2. ABOUT

  3. BIOLOGIST

  4. None
  5. None
  6. None
  7. DEVELOPER

  8. None
  9. None
  10. MAPPER

  11. None
  12. None
  13. None
  14. None
  15. None
  16. None
  17. None
  18. http://vizzuality.com/projects/imazon

  19. None
  20. None
  21. USING DATA VISUALIZATION TO COMMUNICATE

  22. LOOK DATA!

  23. you Your team your boss The amount that people can

    understand your work with data
  24. None
  25. None
  26. MAPS ARE INCREDIBLE TOOLS TO COMMUNICATE COMPLEX DATA

  27. MAPS? WHY

  28. None
  29. None
  30. Guided by salient features

  31. None
  32. None
  33. None
  34. None
  35. http://bit.ly/ZaqMZY

  36. None
  37. None
  38. None
  39. None
  40. MAPS STARTED WITH MAP FOR US IT OFTEN

  41. None
  42. MAPS ARE HARD!

  43. SOLVE IT SO WE BUILT A NEW COMPANY TO

  44. None
  45. BUILDING A TOOL THAT MAKES GOING FROM DATA TO MAPS

    EASY
  46. None
  47. http://lat.ms/1u1tzNr

  48. CONTRIBUTING TO AN OPEN SOURCE COMMUNITY

  49. None
  50. TRYING TO FIND INNOVATIVE DIRECTIONS FOR THE FUTURE OF MAPS

  51. None
  52. AN EXAMPLE

  53. None
  54. None
  55. None
  56. source: bing

  57. 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
  58. None
  59. None
  60. ANOTHER EXAMPLE

  61. None
  62. None
  63. None
  64. None
  65. None
  66. ENABLING AN ECOSYSTEM OF APPLICATIONS

  67. sql API

  68. dynamic

  69. None
  70. None
  71. WE THINK WE’RE ONTO SOMETHING

  72. THE FUTURE OF CARTODB

  73. BETTER STORYTELLING

  74. None
  75. http://bit.ly/odysseyjs

  76. EASIER TO FIND DATA

  77. None
  78. None
  79. None
  80. THE FUTURE IS NOT STATIC

  81. we are in a new world

  82. http://bit.ly/1wAs0Zy

  83. http://bit.ly/11jIVpS

  84. YOU CAN NOW TELL A DIFFERENT STORY TO EVERY VIEWER…

  85. WANT TO GET INVOLVED?

  86. http://blog.cartodb.com/

  87. None
  88. http://academy.cartodb.com/

  89. None
  90. @andrewxhill Join the CartoDB Developer Program The CartoDB Developer Program

    is an initiative to partner with companies and developers in creating geospatial products that look, feel, and sell great cartodb.com/marketplace 60 70 Welcome to Ubuntu 12.04.3 LTS (GNU/Linux 3.8.0-29-generic i686) * Documentation: https://help.ubuntu.com/ System information as of Mon Sep 1 09:00:03 UTC 2014 System load: 0.05 Processes: 121 Usage of /: 19.4% of 29.40GB Users logged in: 1 Memory usage: 64% IP address for eth0: 12.3.132.15 Swap usage: 0% IP address for eth1: 10.2.124.12 Manage this system at https://landscape.canonical.com/ *** System restart required *** ubuntu@cartodb:~$ DESIGN DEVELOP MARKETING AND SALES
  91. We are hiring!!! http://www.cartodb.com/jobs

  92. THANK YOU! @ANDREWXHILL