select a.SRI as routeName, a.mp_start as StartOffset, a.mp_end as EndOffset, 
a.unique_id as gisID, a.street as majorRoadName, a.shape_leng as segmentLength,
a.town_name as city 
FROM  stu_roads_dec_09 a;