Yale 2013 Workshop

Free workshop given in New Haven in December 2013

Transcript

1. @ANDREWXHILL INTRODUCTION TO CARTODB
2. BACKGROUND
9. MAYBE AN OPEN SOURCE TOOL THAT MAKES MAPS EASY AND BEAUTIFUL WOULD BE USEFUL… COMMON NEED?
10. 2.5 YEARS AGO
13. WITHOUT THE TOP IN SIGHT THE RELEVANCE OF MAPS IS AT AN ALL TIME HIGH
15. FAST FORWARD 5 YEARS
22. AN IMPORTANT GOAL FOR ANY MAP MAKER LET’S THINK ABOUT STORYTELLING
24. you most ! people
26. http://bit.ly/1cZSry2
27. NO BIAS HERE :) MAPS ARE A POWERFUL STORYTELLING TOOL
28. MAP LITERACY
29. MAP LITERACY
32. A LOT WRITTEN ON OBJECTIVES
34. CONSIDERING ALL THAT FOUR TYPES OF MAPS TO USE TO TELL A STORY
35. THE DATA OR THE DESIGN IS THE WHOLE STORY TYPE 1: DATA SHOWCASE
36. http://aitor.is/iceland-contour/
41. HIGHLIGHT SOMETHING ABOUT THE VIEWERS WORLD TYPE 2: YOUR WORLD
44. HOW ABOUT MORE EXCITING ONES?
45. OPENSTREETMAP
50. http://nychenge.com/
51. http://nychenge.com/
52. http://bit.ly/1dT2wSj FULL STORY
53. http://bit.ly/1aDGM5g
54. TO THEMATIC MAPS AND BEYOND TYPE 3: TRENDS & CHANGE
57. http://bit.ly/16SQXk5
60. http://bit.ly/18G7YWH
62. blog.cartodb.com
63. TAKE THE VIEWER THROUGH A STORY BY THE HAND TYPE 4: NARRATIVE MAPS
64. http://bit.ly/12edGe2
65. bit.ly/19fjB6R
66. http://bit.ly/1kgcw5K
68. BETTER MAPS & BETTER DATA VISUALIZATION WILL MAKE FOR BETTER STORYTELLING
69. http://bit.ly/1cZSry2
70. SOME GOOD WAYS TO MAKE MAPS GETTING FROM HERE TO THERE?
74. cartodb.com/ academy 4500+ Students | 1.5 Hour Lessons | Free
75. OVERVIEW
76. LIBRARIES
77. http://bit.ly/16SQXk5
78. http://bit.ly/16SQXk5
79. http://bit.ly/16SQXk5
80. BASEMAPS
85. DATA
87. INTERACTION
90. INTEGRATION
94. THIS ALL TAKES TIME
96. THAT’S WHY WE’RE GOING TO USE CARTODB
98. FIRST MAP IN ABOUT 5 MINUTES
99. CARTODB WHAT’S IN THE BOX
104. Tile API
105. SQL API
106. simple
108. Data in
109. GO!
110. PART ONE CARTODB BASICS
111. http://cartodb.com/ academy
115. PART TWO BASIC SQL http://bit.ly/1cuqyji
116. a. SELECT BASIC SQL
117. b. LIMIT,ORDER,ETC BASIC SQL
118. c. FILTER BASIC SQL
119. d. MATH BASIC SQL http://www.postgresql.org/docs/8.0/static/functions-math.html
120. PART THREE GEOMETRY http://bit.ly/1cuqyji
121. POINTS
122. POLYGONS
123. LINESTRINGS
124. PROJECTIONS https://github.com/mbostock/d3/wiki/Geo-Projections
126. CARTODB CONVENTIONS
127. POINTS MULTILINESTRINGS MULTIPOLYGONS
128. the_geom PROJECTION WGS 84 SRID 4326
129. the_geom_webmercator PROJECTION WEB MERCATOR SRID 3857
130. the_geom ALL EDITS SHOULD HAPPEN ON: the_geom_webmercator ALL MAPS COME FROM
131. ST_GeometryType
132. ST_SRID
133. ST_AsText
134. ST_XMax
135. CDB_LatLng
136. GEOMETRY CALCULATIONS
137. ST_Area
138. ST_Length
139. ST_NumGeometries
140. ST_Distance
141. ::geography
142. PART FOUR MORE SQL http://bit.ly/1cuqyji
143. KANSAS CITY ST_DWithin
144. Bedford city ST_Intersects()
145. UPDATE ST_Intersects()
146. PART FIVE OTHER SQL
147. ST_Buffer
148. ST_MakeLine
149. ST_Centroid
150. ST_Simplify
151. ST_Union
152. PART SIX WHATEVER YOU WANT