SCGIS Webinar

35f4d000a88cdbcf6392dfb206ebd5e2?s=47 Andrew W Hill
February 05, 2015

SCGIS Webinar

35f4d000a88cdbcf6392dfb206ebd5e2?s=128

Andrew W Hill

February 05, 2015
Tweet

Transcript

  1. AMAZING USES OF CARTODB @ANDREWXHILL

  2. BIOLOGIST

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

  8. credit - http://xkcd.com/353/

  9. None
  10. MAPPER

  11. None
  12. None
  13. None
  14. None
  15. None
  16. GOING FROM DATA TO UNDERSTANDING

  17. LOOK DATA!

  18. None
  19. None
  20. MOSTLY MAPS

  21. None
  22. http://vizzuality.com/projects/imazon

  23. MAPS? WHY

  24. None
  25. credit - Google Maps

  26. Guided by salient features

  27. http://bit.ly/ZaqMZY

  28. None
  29. None
  30. None
  31. GOOD MAPS ARE QUITE HARD!

  32. SOLVE IT WE ARE TRYING TO

  33. None
  34. BUILDING A TOOL THAT MAKES GOING FROM DATA TO MAPS

    EASY
  35. None
  36. A SIMPLE DRAG/DROP INTERFACE

  37. None
  38. None
  39. None
  40. INTEGRATION WITH TOOLS YOU ALREADY USE

  41. None
  42. ADVANCED TOOLS FOR INTEGRATING INTO YOUR PROJECTS

  43. Dynamic

  44. SQL API

  45. None
  46. None
  47. None
  48. CARTODB.JS

  49. CONTRIBUTING TO AN OPEN SOURCE COMMUNITY

  50. None
  51. None
  52. None
  53. PUSHING MAP TECHNOLOGY INTO THE FUTURE

  54. None
  55. None
  56. None
  57. None
  58. WHAT ARE PEOPLE DOING WITH CARTODB?

  59. TELL A STORY

  60. credit - WSJ

  61. None
  62. None
  63. None
  64. http://blog.cartodb.com/rat-race/

  65. None
  66. None
  67. ANALYZE & REPORT

  68. credit - CyclePhilly

  69. http://bit.ly/1ts3TPQ

  70. http://bit.ly/1ts3TPQ

  71. http://bit.ly/1ts3TPQ

  72. http://bit.ly/1ts3TPQ

  73. http://bit.ly/1ts3TPQ

  74. None
  75. Global Forest Watch

  76. None
  77. None
  78. None
  79. 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
  80. None
  81. None
  82. Many other examples

  83. None
  84. http://daily.jstor.org/keeping-up-with-the-carnivores/

  85. None
  86. None
  87. None
  88. BEAUTIFUL DATA

  89. None
  90. None
  91. bit.ly/1BtfiBw

  92. None
  93. credit - Lifewatch INBO

  94. credit: @peterdesmet http://bit.ly/eric-splat

  95. peter desmet

  96. WHAT I DIDN’T SHOW YOU TODAY?

  97. None
  98. http://bit.ly/odysseyjs

  99. http://bit.ly/odysseyjs

  100. http://bit.ly/odysseyjs

  101. http://bit.ly/odysseyjs

  102. http://bit.ly/odysseyjs

  103. None
  104. http://bit.ly/odysseyjs

  105. None
  106. http://bit.ly/odysseyjs

  107. WANT TO GET INVOLVED?

  108. http://bit.ly/odysseyjs blog.cartodb.com

  109. http://academy.cartodb.com/

  110. None
  111. http://bit.ly/cartodb-student

  112. THANK YOU! @ANDREWXHILL