This might be a useful book to track down: The Pits
The Pits is an artists book by Janet Hodgson, documenting her 4-year art project based around the biggest archaeological dig in the UK at Whitefriars, Canterbury.
It could provide some useful insight into how one artist has portrayed pits through art.