Due to a gross engineering oversight, I managed to flood my young fortress by wanting to channel sourced water into an underground reservoir. It naturally overflowed and drowned the entire complex. 4 of 7 died, I abandoned.
Then reclaimed, and planned to build screw pumps powered by a water wheel. I wanted to pump out enough of the fortress to pop in a floodgate to stop the sourced water flow, then eventually drain my halls. Due to another misunderstanding of water pressure the pumps were aimed to dump water into an already full channel a z-level below, which they can't , so another flood resulted, now one Z-level higher, on the level of my one finished pump. I can't even shut it down, because it's powered by waterwheel and the emergency disconnect lever was built too close, and is now also under water.
I'm determined to tame the waters and completely reclaim that fortress. AND build a huge and secure waterfall to show off my dominion of the rivers. (Although the starting dwarves are most likely hydrophobic by now.)
Do you have expertise in dealing with sourced water flows? How much pumps are needed to offset a sourced flow?
Also, can siege engines destroy machinery? That water wheel must be stopped and I thought of shooting it down by ballista from remotely, if possible.