It's not working that way for me; I cast in on an area behind a locked door, it appears there's a room there on my map, but wizard site does nothing.

I can cast it 10 times on the same spot.