There are numerous streets with overnight parking (after 6 pm and before 9 am) in Astoria, in the case on the network of roads centered on Bay Street under the 101 Bridge. While it is almost certain you will not be bothered by cops in the surrounding parking lots, most are private or so not (officially) allow overnight parking, but on the streets you're good to go.

Spent the night here based on the recommendation. Decent spot, not too noisy. You can hear some of the traffic from Marine Drive which is a main street but overall good. Left undisturbed all night. I originally parked at Memorial Park but then read the review not to do that so I moved. Though there was a car parked at the park all night that was also left alone. Saw someone get out of it in the morning. Only downside was it must have been trash day the next morning as some loud trash vehicles came by. I would stay here again.

Good spot for a night. Somewhat quiet- don’t park in the memorial parking lot as there is no overnight parking there. Instead stick to Bay St.