Skip to content

Instantly share code, notes, and snippets.

@andrewxhill
Created May 13, 2014
Embed
What would you like to do?
Notes

Chapter 1: Introduction

part 4: CSV

1. Open CSV to look inside
2. Import CSV and compare difference
3. Show what happens when a CSV has no lat/lng
	3.1. Show how to georef
4. Show datatypes
5. Take a look at the data on a map

part 5: Visualization

1. Difference between map/table and visualization
2. Create a named visualization
3. Publish our first map

Part 6: On privacy

a. Public on web
b. Anyone with link
c. Anyone wiht password
d. Private

part 7a: Adding style

1. Tour wizard
2. Tour shared parameters of the wizard
3. Composite operations
4. Publish our second visualization
5. Show 2 visualizations 1 table
6. http://colorbrewer2.org/

Part 7b: Introduction to CartoCSS

0. marker-width
1. marker-fill
2. marker-line-color
4. .. opacity
5. marker-comp-op

Part 8: Data editing

1. Create a new table
2. Create a new column called 
3. Add a polygon
4. Edit the polyon
5. Edit attributes
6. Do same to a point in Eric

Part 9: Introduction to SQL

1. Filter data
2. WHERE
3. LIMIT
4. ORDER
5. count(*), sum(), avg
5. http://academy.cartodb.com/
6. http://postgis.refractions.net/

Part 10: Modifying data with SQL

1. SELECT * FROM tracking_eric ORDER BY duration_i ASC
2. SELECT * FROM tracking_eric WHERE cartodb_id = 2824 
3. clear view
4. UPDATE tracking_eric SET duration_i = 10000 WHERE cartodb_id = 2824 
5. DELETE FROM tracking_eric WHERE cartodb_id = 2824 
6. UPDATE tracking_eric SET day_of_year = extract(DOY FROM date_time)

Chapter 2: NYC's Best Blocks

Part 1: Introduction to Shapefiles

1. Download some data, http://bit.ly/1mQ3Hq8
2. Look at it locally, overview prj etc
3. Upload it

Chapter 3: CartoDB.js

External

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment