Transportation departments in Texas and California are exploring artificial intelligence, and the latter may create a chief data and AI officer role. These agencies, an executive said, will face “major workforce transformations.”