fix the division view to do one query for each locality.