I finally achieved my goal! I cleared out a whole map (or at least the rectangle of map that isn't fully filled in) as well as a sizeable bit of its sides after some mess ups, after doing so I have 1136 coal, 732 copper ore, a clean 100 iron ore, 57 gold ore, 54 emiril ore, 36 rubies and 11 diamonds
should mention I've started doing this on an earlier build before anything too crazy was added so there were only two bases and chests
also I've done this over the span of several months, but if I were to sum it all up I think it would be a little under two weeks worth of non-stop digging