which road orientation has new zealand state highway 8
(AND transportation.road_orientation (JOIN transportation.road_orientation.roads_with_this_orientation m.03d9cnt))