http://gundam.sigeosrl.com/fiber/releases/estrip/tratte_estrip.zip

Query estrazione:
select 
nr.descr,
nr.work_app,
rs.pkid,
rs.code,
drp.descr as prop,
drpo.descr as posa,
rsd.notes,
rs.geom
from 
rel_segments rs, 
rel_segment_details rsd,
net_reference nr,
deco_route_prop drp,
deco_route_posa drpo
where 
(rsd.source=1 or rsd."source"=2) and 
rs.is_current=1 and
rsd.pkid_reference=rs.pkid_reference and 
rsd.code=rs.code and 
rsd.is_current=1 and 
rs.pkid_reference=nr.pkid and
nr.id_prov < 1000 and
drp.pkid=rsd.proprietario and
drpo.pkid=rsd.posa_area
order by 1,2

Totale:
select sum(ST_Length(ST_Transform(rs.geom, 32632)))
from 
rel_segments rs, 
rel_segment_details rsd,
net_reference nr,
deco_route_prop drp,
deco_route_posa drpo
where 
(rsd.source=1 or rsd."source"=2) and 
rs.is_current=1 and
rsd.pkid_reference=rs.pkid_reference and 
rsd.code=rs.code and 
rsd.is_current=1 and 
rs.pkid_reference=nr.pkid and
nr.id_prov < 1000 and
drp.pkid=rsd.proprietario and
drpo.pkid=rsd.posa_area