CartoDB and the Curious Power of Maps

Transcript

1. THE CURIOUS POWER OF THE MAP @ANDREWXHILL
2. ABOUT
3. BIOLOGIST
7. DEVELOPER
10. MAPPER
18. http://vizzuality.com/projects/imazon
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
26. MAPS ARE INCREDIBLE TOOLS TO COMMUNICATE COMPLEX DATA
27. MAPS? WHY
30. Guided by salient features
35. http://bit.ly/ZaqMZY
40. MAPS STARTED WITH MAP FOR US IT OFTEN
42. MAPS ARE HARD!
43. SOLVE IT SO WE BUILT A NEW COMPANY TO
45. BUILDING A TOOL THAT MAKES GOING FROM DATA TO MAPS EASY
47. http://lat.ms/1u1tzNr
48. CONTRIBUTING TO AN OPEN SOURCE COMMUNITY
50. TRYING TO FIND INNOVATIVE DIRECTIONS FOR THE FUTURE OF MAPS
52. AN EXAMPLE
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
60. ANOTHER EXAMPLE
66. ENABLING AN ECOSYSTEM OF APPLICATIONS
67. sql API
68. dynamic
71. WE THINK WE’RE ONTO SOMETHING
72. THE FUTURE OF CARTODB
73. BETTER STORYTELLING
75. http://bit.ly/odysseyjs
76. EASIER TO FIND DATA
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/
88. http://academy.cartodb.com/
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