A database for the management and presentation of the fish collected data has been developed as part of the Flowtech research project. There is a snapshot of the observed fish that indicates the Fish Estimated Microhabitat Position. To maintain consistency, snapshots were exclusively taken from the left camera of each video. Blue cycles indicate each target fish. The platform presents the requirements of the fish and size classes, the mean water depth, mean water column velocity and substrate type.
Coding Ecohydraulics One camera Video recording
Stereoscopy Mean Water Column Velocity (m/s) Mean Water Depth (m) Snapshot Start time (L) End time (L) Duration in position (sec) Date Fish Size (cm) Distance from riverbed (cm) Dominant substrate
Vid 6 0.26 0.79 F001907 00:18:08 00:20:40 152 2022-09-08 13.00 0 cobbles
Vid 6 0.26 0.79 F001907 00:27:06 00:28:33 87 2022-09-08 13.00 0 cobbles
Vid 6 0.26 0.79 F003321 00:31:49 00:33:21 92 2022-09-08 21.50 0 cobbles
Vid 6 0.26 0.79 F003336 00:31:49 00:36:25 276 2022-09-08 16.20 0 cobbles
Vid 6 0.26 0.79 F003336 00:36:52 00:39:42 170 2022-09-08 16.20 0 cobbles
Vid 6 0.26 0.79 F003336 00:39:54 00:43:13 199 2022-09-08 16.20 0 cobbles
Vid 6 0.26 0.79 F004000 00:40:00 00:41:13 73 2022-09-08 15.00 0 cobbles
Vid 6 0.26 0.79 F004000 00:43:51 00:44:26 35 2022-09-08 15.00 0 cobbles
Vid 6 0.26 0.79 F004000 00:44:31 00:44:47 16 2022-09-08 15.00 0 cobbles
Vid 6 0.26 0.79 F004000 00:45:44 00:46:00 16 2022-09-08 15.00 0 cobbles
Vid 6 0.26 0.79 F004953 00:49:56 00:50:37 41 2022-09-08 13.80 13.8 cobbles
Vid 8 0.74 0.80 F000254 00:00:25 00:12:49 744 2022-09-08 16.90 0 boulders
Vid 8 0.74 0.80 F000036 00:00:26 00:12:49 743 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:15:37 00:22:36 419 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:22:40 00:22:48 8 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:22:54 00:25:10 136 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:28:00 00:28:59 59 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:29:06 00:29:12 6 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:30:44 00:32:14 90 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:32:17 00:33:40 83 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:33:45 00:34:54 69 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:35:00 00:37:40 160 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F000036 00:39:45 00:48:00 495 2022-09-08 13.00 0 boulders
Vid 8 0.74 0.80 F004247 00:42:45 00:44:40 115 2022-09-08 26.60 15.4 boulders
Vid 8 0.74 0.80 F004529 00:44:18 00:45:28 70 2022-09-08 10.80 9 boulders
Vid 16 0.33 0.88 F002400 00:21:07 00:21:50 43 2022-10-15 15.40 2.7 cobbles
Vid 16 0.33 0.88 F002400 00:31:40 00:33:02 82 2022-10-15 15.40 2.3 cobbles
Vid 16 0.33 0.88 F002400 00:33:23 00:33:29 6 2022-10-15 15.40 0 cobbles
Vid 16 0.33 0.88 F002400 00:22:51 00:22:57 6 2022-10-15 15.40 1.8 cobbles
Vid 16 0.33 0.88 F002400 00:24:34 00:28:10 216 2022-10-15 15.40 2.1 cobbles
Vid 16 0.33 0.88 F002512 00:21:29 00:21:44 15 2022-10-15 13.40 2.7 cobbles
Vid 16 0.33 0.88 F002512 00:21:57 00:22:08 11 2022-10-15 13.40 3 cobbles
Vid 16 0.33 0.88 F002512 00:21:11 00:21:18 7 2022-10-15 13.40 3 cobbles
Vid 16 0.33 0.88 F002225 00:21:07 00:21:50 43 2022-10-15 17.60 0 cobbles
Vid 16 0.33 0.88 F002225 00:21:54 00:23:47 113 2022-10-15 17.60 3 cobbles
Vid 16 0.33 0.88 F004558 00:48:56 00:50:11 75 2022-10-15 15.60 0 cobbles
Vid 16 0.33 0.88 F004558 00:51:22 00:51:32 10 2022-10-15 15.60 3.4 cobbles
Vid 16 0.33 0.88 F004558 00:51:51 00:52:42 51 2022-10-15 15.60 3.1 cobbles
Vid 16 0.33 0.88 F004558 00:43:47 00:44:05 18 2022-10-15 15.60 0 cobbles
Vid 16 0.33 0.88 F004558 00:44:49 00:45:24 35 2022-10-15 15.60 2 cobbles
Vid 16 0.33 0.88 F004558 00:45:55 00:46:01 6 2022-10-15 15.60 0 cobbles
Vid 16 0.33 0.88 F005948 00:48:10 00:48:30 20 2022-10-15 16.00 0 cobbles
Vid 16 0.33 0.88 F005948 00:46:58 00:47:44 46 2022-10-15 16.00 1.5 cobbles
Vid 16 0.33 0.88 F005948 00:48:50 00:55:29 399 2022-10-15 16.00 0 cobbles
Vid 16 0.33 0.88 F005948 00:56:21 01:00:00 219 2022-10-15 16.00 0 cobbles
Vid 16 0.33 0.88 F002132 22:00:00 22:07:00 420 2022-10-15 14.20 3 cobbles
Vid 16 0.33 0.88 F002835 00:27:56 00:29:44 108 2022-10-15 18.80 3 cobbles
Vid 16 0.33 0.88 F002835 00:29:56 00:30:20 24 2022-10-15 18.80 3 cobbles
Vid 16 0.33 0.88 F002835 00:33:18 00:33:40 22 2022-10-15 18.80 3 cobbles
Vid 16 0.33 0.88 F002835 00:35:48 00:36:41 53 2022-10-15 18.80 3.1 cobbles
Vid 16 0.33 0.88 F002835 00:37:00 00:37:37 37 2022-10-15 18.80 3 cobbles
Vid 16 0.33 0.88 F002835 00:37:53 00:38:11 18 2022-10-15 18.80 0 cobbles
Vid 16 0.33 0.88 F002835 00:38:20 00:38:48 28 2022-10-15 18.80 3 cobbles
Vid 16 0.33 0.88 F002835 00:39:00 00:40:01 61 2022-10-15 18.80 3 cobbles
Vid 16 0.33 0.88 F004902 00:47:49 00:49:24 95 2022-10-15 15.80 2 cobbles
Vid 16 0.33 0.88 F004912 00:49:03 00:49:20 17 2022-10-15 17.20 2 cobbles
Vid 16 0.33 0.88 F004912 00:49:34 00:49:44 10 2022-10-15 17.20 2 cobbles
Vid 16 0.33 0.88 F004912 00:50:00 00:50:10 10 2022-10-15 17.20 2 cobbles
Vid 16 0.33 0.88 F004912 00:50:49 00:51:19 30 2022-10-15 17.20 2 cobbles
Vid 16 0.33 0.88 F004850 00:49:18 00:53:58 280 2022-10-15 16.00 0 cobbles
Vid 16 0.33 0.88 F005400 00:54:02 01:00:00 358 2022-10-15 16.00 0 cobbles
Vid 17 0.16 2.10 F002409 00:23:03 00:23:57 54 2022-10-15 11.40 15.4 boulders
Vid 17 0.16 2.10 F003613 00:36:00 00:36:30 30 2022-10-15 15.00 9.6 boulders
Vid 17 0.16 2.10 F004212 00:44:17 00:44:53 36 2022-10-15 17.40 13.5 boulders
Vid 17 0.16 2.10 F004212 00:45:00 00:47:44 164 2022-10-15 17.40 12.3 boulders
Vid 17 0.16 2.10 F005318 00:52:19 00:53:27 68 2022-10-15 17.40 15.4 boulders
Vid 17 0.16 2.10 F005318 00:53:37 00:53:41 4 2022-10-15 17.40 12.1 boulders
Vid 17 0.16 2.10 F004317 00:43:10 00:43:19 9 2022-10-15 11.60 10.7 boulders
Vid 17 0.16 2.10 F004317 00:46:52 00:47:05 13 2022-10-15 11.60 10.8 boulders
Vid 20 0.12 1.24 F003652 00:30:42 00:30:49 7 2022-10-17 16.30 0 boulders
Vid 20 0.12 1.24 F003652 00:31:19 00:31:24 5 2022-10-17 16.30 0 boulders
Vid 20 0.12 1.24 F003652 00:31:40 00:31:48 8 2022-10-17 16.30 0 boulders
Vid 20 0.12 1.24 F003652 00:33:47 00:33:55 8 2022-10-17 16.30 0 boulders
Vid 20 0.12 1.24 F003652 00:34:32 00:34:41 9 2022-10-17 16.30 0 boulders
Vid 20 0.12 1.24 F003652 00:35:10 00:35:18 8 2022-10-17 16.30 0 boulders
Vid 20 0.12 1.24 F003652 00:36:50 00:37:00 10 2022-10-17 16.30 0 boulders
Vid 20 0.12 1.24 F003652 00:37:41 00:37:47 6 2022-10-17 16.30 0 boulders
Vid 9 0.18 1.02 F001159 00:11:59 00:14:26 147 2022-09-09 5.90 0 cobbles
Vid 9 0.18 1.02 F001159 00:14:39 00:15:55 76 2022-09-09 5.90 1.7 cobbles
Vid 9 0.18 1.02 F001159 00:16:00 00:16:31 31 2022-09-09 5.90 0 cobbles
Vid 9 0.18 1.02 F001159 00:16:42 00:16:48 6 2022-09-09 5.90 0 cobbles
Vid 9 0.18 1.02 F001159 00:17:02 00:17:13 11 2022-09-09 5.90 0 cobbles
Vid 9 0.18 1.02 F001159 00:17:20 00:17:31 11 2022-09-09 5.90 0 cobbles
Vid 9 0.18 1.02 F001159 00:17:38 00:18:42 64 2022-09-09 5.90 1 cobbles
Vid 9 0.18 1.02 F001159 00:18:59 00:20:49 110 2022-09-09 5.90 2.8 cobbles
Vid 9 0.18 1.02 F001159 00:20:54 00:22:17 83 2022-09-09 5.90 1.1 cobbles
Vid 9 0.18 1.02 F001159 00:22:24 00:22:44 20 2022-09-09 5.90 1.2 cobbles
Vid 9 0.18 1.02 F001159 00:22:50 00:23:25 35 2022-09-09 5.90 1.3 cobbles
Vid 9 0.18 1.02 F001159 00:23:47 00:24:05 18 2022-09-09 5.90 0 cobbles
Vid 9 0.18 1.02 F001159 00:24:16 00:24:20 4 2022-09-09 5.90 0 cobbles
Vid 9 0.18 1.02 F001159 00:24:43 00:28:39 236 2022-09-09 5.90 0.8 cobbles
Vid 9 0.18 1.02 F001159 00:28:46 00:30:42 116 2022-09-09 5.90 0.5 cobbles
Vid 9 0.18 1.02 00:14:02 00:14:16 14 2022-09-09 18.60 9.9 cobbles
Vid 9 0.18 1.02 F001411 00:14:35 00:15:07 32 2022-09-09 18.60 25.7 boulders
Vid 9 0.18 1.02 F001411 00:15:24 00:15:46 22 2022-09-09 18.60 6.1 boulders
Vid 9 0.18 1.02 F001411 00:16:47 00:17:01 14 2022-09-09 18.60 10.3 boulders
Vid 9 0.18 1.02 F001411 00:19:57 00:21:08 71 2022-09-09 18.60 4.3 boulders
Vid 9 0.18 1.02 F001411 00:21:53 00:22:02 9 2022-09-09 18.60 29.4 boulders
Vid 9 0.18 1.02 F001711 00:17:03 00:17:29 26 2022-09-09 32.50 29.4 boulders
Vid 9 0.18 1.02 F001711 00:17:47 00:17:52 5 2022-09-09 32.50 30 boulders
Vid 9 0.18 1.02 F001711 00:18:25 00:18:56 31 2022-09-09 32.50 24.4 boulders
Vid 9 0.18 1.02 F001711 00:19:10 00:19:36 26 2022-09-09 32.50 38.2 boulders
Vid 9 0.18 1.02 F002600 00:26:00 00:26:03 3 2022-09-09 23.10 36.2 boulders
Vid 9 0.18 1.02 F002757 00:26:31 00:27:27 56 2022-09-09 27.00 29.5 boulders
Vid 9 0.18 1.02 F002757 00:25:26 00:25:33 7 2022-09-09 27.00 20.1 boulders
Vid 9 0.18 1.02 F002757 00:25:40 00:26:13 33 2022-09-09 27.00 23.4 boulders
Vid 9 0.18 1.02 F002658 00:26:58 00:27:01 3 2022-09-09 18.70 15.9 boulders
Vid 9 0.18 1.02 F002658 00:27:17 00:27:28 11 2022-09-09 18.70 22.6 boulders
Vid 9 0.18 1.02 F003127 00:31:25 00:31:36 11 2022-09-09 14.40 7.8 cobbles
Vid 9 0.18 1.02 F003127 00:31:38 00:31:43 5 2022-09-09 14.40 6.2 cobbles
Vid 9 0.18 1.02 F001641 00:16:38 00:16:43 5 2022-09-09 34.70 17.2 boulders
Vid 9 0.18 1.02 F001715 00:18:08 00:18:13 5 2022-09-09 14.80 14.8 boulders
Vid 9 0.18 1.02 F001718 00:17:29 00:17:39 10 2022-09-09 27.50 8.4 boulders
Vid 9 0.18 1.02 F002808 00:28:08 00:28:36 28 2022-09-09 21.00 24.9 boulders
Vid 9 0.18 1.02 F002808 00:28:47 00:28:54 7 2022-09-09 21.00 18 boulders
Vid 9 0.18 1.02 F002858 00:29:06 00:29:11 5 2022-09-09 31.60 10.5 cobbles
Vid 9 0.18 1.02 F002858 00:29:43 00:29:48 5 2022-09-09 31.60 20.5 bedrock
Vid 9 0.18 1.02 F002858 00:30:01 00:30:16 15 2022-09-09 31.60 17.9 boulders
Vid 9 0.18 1.02 F002858 00:30:25 00:30:28 3 2022-09-09 31.60 17.3 bedrock
Vid 9 0.18 1.02 F002858 00:30:41 00:30:46 5 2022-09-09 31.60 21.8 bedrock
Vid 9 0.18 1.02 F002858 00:31:00 00:31:04 4 2022-09-09 31.60 20.9 bedrock
Vid 9 0.18 1.02 F002858 00:31:42 00:31:46 4 2022-09-09 31.60 23.5 bedrock
Vid 9 0.18 1.02 F002858 00:31:53 00:31:57 4 2022-09-09 31.60 13.4 bedrock
Vid 9 0.18 1.02 F002858 00:32:04 00:32:11 7 2022-09-09 31.60 10.8 bedrock
Vid 9 0.18 1.02 F002858 00:32:21 00:32:30 9 2022-09-09 31.60 10.3 bedrock
Vid 9 0.18 1.02 F002858 00:32:58 00:33:02 4 2022-09-09 31.60 18.9 bedrock
Vid 9 0.18 1.02 F002858 00:33:21 00:33:26 5 2022-09-09 31.60 15.5 bedrock
Vid 9 0.18 1.02 F002858 00:34:00 00:34:21 21 2022-09-09 31.60 15.7 bedrock
Vid 9 0.18 1.02 F002858 00:34:25 00:34:32 7 2022-09-09 31.60 10.1 bedrock
Vid 9 0.18 1.02 F002858 00:34:45 00:35:00 15 2022-09-09 31.60 11.1 bedrock
Vid 9 0.18 1.02 F002858 00:35:21 00:35:27 6 2022-09-09 31.60 10.1 bedrock
Vid 9 0.18 1.02 F002858 00:35:47 00:35:54 7 2022-09-09 31.60 11 bedrock
Vid 9 0.18 1.02 F002858 00:36:26 00:36:40 14 2022-09-09 31.60 13 bedrock
Vid 9 0.18 1.02 F002858 00:37:20 00:37:26 6 2022-09-09 31.60 14.3 bedrock
Vid 9 0.18 1.02 F002858 00:38:00 00:38:09 9 2022-09-09 31.60 10.2 bedrock
Vid 9 0.18 1.02 F002858 00:38:25 00:38:36 11 2022-09-09 31.60 18.1 bedrock
Vid 9 0.18 1.02 F002858 00:38:58 00:39:07 9 2022-09-09 31.60 15.6 bedrock
Vid 9 0.18 1.02 F002858 00:39:22 00:39:26 4 2022-09-09 31.60 14.5 bedrock
Vid 9 0.18 1.02 F002858 00:39:38 00:40:20 42 2022-09-09 31.60 13 bedrock
Vid 9 0.18 1.02 F002858 00:40:28 00:40:45 17 2022-09-09 31.60 25.4 bedrock
Vid 9 0.18 1.02 F002858 00:40:55 00:41:16 21 2022-09-09 31.60 16.2 bedrock
Vid 9 0.18 1.02 F002858 00:41:37 00:41:52 15 2022-09-09 31.60 15.8 bedrock
Vid 9 0.18 1.02 F002858 00:44:00 00:44:10 10 2022-09-09 31.60 15.8 bedrock
Vid 9 0.18 1.02 F002858 00:44:25 00:44:49 24 2022-09-09 31.60 11 bedrock
Vid 9 0.18 1.02 F002858 00:45:00 00:45:47 47 2022-09-09 31.60 17.9 bedrock
Vid 9 0.18 1.02 F002858 00:46:20 00:46:33 13 2022-09-09 31.60 16.3 bedrock
Vid 9 0.18 1.02 F002858 00:47:29 00:47:35 6 2022-09-09 31.60 23.5 bedrock
Vid 9 0.18 1.02 F002858 00:47:39 00:48:04 25 2022-09-09 31.60 14.8 bedrock
Vid 9 0.18 1.02 F002858 00:48:52 00:49:06 14 2022-09-09 31.60 15.2 bedrock
Vid 9 0.18 1.02 F002858 00:50:00 00:50:10 10 2022-09-09 31.60 10.1 bedrock
Vid 9 0.18 1.02 F002858 00:50:40 00:50:50 10 2022-09-09 31.60 25.1 bedrock
Vid 9 0.18 1.02 F002858 00:52:02 00:52:16 14 2022-09-09 31.60 21.1 bedrock
Vid 9 0.18 1.02 F002858 00:52:20 00:52:24 4 2022-09-09 31.60 29.5 bedrock
Vid 9 0.18 1.02 F002858 00:52:49 00:53:00 11 2022-09-09 31.60 16.8 bedrock
Vid 9 0.18 1.02 F002858 00:53:25 00:53:36 11 2022-09-09 31.60 12.6 bedrock
Vid 9 0.18 1.02 F002858 00:54:40 00:54:57 17 2022-09-09 31.60 20.7 bedrock
Vid 9 0.18 1.02 F002858 00:55:00 00:55:07 7 2022-09-09 31.60 25.7 bedrock
Vid 9 0.18 1.02 F002858 00:55:18 00:55:24 6 2022-09-09 31.60 18.1 bedrock
Vid 9 0.18 1.02 F002858 00:55:43 00:56:03 20 2022-09-09 31.60 17.9 bedrock
Vid 9 0.18 1.02 F002858 00:56:22 00:56:32 10 2022-09-09 31.60 16.9 bedrock
Vid 9 0.18 1.02 F002858 00:57:10 00:57:17 7 2022-09-09 31.60 18.4 bedrock
Vid 9 0.18 1.02 F002858 00:57:32 00:57:41 9 2022-09-09 31.60 18.9 bedrock
Vid 9 0.18 1.02 F002858 00:58:10 00:58:18 8 2022-09-09 31.60 15.6 bedrock
Vid 10 0.44 0.62 F003754 00:37:52 00:37:56 4 2022-09-09 21.50 5 cobbles
Vid 10 0.44 0.62 F004128 00:41:28 00:41:31 3 2022-09-09 27.40 5.2 cobbles
Vid 10 0.44 0.62 F005832 00:58:30 00:59:09 39 2022-09-09 15.10 4 cobbles
Vid 12 0.43 0.62 F002621 00:26:01 00:26:31 30 2022-09-09 16.90 3.9 cobbles
Vid 12 0.43 0.62 F003215 00:32:15 00:32:22 7 2022-09-09 12.80 6.3 boulders
Vid 12 0.43 0.62 F005125 00:51:45 00:53:22 97 2022-09-09 12.30 4.3 cobbles
Vid 12 0.43 0.62 F005338 00:53:15 00:56:17 182 2022-09-09 11.60 8.1 boulders
Vid 13 0.59 0.77 F000730 00:07:40 00:07:43 3 2022-10-14 16.50 0 boulders
Vid 13 0.59 0.77 F002653 02:44:00 02:54:00 10 2022-10-14 17.90 3 boulders
Vid 13 0.59 0.77 F002653 12:12:00 12:40:00 28 2022-10-14 17.90 4.7 boulders
Vid 15 0.57 0.90 F001308 00:13:08 00:13:19 11 2022-10-14 30.50 0 cobbles
Vid 15 0.57 0.90 F001042 00:08:28 00:12:08 220 2022-10-14 26.60 0 cobbles
Vid 15 0.57 0.90 F001042 00:13:04 00:13:15 11 2022-10-14 26.60 0 cobbles
Vid 15 0.57 0.90 F001042 00:13:20 00:13:54 34 2022-10-14 26.60 0 cobbles
Vid 15 0.57 0.90 F001042 00:22:06 00:25:32 206 2022-10-14 26.60 0 cobbles
Vid 15 0.57 0.90 F001226 00:12:05 00:12:29 24 2022-10-14 21.50 0 cobbles
Vid 15 0.57 0.90 F001226 00:13:01 00:25:10 729 2022-10-14 21.50 0 cobbles
Vid 15 0.57 0.90 F002344 00:23:36 00:39:44 968 2022-10-14 13.60 0 boulders
Vid 15 0.57 0.90 F002216 00:20:15 00:20:25 10 2022-10-14 14.50 4 cobbles
Vid 15 0.57 0.90 F002216 00:20:41 00:20:45 4 2022-10-14 14.50 0 cobbles
Vid 15 0.57 0.90 F003716 00:37:14 00:41:10 236 2022-10-14 21.10 0 cobbles
Vid 15 0.57 0.90 F005101 00:51:00 00:53:30 150 2022-10-14 13.20 2.5 boulders
Vid 15 0.57 0.90 F005229 00:52:26 00:54:00 94 2022-10-14 20.50 3.6 cobbles