Ripon police say that a group of Canada and Greylag geese, and a Mute Swan, were shot through the wings and legs - and left to die.
They were discovered last month by an ecological survey team at a nature reserve.
More top news
Mike Barton of Durham Police is the national policing lead for the programme, which aims to turn around thousands of lives.
Ian Carr was found by the occupants of the home and stayed there snoozing until the police arrived and woke him up.
A security guard was threatened with a knife as the pair stole a black cash box before making off in a waiting car.