Andy Eschbacher andy-esch

Step 1: Importing a Dataset and Creating a Map

Import the files subwaystations and starbucks_locations into your Carto account by drag and dropping them into the Dataset Dashboard, or pasting the URL into the Import dialogue

show little boxes for links to the files

Show how easy is to import files into CARTO! Explain the viewer the wide diversity of geodata supported in CARTO during the importing.

Introduction to Map Design

Andy Eschbacher, @MrEPhysics, eschbacher@cartodb.com

October 19, 2015

Workshop here: http://bit.ly/cdb-berkeley-mapdesign

Web Maps

Before we dive into CartoDB, let's talk a little bit about web maps

	CREATE OR REPLACE FUNCTION final_merge_touching( joined_geoms geometry[] ) RETURNS geometry[] AS $$
	BEGIN
	return joined_geoms;
	END
	$$ LANGUAGE plpgsql;


	CREATE OR REPLACE FUNCTION state_merge_touching(clusters geometry[], new_geom geometry) RETURNS geometry[] AS $$
	DECLARE
	joins geometry[] :='{}';

	<!DOCTYPE html><html lang="en"><head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">

	<script>(function () {
	function resolve() {
	document.body.removeAttribute('unresolved');
	}
	if (window.WebComponents) {

	--PART 2
	-- a.
	SELECT * FROM tornados
	SELECT cartodb_id FROM tornados
	-- b.
	SELECT * FROM tornados LIMIT 1
	SELECT * FROM tornados LIMIT 1 OFFSET 1
	SELECT * FROM tornados ORDER BY damage DESC LIMIT 10
	-- c.
	SELECT * FROM tornados WHERE cartodb_id < 30