I've heard that the "no foreigner" signs are mainly in Hokkaido and used to avoid spectacles caused by heavily intoxicated Russians.