select a.segmentid as agencyid, a.aadt_year as calendarYear, a.aadtvpd,
a.percentheavyvehicles, a.peakhourlyvolume
from segmenttraffic a;