all location information merged into location table