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
SELECT *,
CASE
WHEN airspeed = 0 THEN 0
WHEN airspeed > 0 AND airspeed < 16 THEN 1
WHEN airspeed >= 16 THEN 2
END AS airspeed_bucket
FROM lifewatch.forward_trajectory_7_8
/** torque_cat visualization */
Map {
-torque-frame-count:128;
-torque-animation-duration:30;
-torque-time-attribute:"date_time";
-torque-aggregation-function:"CDB_Math_Mode(torque_category)";
-torque-resolution:1;
-torque-data-aggregation:linear;
}
#forward_trajectory_7_8{
comp-op: source-over;
marker-fill-opacity: 1;
marker-line-color: #FFF;
marker-line-width: 0;
marker-line-opacity: 1;
marker-type: ellipse;
marker-width: 3;
marker-fill: #FFFFFF;
}
#forward_trajectory_7_8[frame-offset=1] {
marker-width:2.5;
marker-fill-opacity:0.675;
}
#forward_trajectory_7_8[frame-offset=2] {
marker-width:2;
marker-fill-opacity:0.45;
}
#forward_trajectory_7_8[frame-offset=3] {
marker-width:1.5;
marker-fill-opacity:0.3;
}
#forward_trajectory_7_8[frame-offset=4] {
marker-width:1;
marker-fill-opacity:0.2;
}
/* Songbirds */
#forward_trajectory_7_8[value=2] {
marker-fill: #FF6527;
}
/* Waterbirds */
#forward_trajectory_7_8[value=3] {
marker-fill: #1EC7C8;
}
/* Wind */
#forward_trajectory_7_8[value=1] {
marker-width: 1;
marker-fill: #1695eb;
marker-fill-opacity: 0.5;
}
#forward_trajectory_7_8[value=1][frame-offset=1]{
marker-width: 0.9;
marker-fill-opacity: 0.25;
}
#forward_trajectory_7_8[value=1][frame-offset=2]{
marker-width: 0.8;
marker-fill-opacity: 0.125;
}
#forward_trajectory_7_8[value=1][frame-offset=3]{
marker-width: 0.7;
marker-fill-opacity: 0.0625;
}
#forward_trajectory_7_8[value=1][frame-offset=4]{
marker-width: 0.6;
marker-fill-opacity: 0.3;
}