select avl.acdyear_number as agencyID,
      avl.unit_nbr as V1,
      avl.vehicle_direction as v1_direction,
from n46jad.acdu_vehicles_loc avl
where avl.unit_nbr = '01'
order by avl.acdyear_number, avl.unit_nbr
