fixing location_id column