The 150-metre-long trail of waste took more than five months to remove at a cost of almost £6 million