Central line/arterial line durations have overlapping rows

Recently added some preliminary queries to get presence of central line (ref #312) / arterial line.

Ideally each row would contain the start time and end time of a line, and rows would not overlap. At the moment however, the rows are overlapping.

select
  cl1.*
from arterial_line_durations cl1
where icustay_id in
(
  select
  cl1.icustay_id
  -- , cl1.starttime, cl1.endtime
  -- , cl2.starttime as starttime2, cl2.endtime as endtime2
from arterial_line_durations cl1
left join arterial_line_durations cl2
  on cl1.icustay_id = cl2.icustay_id
  and cl1.starttime > cl2.starttime
  and cl1.endtime < cl2.endtime
where cl2.icustay_id is not null
)
order by cl1.icustay_id, cl1.starttime;

Similar query for a-lines.

select
  cl1.*
from central_line_durations cl1
where icustay_id in
(
  select
  cl1.icustay_id
  -- , cl1.starttime, cl1.endtime
  -- , cl2.starttime as starttime2, cl2.endtime as endtime2
from central_line_durations cl1
left join central_line_durations cl2
  on cl1.icustay_id = cl2.icustay_id
  and cl1.starttime > cl2.starttime
  and cl1.endtime < cl2.endtime
where cl2.icustay_id is not null
)
order by cl1.icustay_id, cl1.starttime;

Start with concepts/durations/central-line-durations.sql and concepts/durations/arterial-line-durations.sql, then use the overlap-detection queries and the example rows in this issue to inspect their outputs. Done means each line-duration result has a start and end time without overlapping rows for the same ICU stay.