Consolidating data for the transportation analysis work