Hi Mike,
Just so nobody gets confused from your statement "above the locks towards Sturgeon Lake"...
The high-water side of the Lindsay dam/locks leads to Scugog Lake, and the low-water side of the locks leads to Sturgeon Lake. The water flow is from Scugog downstream, over the dam, and into Sturgeon. You cannot fish between the dam and Sturgeon Lake until Walleye opens.