Reddit mentions of The Geology of Florida

Not OP, but...

Wikipedia is a good place to start https://en.m.wikipedia.org/wiki/Floridan_aquifer

The most common book is by Randazzo (UF) The Geology of Florida.

Geologic History of Florida: Major Events that Formed the Sunshine State is a bit more speculative but the graphics are more refined.

USGS has a lot of information on the geology and the SJRWMD has a lot of information on the hydrogeology hgdb.

It can be overwhelming. The important thing to note that we sit on-top of 500 ft or so of marine deposits, most of which are interbedded sand/clay, called the Hawthorne Group. It serves as the confining layer for the floridan aquifer. Some hydrogeologist call it the intermediate aquifer, most drillers call it “salt and pepper”. Most single family and irrigation well are here.

Below that is the mostly limestone floridan aquifer. The top 500-ish ft is the upper aquifer, mostly competent ocala limestone, followed by a semi-confining layer, then about 500 ft of the lower aquifer, mostly avon park. This formation is usually fractured and vuggy (voids) and very productive. It is also the source of saline upconing. Most municipal wells are dual zone, drilled through both. But, the new school of thought is more wells with less flow each that isolate one zone (upper or lower, not both).

Below that is another confining layer and then the highly saline fernandina formation. It’s not very thick, 50-100 ft, and not really a practical water source.

The floridan recharges in the center of the state, gainesville area, and south georgia. South of central florida it’s very saline and the biscayne aquifer outcrops. West is saline from drowned karst in the gulf.