Tyler Dahlberg TDahlberg

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

SELECT *,
	CASE
		WHEN airspeed = 0 THEN 0

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

	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