How big a problem is dog fouling in Scotland?

More than 20 years after an act was introduced to tackle the issue - how big a problem does it remain?