Skip to content

Instantly share code, notes, and snippets.

Avatar
🐙

Aurelia Moser auremoser

🐙
View GitHub Profile
@auremoser
auremoser / Carto DB
Last active Oct 12, 2015
SQL tipsheet
View Carto DB
SET GEOM FOR NYC
================
UPDATE name_of_db SET the_geom = ST_Transform(ST_SetSRID(ST_MakePoint(x_coordinate, y_coordinate),2263),4326)
//Order of Operations nested commands
//ST_MakePoint(x,y) turns any x, y value into a geometry.
(If this was latitude and longitude, that is the same as saying ST_MakePoint(longitude, latitude); backwards (x,y)->(long,lat)
//ST_SetSRID(our_new_geom, 2263)
//wrap in ST_Transform to 4326 - standard projection for geom column always - lat/long
@auremoser
auremoser / phobias.tsv
Last active Dec 28, 2015 — forked from miguelbermudez/phobias.tsv
Data-Phobias
View phobias.tsv
phobiaName phobiaDefinition
Ablutophobia Fear of washing or bathing.
Acarophobia Fear of itching or of the insects that cause itching.
Acerophobia Fear of sourness.
Achluophobia Fear of darkness.
Acousticophobia Fear of noise.
Acrophobia Fear of heights.
Aerophobia Fear of drafts, air swallowing, or airbourne noxious substances.
Aeroacrophobia Fear of open high places.
Aeronausiphobia Fear of vomiting secondary to airsickness.
@auremoser
auremoser / keybase.md
Last active Aug 29, 2015
Keybase Auth
View keybase.md

Keybase proof

I hereby claim:

  • I am auremoser on github.
  • I am aure (https://keybase.io/aure) on keybase.
  • I have a public key whose fingerprint is C90C EE21 DCC0 3952 B8F6 7780 9BB4 CC82 AD03 6066

To claim this, I am signing this object:

@auremoser
auremoser / haiti.md
Last active Aug 29, 2015
Yale Workshop: Humanitarian Data
View haiti.md

CartoDB Workshop -- Humanitarian Haiti Maps

Aurelia Moser, Map Scientist, CartoDB Workshop - Yale February 4, 2015

Find this document here: http://bit.ly/1At1cQQ | Gist Haiti Flag from wikipedia

Outline

  1. Introduction to CartoDB
@auremoser
auremoser / battery.png
Last active Oct 12, 2016
Beirut Workshop: Blackout Map
@auremoser
auremoser / index.html
Last active Oct 12, 2017
Beirut Workshop II: Map + Chart
View index.html
<!DOCTYPE html>
<html>
<title>Blackout Map</title>
<link rel="shortcut icon" href="https://raw.githubusercontent.com/auremoser/images/master/lightning-favicon.ico" type="image/x-icon">
<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
<!-- add cartoCSS stylesheet -->
<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/themes/css/cartodb.css"/>
@auremoser
auremoser / README.md
Last active Nov 13, 2015
Beirut Workshop - Notes
View README.md

CartoDB Workshop -- Lebanon

Making Sense of Data with Maps: Time-Series Graphs and Thematic Maps, with CartoDB

Aurelia Moser, Map Scientist, CartoDB Workshop - Beirut, Lebanon February 22, 2015

Find this document here: Stackedit: http://bit.ly/1EExero Gist: http://bit.ly/1LmO0h1

@auremoser
auremoser / index.html
Last active Aug 29, 2015
[cartodb] html template
View index.html
<!DOCTYPE html>
<html>
<head>
<title>HTML Template | 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" />
<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/themes/css/cartodb.css" />
@auremoser
auremoser / tapestry_info.md
Last active Aug 29, 2015
Tapestry Tip Sheet - CartoDB
View tapestry_info.md

##TAPESTRY FACT SHEET

CartoDB

####Geospatial Visualization in the Cloud Storytelling with Torque and Odyssey

#####http://tinyurl.com/cdb-tapestry

  • open source libraries for coders and creatives building narrative with data
  • easy education resources to learn
@auremoser
auremoser / nicar_15_mappingjs.md
Last active Aug 29, 2015
NICAR 15 - Workshop
View nicar_15_mappingjs.md

Mapping JS: Building narrative with geo data + CartoDB

Aurelia Moser, Map Scientist, CartoDB Workshop - NICAR Session Link

March 6, 2015, 3:20PM-4:20PM

Find this document here: