SCGIS Webinar

https://www.scgis.org/events/details/26

Transcript

1. AMAZING USES OF
   CARTODB
   @ANDREWXHILL
   

   View Slide

2. BIOLOGIST
   

   View Slide

3. View Slide

4. View Slide

5. View Slide

6. View Slide

7. DEVELOPER
   

   View Slide

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

   View Slide

9. View Slide

10. MAPPER
    

    View Slide

11. View Slide

12. View Slide

13. View Slide

14. View Slide

15. View Slide

16. GOING FROM DATA TO
    UNDERSTANDING
    

    View Slide

17. LOOK DATA!
    

    View Slide

18. View Slide

19. View Slide

20. MOSTLY MAPS
    

    View Slide

21. View Slide

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

    View Slide

23. MAPS?
    WHY
    

    View Slide

24. View Slide

25. credit - Google Maps
    

    View Slide

26. Guided by salient features
    

    View Slide

27. http://bit.ly/ZaqMZY
    

    View Slide

28. View Slide

29. View Slide

30. View Slide

31. GOOD MAPS ARE
    QUITE HARD!
    

    View Slide

32. SOLVE IT
    WE ARE TRYING TO
    

    View Slide

33. View Slide

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

    View Slide

35. View Slide

36. A SIMPLE DRAG/DROP
    INTERFACE
    

    View Slide

37. View Slide

38. View Slide

39. View Slide

40. INTEGRATION WITH
    TOOLS YOU ALREADY
    USE
    

    View Slide

41. View Slide

42. ADVANCED TOOLS FOR
    INTEGRATING INTO YOUR
    PROJECTS
    

    View Slide

43. Dynamic
    

    View Slide

44. SQL API
    

    View Slide

45. View Slide

46. View Slide

47. View Slide

48. CARTODB.JS
    

    View Slide

49. CONTRIBUTING TO AN
    OPEN SOURCE
    COMMUNITY
    

    View Slide

50. View Slide

51. View Slide

52. View Slide

53. PUSHING MAP
    TECHNOLOGY INTO THE
    FUTURE
    

    View Slide

54. View Slide

55. View Slide

56. View Slide

57. View Slide

58. WHAT ARE PEOPLE
    DOING WITH CARTODB?
    

    View Slide

59. TELL A STORY
    

    View Slide

60. credit - WSJ
    

    View Slide

61. View Slide

62. View Slide

63. View Slide

64. http://blog.cartodb.com/rat-race/
    

    View Slide

65. View Slide

66. View Slide

67. ANALYZE & REPORT
    

    View Slide

68. credit - CyclePhilly
    

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

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

    View Slide

74. View Slide

75. Global Forest Watch
    

    View Slide

76. View Slide

77. View Slide

78. View Slide

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
    

    View Slide

80. View Slide

81. View Slide

82. Many other examples
    

    View Slide

83. View Slide

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

    View Slide

85. View Slide

86. View Slide

87. View Slide

88. BEAUTIFUL DATA
    

    View Slide

89. View Slide

90. View Slide

91. bit.ly/1BtfiBw
    

    View Slide

92. View Slide

93. credit - Lifewatch INBO
    

    View Slide

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

    View Slide

95. peter desmet
    

    View Slide

96. WHAT I DIDN’T
    SHOW YOU TODAY?
    

    View Slide

97. View Slide

98. http://bit.ly/odysseyjs
    

    View Slide

99. http://bit.ly/odysseyjs
    

    View Slide

100. http://bit.ly/odysseyjs
     

     View Slide

101. http://bit.ly/odysseyjs
     

     View Slide

102. http://bit.ly/odysseyjs
     

     View Slide

103. View Slide

104. http://bit.ly/odysseyjs
     

     View Slide

105. View Slide

106. http://bit.ly/odysseyjs
     

     View Slide

107. WANT TO GET
     INVOLVED?
     

     View Slide

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

     View Slide

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

     View Slide

110. View Slide

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

     View Slide

112. THANK YOU!
     @ANDREWXHILL
     

     View Slide