I remember being astonished at Dutch cycle facilities - smooth, wide, big turning circles, priority at junctions, etc etc... then I realised that they had been conceived, designed and installed by people who cycle every day - and whose family members cycle every day. It's dead simple, really.
The laughable stuff above has been painted by someone who's never ridden a bike in a town.