The painted logos were added as part of the construction of a nearby greenway and to warn motorists to expect a higher number of cyclists using the street – but residents complained they were “too big for such a small area”