Core aeration is done on turf areas as a means of reducing turf compaction. Reducing thatch buildup, improving the infiltration of water/nutrients, and encouraging deeper roots. In addition, creating an environment where grass seed can have direct contact with the soil. Check out this article on the benefits of aeration from Ryan Aerators.
