Andy Eschbacher andy-esch

## Step1.md

      
              6 files
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                andy-esch
                / Step1.md
            
            
              Last active
              September 16, 2016 13:12
                — forked from mehak-sachdeva/a. Introduction to Builder.md
            
          
    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.


## join_touching.sql
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[] :='{}';

## index.html
<!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) {

## real-time.md

      
              1 file
            
          
              1 fork
            
          
                0 comments
              
            
              1 star
            
          
                andy-esch
                / real-time.md
            
            
              Last active
              April 4, 2016 01:54
                — forked from makella/real-time.md
            
              
                UC Berkeley Workshop: Introduction and Map Design
              
          
    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


## TransSiberianSimplified.geojson

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                andy-esch
                / TransSiberianSimplified.geojson
            
            
              Last active
              August 29, 2015 14:23
                — forked from HeikkiVesanto/TransSiberianSimplified.geojson
            
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## sql_statements.sql
--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
	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