This is a very real problem and the only viable solution I know of is for the local government to mandate a certain ratio (with error margins) of different type

This is a very real problem and the only viable solution I know of is for the local government to mandate a certain ratio (with error margins) of different types of establishments. For example, not more than 15% of a street can be hotels, or clothing stores, perhaps at least 25% be bars/restaurants/entertainment, etc.