add sublocation and write to csv