Excavation lake

An excavation lake (also a flooded gravel pit) is an artificial lake, which usually has its origins in the excavation of gravel or sand for construction materials or in some other kind of surface mining. In many cases, the excavation holes are landscaped according to the land restoration required by law. Because the excavation reached a point below the water table, lakes form naturally. Less frequently excavation lakes are intentionally created, especially as recreation areas.

In Germany the lakes are almost always used for fishing, since a fishery is created by law with every surface water. At some excavation lakes, beaches are added for swimming or other water sports, in particular boating, water skiing or windsurfing. To support these uses, large parking lots, changing areas, and eating areas are also set up. In some cases, the excavation lake serves as a nature reserve, as in the case of the lakes in the Attenborough Nature Reserve.

...
Wikipedia