Prince Philip is seen opening Holme Sluices in Colwick in remarkable archive footage from the mid-50s.
The film was shot on May 5, 1955, when the Duke of Edinburgh was invited to Nottingham to open the gates which control water levels and flow rates on the River Trent.
He unveiled a plaque to mark the occasion.
The footage also shows the Prince being taken on a boat trip down the Trent, making it as far as Victoria Embankment before returning to Colwick.
Philip died at the age of 99 on April 9.