Tyler Dahlberg TDahlberg

ICERM Data Science: references and links

Talk delivered 2015-07-29 at ICERM workshop on "mathematics and data science"

context

google search trends: data science

Nocturnal bird migration forward trajectory classified by airspeed into songbirds and waterbirds - Night of April 7-8, 2013

https://inbo.cartodb.com/u/lifewatch/viz/88c30be4-1063-11e5-a9ae-0e853d047bba/public_map

SQL

SELECT *,
	CASE
		WHEN airspeed = 0 THEN 0

Libraries for a modern geospatial workflow

Distribution

Numpy

Introduction to the CartoDB interface

This page can always be found at: http://bit.ly/cdb-harvard

Tour of dashboard
Common data
Uploading data
Tour of table and map view
Publishing maps
Public profile

Data: Denver Traffic Accidents

Go to your traffic_accidents table and let's start by creating a new visualization

Overview of the Torque Wizard

key things

CartoDB Build Day

Introduction

Hello!

this document

http://bit.ly/cdb-fiesta

Storytelling from Space: Tools/Resources

This list of resources is all about acquring and processing aerial imagery. It's generally broken up in three ways: how to go about this in Photoshop/GIMP, using command-line tools, or in GIS software, depending what's most comfortable to you. Often these tools can be used in conjunction with each other.

Acquiring Landsat & MODIS

Web Interface

USGS Earth Explorer - Browser and data access (create a login)
http://earthexplorer.usgs.gov/

Landsat archive

PostgreSQL & PostGIS Cheatsheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.

	WITH point1 AS (
	SELECT cdb_geocode_postalcode_point(<%= postcode1 %>, 'USA') as geo
	),
	point2 AS (
	SELECT cdb_geocode_postalcode_point(<%= postcode2 %>, 'USA') as geo
	),
	route AS (
	SELECT
	r.shape as geo,
	r.length