Skip to content

Instantly share code, notes, and snippets.

View auremoser's full-sized avatar
🐙

Aurelia Moser auremoser

🐙
View GitHub Profile
@auremoser
auremoser / Carto DB
Last active October 12, 2015 03:18
SQL tipsheet
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 April 20, 2022 15:02 — forked from miguelbermudez/phobias.tsv
Data-Phobias
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 August 29, 2015 14:01
Keybase Auth

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 May 15, 2021 04:43
Yale Workshop: Humanitarian Data

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 October 12, 2016 13:22
Beirut Workshop: Blackout Map
battery.png
@auremoser
auremoser / index.html
Last active October 12, 2017 03:49
Beirut Workshop II: Map + Chart
<!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 November 13, 2015 18:17
Beirut Workshop - Notes

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:

@auremoser
auremoser / index.html
Last active August 29, 2015 14:16
[cartodb] html template
<!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 August 29, 2015 14:16
Tapestry Tip Sheet - CartoDB

##TAPESTRY FACT SHEET

####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 August 29, 2015 14:16
NICAR 15 - Workshop

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:

  • Stackedit: