Urbanly speaking, of course.
The OPP gets around this in a couple of ways. A lot of the staffing at northern Ontario detachments is recruits. Their training officer might have a year or two on (at that location), the Sgt., if there is one onsite, might have 5 or 6 years on, possibly as a constable at that same detachment. Most northern detachments are fixed duration. In an effort to get people to stay beyond their term, 'posting incentives' can be in the five figures for another full terms. Even with that, most do their duration then transfer south. Gone are the days of arbitrary 'administrative' transfers; I'll bet there hasn't been one for 30 years. Unless you volunteer for a transfer (paid or unpaid) or enter the promotional process, you can potentially spend your career in one location.
Unrealistic career expectations aren't unique to the CAF. I partially blame recruiting, but in the desire to make a job seem fulfilling, exciting, glamorous, etc., they fail to mention the a lot of the realities. I'm not saying it should be done at the advertising or attracting stage, but it needs to covered at some point. In policing, 'your can be (chief), you can help people', needs to tempered with you get to do a lot of that at night and a lot of people you encounter don't want your help - or actively don't like you.