I do this one sometimes, having learned it from the singing of Tom Kines on the RCA Victor LP boxed set "Canadian Folk Songs: A Centennial Collection", which is probably where Rogers found it. It is included in Edith Fowke's "Penguin Book of Canadian Folk Songs", where the notes attribute it to a Sandy Glendenning who emigrated from Scotland to Ontario in 1840. The tune is said to be part of "Of A' the Airts the Wind Can Blaw". The notes also allude to at least one singer using a different tune, "The Irish Emigrant's Lament". I don't know if this latter is the same song as "Spancil Hill", but I've always been struck by the similarities between the lyrics of "Spancil" and "Scarborough".