So is ignoring what I'm asking, forcing me to re-explain multiple things covered in the first post, and then just flat out telling me I'm wrong for wanting to do things a certain way.
This is really heavy derail material.
...says the person who was answering questions I wasn't asking, was offering options that ignored the original topic, etc.
If you cared about keeping the thread *on-topic*, why does everything you offer veer away from the topic?
I was trying to help. You were being rude.
*I'm* being rude? For trying to keep my own thread on topic in the very first page of the topic? Yeah. Sure. Lets call it 'rude'. (Note: That's sarcasm.)
Did you consider that I may have missed what you said?
Then be mature, apologize for missing the original topic, and get back on it.
I never said you were wrong.
I asked for a non-dwarf powered solution. You told me to use dwarf power.
Or that I was trying to tell you an easier alternative to something you had little information on?
Easier is not mentioned in the original topic. Anywhere. Efficient, yes. Self-sustaining is implied, but that's in no way "easy". And I *very specifically* state I don't want it to be exclusively dwarf powered. I even specifically state I want as little dwarven intervention as possible. If I wanted a dwarf manually moving 2800+ units of water by hand for just the initial filling of the cistern, plus more for whenever I want to use water, I'd just set it to dwarf power and be done with it. But that's not what I asked for, is it? (Not sure you'd know, seeing as how you haven't been on topic yet this entire thread.)
To give an example of how I like to do things, the very *very* first well I ever built in Dwarf Fortress was self-regulating so that it would auto-fill from a cistern and automatically shut off the cistern refill when the well had sufficient water to ensure that it would never overflow, all without dwarven intervention or even intervention from myself. I like automated structures.
Same question for you, though a bit broader: Is this in any way protected from things that would normally destroy buildings?
You can make the above system completely underground if that's what you mean.
From what I understand, if you move Naturally Flowing water in a river to another z-level, chances are it loses its Natural Flow status. I suppose I could move this water 50 tiles off to the side, into the side of a mountain, but I'd rather not.
To make a completely secure water source, you either have to run the pump manually, or use a water wheel. You then have to make sure nothing can get at either the pump or the water wheel. The pump can easily be protected by surrounding it with walls and having a floor grate on the inlet side of the pump where it's drawing water from the river. The water wheel is tricky, since it needs to be built over open water and can be attacked by something in the water. You might be able to get away with building the waterwheel over a sealed basin, pumping some water into the basin manually and then hoping that the horribly buggy code that DF uses to tell if water is moving doesn't notice that the water isn't going anywhere.
Well, I'm flushing the water through a grate, a fortification, and another grate before dropping it down several z-levels to the cistern, so securing the water is not too much of a problem. A building-destroyer who chooses to go the water route would probably ruin my day and flood my fortress... hm. I'll have to think about that. While I do...
Is there anything stopping me from just shoving a waterwheel above the inlet channel AND the outlet channel and connecting both to the pump? The initial water-flow in to the pump might start the pump going which MIGHT keep the flow on the inlet side long enough for the flow to hit the other waterwheel? Maybe? Confirm/deny? Or is the shut-off from the power of the waterwheel's loss of flow so fast that it would only work one time, and never again? Or might end up in a state where the inlet is completely full (and thus not-flowing) and the outlet is dry (and thus also not flowing).
I'm talking about building an underground waterwheel.
Yeah, I managed to figure that out about twenty minutes too slowly.

Water which is connected to a river, even if it's not a part of the original rivercourse, even if it has been diverted some distance into a dead end, will still power waterwheels. I just realized you might have water pressure problems if you divert the water underground before using it to power a waterwheel. However you can always build the waterwheel and pump at the same level as the river, and if that's on the surface, just enclose them with walls and a roof.
I am definitely curious about trying this out, especially just shoving a walls/floors around the whole construction and saying "VOILA!"
I am starting to realize why I don't understand your drawings though... I don't have that font on my computer, so they're not mono-spaced.
I'm beginning to think I should just save-scum, experiment, and see what works. I've been playing Dwarf Fortress since the 2D era, and I've never seen a clown. 3D? Never been past the first caverns. I keep getting distracted, or the occasional "I don't know how to use civilian alerts!"-esque problem crops up.