The Vancouver Aquarium located in Stanley Park opened in 1956 and was the first aquarium in Canada. This aquarium was the first one in the world to display an orca (though they banned orca capture in ‘96 and haven’t had one in residence since ‘01).
King Shark escapes confinement at an A.R.G.U.S. facility in episode 2x15 "King Shark".
Source: YVRShoots — Twitter
Cisco and Caitlin meet Dr. Tanya Lamden about her research in episode 2x15 "King Shark".
Aquarium in episode 3x10 "Six Feet Under the Sea".
Parking lot where the team meets before going to see the polar bear crime scene in episode 5x15 "Dead Bear Walking".
Source: Psych Forums
A man on Vertigo goes mad at the aquarium and takes hostages in episode 1x19 "Unfinished Business".
From episode 1x17 "E.B.E.".
Source: XF Marks the Spot
Ezra, Richard, and Jules wait to meet Maddie at the aquarium to discuss the new plan in episode 1x08 "In the Game".
Source: What's Filming
From episode 4x11 "The Battle of Tommy Giordano".