SCGIS Webinar

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

Transcript

1. AMAZING USES OF CARTODB @ANDREWXHILL
2. BIOLOGIST
7. DEVELOPER
8. credit - http://xkcd.com/353/
10. MAPPER
16. GOING FROM DATA TO UNDERSTANDING
17. LOOK DATA!
20. MOSTLY MAPS
22. http://vizzuality.com/projects/imazon
23. MAPS? WHY
25. credit - Google Maps
26. Guided by salient features
27. http://bit.ly/ZaqMZY
31. GOOD MAPS ARE QUITE HARD!
32. SOLVE IT WE ARE TRYING TO
34. BUILDING A TOOL THAT MAKES GOING FROM DATA TO MAPS EASY
36. A SIMPLE DRAG/DROP INTERFACE
40. INTEGRATION WITH TOOLS YOU ALREADY USE
42. ADVANCED TOOLS FOR INTEGRATING INTO YOUR PROJECTS
43. Dynamic
44. SQL API
48. CARTODB.JS
49. CONTRIBUTING TO AN OPEN SOURCE COMMUNITY
53. PUSHING MAP TECHNOLOGY INTO THE FUTURE
58. WHAT ARE PEOPLE DOING WITH CARTODB?
59. TELL A STORY
60. credit - WSJ
64. http://blog.cartodb.com/rat-race/
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
75. Global Forest Watch
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
82. Many other examples
84. http://daily.jstor.org/keeping-up-with-the-carnivores/
88. BEAUTIFUL DATA
91. bit.ly/1BtfiBw
93. credit - Lifewatch INBO
94. credit: @peterdesmet http://bit.ly/eric-splat
95. peter desmet
96. WHAT I DIDN’T SHOW YOU TODAY?
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
104. http://bit.ly/odysseyjs
106. http://bit.ly/odysseyjs
107. WANT TO GET INVOLVED?
108. http://bit.ly/odysseyjs blog.cartodb.com
109. http://academy.cartodb.com/
111. http://bit.ly/cartodb-student
112. THANK YOU! @ANDREWXHILL