There is a sketch in the Globe of Burns' funeral procession in 1796 which shows a similar view. Not a lot has changed in Dumfries except the mid steeple has been covered in scaffolding for the past few years. I'd guess from the clothing styles and the horse drawn vehicles this view dates from perhaps 1890-1900.