Skip to content

Instantly share code, notes, and snippets.

View andy-esch's full-sized avatar
🌳

Andy Eschbacher andy-esch

🌳
View GitHub Profile

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.
@andy-esch
andy-esch / join_touching.sql
Last active February 23, 2016 13:22 — forked from stuartlynn/join_touching.sql
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[] :='{}';
@andy-esch
andy-esch / index.html
Created February 10, 2016 19:55 — forked from stuartlynn/index.html
Color Picker
<!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) {
@andy-esch
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
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
--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