It means to look at something but having to make a physical effort. To look over a fence you might have to stretch your neck. If you are in a big crowd you might have to crane your neck to see what is at the front.