Bad River
General data
- Water type: River
- Progression: Missouri River -> Mississippi River -> Gulf of Mexico -> Atlantic Ocean -> Planet Earth
- Climates: Continental
- Continents: North America
- Countries: United States of America
The Bad River (Lakota: wakpá-šiča; ’river-bad’) is a tributary of the Missouri River, approximately 161 miles (259 km) long, in central South Dakota in the United States. Bad River offers opportunities for various outdoor activities, including fishing, camping, canoeing and kayaking, hiking, and birdwatching. Many people visit this river for outdoor activities and recreation in nature. Fishing Bad River is home to many fish species, including trout, bass, pike, whitefish, and other species. These fish can be found in different parts of the river, from fast-flowing currents to calm sections. Fishing can be successful throughout the year, but the best seasons are usually spring and summer when water temperatures are favorable, and fish are most active. Fall can also be a good season for fishing, especially for some species preparing for winter.
The more catches you post, the higher your chances of winning this amazing prize.
Every catch shared between May and November 2025 is automatically entered into the prize draw.
Only one rule: Make sure to tag both the fish species and the body of water!
| 1 x Application (75.73%) | 71.23ms |
| 1 x Booting (24.26%) | 22.81ms |
select * from `sessions` where `id` = 'xuP3AmpH6KN8vdYcmjfKEB5NXkoKlLzAzSSbU6Ed' limit 1| Bindings |
|
| Backtrace |
|
select * from `waters` where `type` = 'River' and `alias` = 'bad-river' and `published` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (1873) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`parent_id` in (1873)| Backtrace |
|
select `countries`.*, `country_water`.`water_id` as `pivot_water_id`, `country_water`.`country_id` as `pivot_country_id` from `countries` inner join `country_water` on `countries`.`id` = `country_water`.`country_id` where `country_water`.`water_id` in (1873)| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (238) and `translations`.`translatable_type` = 'App\\Models\\Country'| Bindings |
|
| Backtrace |
|
select `continents`.*, `continent_country`.`country_id` as `pivot_country_id`, `continent_country`.`continent_id` as `pivot_continent_id` from `continents` inner join `continent_country` on `continents`.`id` = `continent_country`.`continent_id` where `continent_country`.`country_id` in (238)| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (4) and `translations`.`translatable_type` = 'App\\Models\\Continent'| Bindings |
|
| Backtrace |
|
select `fish`.*, `water_fish`.`water_id` as `pivot_water_id`, `water_fish`.`fish_id` as `pivot_fish_id` from `fish` inner join `water_fish` on `fish`.`id` = `water_fish`.`fish_id` where `water_fish`.`water_id` in (1873)| Backtrace |
|
with recursive `laravel_cte` as ((select `waters`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `waters` where `waters`.`id` = 428) union all (select `waters`.*, `depth` - 1 as `depth`, concat(`path`, '.', `waters`.`id`) from `waters` inner join `laravel_cte` on `laravel_cte`.`parent_id` = `waters`.`id`)) select * from `laravel_cte`| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (39, 41, 426, 427, 428) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select `climates`.*, `climate_water`.`water_id` as `pivot_water_id`, `climate_water`.`climate_id` as `pivot_climate_id` from `climates` inner join `climate_water` on `climates`.`id` = `climate_water`.`climate_id` where `climate_water`.`water_id` = 1873| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 4 and `translations`.`translatable_id` is not null and `lang` = 'en' limit 1| Bindings |
|
| Backtrace |
|
select `continents`.*, `continent_water`.`water_id` as `pivot_water_id`, `continent_water`.`continent_id` as `pivot_continent_id` from `continents` inner join `continent_water` on `continents`.`id` = `continent_water`.`continent_id` where `continent_water`.`water_id` = 1873| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (4) and `translations`.`translatable_type` = 'App\\Models\\Continent'| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `tags` where `tags`.`context_id` = 1873 and `tags`.`context_id` is not null and `type` = 'water'| Bindings |
|
| Backtrace |
|
select * from `tags` where `tags`.`context_id` = 1873 and `tags`.`context_id` is not null and `type` = 'water' order by `created_at` desc limit 100| Bindings |
|
| Backtrace |
|
select * from `sessions` where `id` = 'xuP3AmpH6KN8vdYcmjfKEB5NXkoKlLzAzSSbU6Ed' limit 1| Bindings |
|
| Backtrace |
|
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiWFliVWhZbXRuVmZEZlQyUkNaSWRlbDdCMTJIejdwUkFMR2dENWtNZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vd2F0ZXJzL3JpdmVyL2JhZC1yaXZlciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1747949295, null, '172.18.0.5', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'xuP3AmpH6KN8vdYcmjfKEB5NXkoKlLzAzSSbU6Ed')| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:35 [▼ "x-real-ip" => array:1 [▶ 0 => "172.70.179.80" ] "x-forwarded-server" => array:1 [▶ 0 => "traefik" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-forwarded-host" => array:1 [▶ 0 => "dev.tagmyfish.com" ] "x-forwarded-for" => array:1 [▶ 0 => "172.70.179.80" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "cf-timezone" => array:1 [▶ 0 => "America/New_York" ] "cf-region-code" => array:1 [▶ 0 => "OH" ] "cf-region" => array:1 [▶ 0 => "Ohio" ] "cf-ray" => array:1 [▶ 0 => "943f66f84aaf6386-ORD" ] "cf-postal-code" => array:1 [▶ 0 => "43215" ] "cf-metro-code" => array:1 [▶ 0 => "535" ] "cf-iplongitude" => array:1 [▶ 0 => "-83.00610" ] "cf-iplatitude" => array:1 [▶ 0 => "39.96250" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "cf-ipcontinent" => array:1 [▶ 0 => "NA" ] "cf-ipcity" => array:1 [▶ 0 => "Columbus" ] "cf-connecting-ip" => array:1 [▶ 0 => "18.216.220.105" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "host" => array:1 [▶ 0 => "dev.tagmyfish.com" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 22 May 2025 21:28:15 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjB0L253UjVEK2U5VzJkeXJFcWxvZUE9PSIsInZhbHVlIjoiL0orK0FMdjJjK1dBRTNUVnZsRnl5bFZTTFVrVlRqZDU0eGZwWkdXZTc1RlFjdGdSTjlkTTRVRXE2aVRjN3dTb1hhbEh1c09QaGJwRldHYnlXTUdFcndxZStJdmlpOWRWeElxZ3VxNmw3eEtBRndWSi9UQUo5REdwKzhOeHlybnoiLCJtYWMiOiJjNDJhYzVmNDc5NTgxMGYzMjk3MDBkNzcwNTY3YzdiN2I0NzcxZDhjMWNkOGRkNGNmZGZmMzkyYTc1MTZjMDBmIiwidGFnIjoiIn0%3D; expires=Thu, 22 May 2025 23:28:15 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjB0L253UjVEK2U5VzJkeXJFcWxvZUE9PSIsInZhbHVlIjoiL0orK0FMdjJjK1dBRTNUVnZsRnl5bFZTTFVrVlRqZDU0eGZwWkdXZTc1RlFjdGdSTjlkTTRVRXE2aVRjN3dTb1hhbEh1c ▶" 1 => "tagmyfish_session=eyJpdiI6ImwxK1hiTld6bmZUK1NEVDlzQldVSVE9PSIsInZhbHVlIjoiYlBRTUo3NExRaFVLNlZSQVZ3SFJPUUJDbXR0cmp6SDhiM3pTdUpyUDJkRXducjZrSzRvTGpYanJzZDJPcU9rQ2FGS1QxR2Y5OHVrZjNzOWQrVTR0NldDeExXeU1wMTNaSXZiNURCelVqdFNjRHpSK0xqOVlNS3VuRXJMOVdaTUUiLCJtYWMiOiJhOTFhYjFjOGFlN2MzZjRkMzY3NmYzMzU2MDlmNWRiZjk2Y2MzZGNkNjZiZWM4ZmFiNzI3MjRjZWQ0YmQ3Y2U2IiwidGFnIjoiIn0%3D; expires=Thu, 22 May 2025 23:28:15 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6ImwxK1hiTld6bmZUK1NEVDlzQldVSVE9PSIsInZhbHVlIjoiYlBRTUo3NExRaFVLNlZSQVZ3SFJPUUJDbXR0cmp6SDhiM3pTdUpyUDJkRXducjZrSzRvTGpYanJzZDJPcU9rQ2 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjB0L253UjVEK2U5VzJkeXJFcWxvZUE9PSIsInZhbHVlIjoiL0orK0FMdjJjK1dBRTNUVnZsRnl5bFZTTFVrVlRqZDU0eGZwWkdXZTc1RlFjdGdSTjlkTTRVRXE2aVRjN3dTb1hhbEh1c09QaGJwRldHYnlXTUdFcndxZStJdmlpOWRWeElxZ3VxNmw3eEtBRndWSi9UQUo5REdwKzhOeHlybnoiLCJtYWMiOiJjNDJhYzVmNDc5NTgxMGYzMjk3MDBkNzcwNTY3YzdiN2I0NzcxZDhjMWNkOGRkNGNmZGZmMzkyYTc1MTZjMDBmIiwidGFnIjoiIn0%3D; expires=Thu, 22-May-2025 23:28:15 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjB0L253UjVEK2U5VzJkeXJFcWxvZUE9PSIsInZhbHVlIjoiL0orK0FMdjJjK1dBRTNUVnZsRnl5bFZTTFVrVlRqZDU0eGZwWkdXZTc1RlFjdGdSTjlkTTRVRXE2aVRjN3dTb1hhbEh1c ▶" 1 => "tagmyfish_session=eyJpdiI6ImwxK1hiTld6bmZUK1NEVDlzQldVSVE9PSIsInZhbHVlIjoiYlBRTUo3NExRaFVLNlZSQVZ3SFJPUUJDbXR0cmp6SDhiM3pTdUpyUDJkRXducjZrSzRvTGpYanJzZDJPcU9rQ2FGS1QxR2Y5OHVrZjNzOWQrVTR0NldDeExXeU1wMTNaSXZiNURCelVqdFNjRHpSK0xqOVlNS3VuRXJMOVdaTUUiLCJtYWMiOiJhOTFhYjFjOGFlN2MzZjRkMzY3NmYzMzU2MDlmNWRiZjk2Y2MzZGNkNjZiZWM4ZmFiNzI3MjRjZWQ0YmQ3Y2U2IiwidGFnIjoiIn0%3D; expires=Thu, 22-May-2025 23:28:15 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6ImwxK1hiTld6bmZUK1NEVDlzQldVSVE9PSIsInZhbHVlIjoiYlBRTUo3NExRaFVLNlZSQVZ3SFJPUUJDbXR0cmp6SDhiM3pTdUpyUDJkRXducjZrSzRvTGpYanJzZDJPcU9rQ2 ▶" ] ]
0 of 0array:3 [▼ "_token" => "XYbUhYmtnVfDfT2RCZIdel7B12Hz7pRALGgD5kMd" "_previous" => array:1 [▶ "url" => "https://dev.tagmyfish.com/waters/river/bad-river" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
