More than you'd want to know about the Long Island, NY aquifers.
http://www.dec.ny.gov/lands/36183.html
It's easy to get water from wet sand -- basically, the water just dribbles out. Not so easy to get water from wet organic soil, because at best what dribbles out is full of assorted compounds -- hopefully natural compounds, but still not what you want when you're looking for a glass of clear water.
And then there's clay, which is the cousin of pottery, which water is mostly unable to pass through. For that matter, if you've ever tried to dig through clay, a shovel is unable to pass through.
My guess, as a professional electronics engineer, is that if there's a layer of clay underground, and then a layer of sand on top of the clay, then any rainwater will get trapped in the sand layer. The rainwater will pass through icky soil on the way to the sand, but the sand will tend to act like a water-filter as your well-pipe extracts water from the sand. At least it will be cleaner than trying to suck water out of the soil.
percolation
Karst topography forms when underground layers of limestone are dissolved by groundwater. This process creates unique landforms such as sinkholes, caves, and underground drainage systems. The dissolution of limestone occurs due to its chemical composition and the acidic nature of groundwater.
acidic groundwater
When limestone on the surface is dissolved by groundwater, it forms features such as caves, sinkholes, and disappearing streams, through a process known as karst topography. This occurs because limestone is a rock that can easily be dissolved by the slightly acidic nature of groundwater, creating these unique geological formations over time.
Groundwater can dissolve rock, typically limestone or dolomite, over time as it flows through cracks and fractures underground. This process forms caves through a combination of chemical weathering and erosion, creating underground voids and passages that we see as caves.