CartoDB CSS and SQL to visualize flight tracks of gull Eric grouped by seasonal behaviour.

ericFlightPaths.css

/** category visualization */

#bird_tracking {
   line-width: 1;
   line-opacity: 0.9;
}

#bird_tracking[behaviour="1. Egg incubation"] {
   line-color: #b81609;
}
#bird_tracking[behaviour="2. Chick rearing"] {
   line-color: #ff9900;
}
#bird_tracking[behaviour="3. Postfledging"] {
   line-color: #2167ab;
}

ericFlightPaths.sql

SELECT
  ST_MakeLine(the_geom_webmercator ORDER BY date_time ASC) AS the_geom_webmercator, 
  CASE 
    WHEN date_time >= '2013-05-28' AND date_time < '2013-06-25' THEN '1. Egg incubation'
    WHEN date_time >= '2013-06-25' AND date_time < '2013-07-24' THEN '2. Chick rearing'
    ELSE '3. Postfledging'
  END as behaviour
FROM bird_tracking
WHERE
  device_info_serial = 851
  AND userflag IS FALSE
  AND date_time >= '2013-05-17'
  AND date_time < '2013-12-19'
GROUP BY behaviour 
ORDER BY behaviour

jurgenFlightPaths.css

/** category visualization */

#bird_tracking {
   line-width: 1;
   line-opacity: 0.9;
}

#bird_tracking[behaviour="1. Egg incubation"] {
   line-color: #b81609;
}
#bird_tracking[behaviour="2. Chick rearing"] {
   line-color: #ff9900;
   line-comp-op: dst-over;
}
#bird_tracking[behaviour="3. Postfledging"] {
   line-color: #2167ab;
   line-comp-op: dst-over;
}

jurgenFlightPaths.sql

SELECT
  ST_MakeLine(the_geom_webmercator ORDER BY date_time ASC) AS the_geom_webmercator, 
  CASE 
    WHEN date_time >= '2013-05-17' AND date_time < '2013-06-07' THEN '1. Egg incubation'
    WHEN date_time >= '2013-06-07' AND date_time < '2013-07-21' THEN '2. Chick rearing'
    ELSE '3. Postfledging'
  END as behaviour
FROM bird_tracking
WHERE
  device_info_serial = 801
  AND userflag IS FALSE
  AND date_time >= '2013-05-17'
  AND date_time < '2013-12-19'
GROUP BY behaviour 
ORDER BY behaviour