Check out the forum at
www.ifish.net - these guys really give out some great info - use the search key to go through past postings of prime fishing areas.
I go up to the Columbia yearly and fishing with a 30' boat will be a bit large for most popular areas because of the boat traffic. The mouth of the Deschutes is a great place for trolling for salmon and steelhead. Launch at Celilo Falls park.
Sturgeon fishing is good from a large boat but anchoring in swift current needs some expertise. Most sturgeon waters will be 30' to 120' ft deep. Check to see if you can keep a keeper 4' to 5 1/2' - quotes can cause a catch and release to kick in anytime now.
The more I think of a nice place for the newbee to go and have a good and safe time - I think of the mouth of the John Day river. You can troll above the dam for salmon and steelhead, anchor up for sturgeon, and fish for walleye and bass in the columbia and John day rivers. Also, there is a great boating park 4 miles up the John Day that has minimal traffic and is "out of the way".
I you have anymore question about the Columbia - I grew up in The Dalles and have fished mainly the CR Gorge and it tributraies.
One of the highlites of the past few fishing trips has been hiring a great guide to go up the Deschutes River for steelhead. You are going up class 3 & 4 rapids and it's a trip everyone should do once. We use a great guy, Jack LaFond from Young's Quide service.
site:
http://www.fishyfs.com/
You can PM me for a specifics about the fishing in the Gorge area. I don't really know the Portland to Astoria fishing that well.
If you are going out to Buoy 10 - please do your homework. This is a dangerous place for even the experienced angler.
[signature]