--input:
event_id,event_timestamp,equip_id,acesso,sp,km,metros,sentido,faixa,vehicle_id,event_origin_id,evento_timestamp_origin,equip_id_origin,segment_duration_a,event_destination_id,event_timestamp_destination,equip_id_destination,segment_duration_b
'4986','2016-12-18 00:09:40','00016022','000','425','227','950','Sul',2,'HTG3277',,,,,'35813','2016-12-18 01:27:54','00016020','01:18:00'
'35813','2016-12-18 01:27:54','00016020','000','425','338','200','Sul',1,'HTG3277','4986','2016-12-18 00:09:40','00016022','01:18:00','28','2017-02-26 00:00:03','00016022','69 days 22:32:00'
'28','2017-02-26 00:00:03','00016022','000','425','227','950','Sul',2,'HTG3277','35813','2016-12-18 01:27:54','00016020','69 days 22:32:00','11842','2017-02-26 00:24:00','00000000','00:23:00'
'11842','2017-02-26 00:24:00','00000000','000','425','262','320','Sul',2,'HTG3277','28','2017-02-26 00:00:03','00016022','00:23:00','8624','2017-03-04 00:17:09','00016022','5 days 23:53:00'
'8624','2017-03-04 00:17:09','00016022','000','425','227','950','Sul',2,'HTG3277','11842','2017-02-26 00:24:00','00000000','5 days 23:53:00','19180','2017-03-04 00:40:38','00000000','00:23:00'
'19180','2017-03-04 00:40:38','00000000','000','425','262','320','Sul',2,'HTG3277','8624','2017-03-04 00:17:09','00016022','00:23:00','5309','2017-03-22 00:10:16','00016020','17 days 23:29:00'
'5309','2017-03-22 00:10:16','00016020','000','425','338','200','Sul',1,'HTG3277','19180','2017-03-04 00:40:38','00000000','17 days 23:29:00',,,,

SELECT eventid, eventdt, * --, trecho_id
    FROM ocr.ocr_proc e1
    INNER JOIN LATERAL(
        SELECT event_timestamp AS eventdt, event_id as eventid, equip_id as equipid --, as trecho_id
          FROM ocr.ocr_proc
          WHERE
            vehicle_id = e1.vehicle_id AND
            e1.event_timestamp < event_timestamp + interval '12 hours' AND
            e1.event_timestamp > event_timestamp - interval '12 hours'
          ORDER BY event_timestamp
          --LIMIT 1
    ) AS e2 ON True

--expected output: n number of segments in trip, m number of trips

trip_id,segment_id,event_id,event_timestamp,equip_id,acesso,sp,km,metros,sentido,faixa,vehicle_id,event_origin_id,evento_timestamp_origin,equip_id_origin,segment_duration_a,event_destination_id,event_timestamp_destination,equip_id_destination,segment_duration_b
1(1-m),1(1-n),'4986','2016-12-18 00:09:40','00016022','000','425','227','950','Sul',2,'HTG3277',,,,,'35813','2016-12-18 01:27:54','00016020','01:18:00'
2,1,'35813','2016-12-18 01:27:54','00016020','000','425','338','200','Sul',1,'HTG3277','4986','2016-12-18 00:09:40','00016022','01:18:00','28','2017-02-26 00:00:03','00016022','69 days 22:32:00'
3,1,'28','2017-02-26 00:00:03','00016022','000','425','227','950','Sul',2,'HTG3277','35813','2016-12-18 01:27:54','00016020','69 days 22:32:00','11842','2017-02-26 00:24:00','00000000','00:23:00'
4,1,'11842','2017-02-26 00:24:00','00000000','000','425','262','320','Sul',2,'HTG3277','28','2017-02-26 00:00:03','00016022','00:23:00','8624','2017-03-04 00:17:09','00016022','5 days 23:53:00'
5,1,'8624','2017-03-04 00:17:09','00016022','000','425','227','950','Sul',2,'HTG3277','11842','2017-02-26 00:24:00','00000000','5 days 23:53:00','19180','2017-03-04 00:40:38','00000000','00:23:00'
6,1,'19180','2017-03-04 00:40:38','00000000','000','425','262','320','Sul',2,'HTG3277','8624','2017-03-04 00:17:09','00016022','00:23:00','5309','2017-03-22 00:10:16','00016020','17 days 23:29:00'
7,1,'5309','2017-03-22 00:10:16','00016020','000','425','338','200','Sul',1,'HTG3277','19180','2017-03-04 00:40:38','00000000','17 days 23:29:00',,,,