So, I embarked at the head of a river, but this river had a tendency to never be full of water, so my dwarves and visitors would often path through it, much to my dismay and annoyance. This was especially annoying when visitors would spend entire seasons swimming in the river rather than pathing into the safety of my fortress to study or join in the inn's festivities. To fix this, I decided to build a floor over the entire river. To my surprise, this was possible, as apparently it is possible to build floors right up to the edge of the map. This was also a safety feature, as I was using the river as a water source for flooding what I hoped would become an underground tree farm, and did not want to leave the fortress vulnerable to attack via the plumbing.
Alas, I seem to have made a grave mistake. Now that the river has been completely floored over, it has dried up. I think I am going to have to dismantle my floor so that rain water can once again fill my river. Hopefully the river's ecosystem will not have been completely destroyed by my mistake and fish will return once the water has been restored. I am tempted to do a little SCIENCE here instead, though. There is an aquifer only a few z-levels further down. I could potentially pump water up into the river without removing the floors. Would this allow fish to return, as the water would be over a river bed and would be flowing off the edge of the map?