NACIS 2013 Workshop Guiding Slides

I created a number of maps with the group at my NACIS workshop. Combined with the information here, http://bit.ly/1bO1Pc0, these slides were my script. Maybe you can follow along? :)

Transcript

1. CartoDB Workshop @ANDREWXHILL
2. http://bit.ly/1bO1Pc0 ALL LINKS
3. Why did we build CartoDB? Part 1
6. http://vizzuality.com/projects/protectedplanet Text
8. MAKE MAPS ONLINE easier than ever before
9. What is it used for? Part 2
10. http://aitor.is/iceland-contour/
12. bit.ly/19fjB6R
13. SQL API
14. Data in
16. http://cartodb.github.io/torque/
17. http://bit.ly/16SQXk5
18. http://nychenge.com/
25. Accounts + Upgrades Part 3
26. .edu? email me your username! Organization upgrade to a magellan coupon code: nacis-2013
27. Data downloads Part 4
28. A rapid tour of the interface Part 5
29. CARTODB FEATURE TOUR Dashboard Tables Maps Visualizations Sharing Embedding Data editing Map editing CSS SQL
30. Importing Data Part 6
32. https://github.com/nvkelso/natural-earth-vector
33. https://github.com/nvkelso/natural- earth-vector/blob/master/zips/ 50m_cultural/ne_50m_urban_areas.zip import from url
34. http://bit.ly/ 1bMAmaI import shapefile
35. From maps to visualizations Part 7
37. http://bit.ly/15ujhxa adding new layers
38. Publishing and sharing Part 8
40. Data editing Part 9
42. CartoCSS Part 10
43. http://bit.ly/ 1fqnYxF custom cartocss
44. SQL - Filtering Part 11
45. NYC’s BEST BLOCKS something about bikability
46. create column station_d
47. UPDATE nyc_bestbikeblocks bb SET station_d = ( SELECT ST_Distance(the_geom::geography, bb.the_geom::geography) FROM citibike_stations ORDER BY the_geom <-> bb.the_geom LIMIT 1 )
49. create column station_d
50. STARTING THE ERIC FAN CLUB i’ve never really met a seagull i’ve liked
51. Import the Data Step 1
52. Create a Visualization Step 2
54. Duplicate the Visualization Step 3
55. Add a column, day_of_year Step 4
56. SQL!! Step 5
57. UPDATE tracking_eric SET day_of_year = extract(DOY FROM date_time) Step 5
58. SELECT ST_MakeLine(the_geom_webmercator ORDER BY date_time ASC) AS the_geom_webmercator, day_of_year FROM tracking_eric GROUP BY day_of_year Step 5
59. Make a choropleth* Step 6 *see blog about time normalization
60. Introduction to CartoDB.js Part 14
62. Create a Visualization Step 2
63. Create a Visualization Step 2
64. Free form Part 15