Andy Eschbacher andy-esch

CartoDB Workshop -- Alaska Press Club

Find this document here: http://bit.ly/1yGlQvV

Andy Eschbacher, Map Scientist, CartoDB

Workshop, March 24th, 2015, School of International and Policy Affairs, Columbia University

	<!doctype html>
	<html>
	<head>
	<title>Car accidents per person by neighborhood</title>
	<script src="http://www.chartjs.org/assets/Chart.js"></script>
	<meta name = "viewport" content = "initial-scale = 1, user-scalable = no">
	<script src="http://libs.cartocdn.com/cartodb.js/v3/cartodb.js"></script>
	<style>
	canvas {
	}

	<!DOCTYPE html>
	<html>
	<head>
	<title>Lesson 1 \| CartoDB.js \| CartoDB</title>
	<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
	<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
	<link rel="shortcut icon" href="http://cartodb.com/assets/favicon.ico" />

	<!-- Map takes up full browser window -->
	<style>

	<!DOCTYPE html>
	<html>
	<head>
	<title>Named maps with createLayer \| CartoDB</title>
	<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
	<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
	<link rel="shortcut icon" href="http://cartodb.com/assets/favicon.ico" />

	<!-- Map takes up full browser window -->
	<style>

	{
	"version": "0.0.1",
	"name": "namedmap_ex_test_interactive",
	"auth": {
	"method": "open"
	},
	"layergroup": {
	"layers": [{
	"type": "mapnik",
	"options": {

	-- By using a table with 4^zoom rows, the following sql statement produces a checkboard
	-- The following config works for making a checkerboard with zoom = 3 (4^3 = 64 rows)
	WITH
	vars AS (SELECT 3 AS zoom)

	SELECT
	(8 * ss.c1 + ss.c2 = ss.cartodb_id) as tf,
	ss.c1,
	ss.c2,
	ss.cartodb_id as cartodb_id,

	{
	"auth": {
	"method": "open"
	},
	"layergroup": {
	"layers": [
	{
	"options": {
	"cartocss": "#namedmap_ex_sql_multilayer{ marker-width: 10; marker-fill: #FF0000; marker-allow-overlap: true;}",
	"cartocss_version": "2.0.1",