The Roaring River is a 16.6-mile (26.7 km) long tributary of the South Fork Kings River, in the Sierra Nevada of Fresno County, California. The entire course of the river is within Kings Canyon National Park. The river originates in the Great Western Divide at Triple Divide Peak, and flows northward through Cloud Canyon before turning northwest, entering Sugarloaf Valley, where it receives Sugarloaf Creek from the west. From there it flows north through a deep and inaccessible gorge, forming the Roaring River Falls near its confluence with the South Fork in Cedar Grove. The Roaring River supports populations of native cutthroat trout, late-run coho salmon, and late-run winter steelhead. All three of these populations are considered to be native to the river.
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 (76.99%) | 82.28ms |
| 1 x Booting (23%) | 24.58ms |
select * from `sessions` where `id` = 'tBQUOABuVIAjmDBT5MgGiWnV3P1O0LXyNiIuwAGw' limit 1| Bindings |
|
| Backtrace |
|
select * from `waters` where `type` = 'River' and `alias` = 'roaring-river-california' and `published` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (1974) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`parent_id` in (1974)| 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 (1974)| 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 (1974)| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (146, 451, 454)| Bindings |
|
| Backtrace |
|
with recursive `laravel_cte` as ((select `fish`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `fish` where `fish`.`id` in (63)) union all (select `fish`.*, `depth` - 1 as `depth`, concat(`path`, '.', `fish`.`id`) from `fish` inner join `laravel_cte` on `laravel_cte`.`parent_id` = `fish`.`id`)) select * from `laravel_cte`| Bindings |
|
| Backtrace |
|
select * from `fish_names` where `locale` = 'en' and `main` = 1 and `fish_names`.`fish_id` in (58, 59, 63, 906, 908)| Bindings |
|
| Backtrace |
|
with recursive `laravel_cte` as ((select `waters`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `waters` where `waters`.`id` = 1965) 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, 375, 717, 1964, 1965, 4072, 4073, 4074, 4075, 4076) 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` = 1974| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 8 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` = 1974| 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` = 1974 and `tags`.`context_id` is not null and `type` = 'water'| Bindings |
|
| Backtrace |
|
select * from `tags` where `tags`.`context_id` = 1974 and `tags`.`context_id` is not null and `type` = 'water' order by `created_at` desc limit 100| Bindings |
|
| Backtrace |
|
select * from `sessions` where `id` = 'tBQUOABuVIAjmDBT5MgGiWnV3P1O0LXyNiIuwAGw' limit 1| Bindings |
|
| Backtrace |
|
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoieW5ldjU3Z0pEVGtzR1daaVZlMDNuNWdHT0ZxSXBwUm9jRGdhYVEwcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjM6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vd2F0ZXJzL3JpdmVyL3JvYXJpbmctcml2ZXItY2FsaWZvcm5pYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1747218716, null, '172.18.0.5', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'tBQUOABuVIAjmDBT5MgGiWnV3P1O0LXyNiIuwAGw')| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:35 [▼ "x-real-ip" => array:1 [▶ 0 => "172.69.6.16" ] "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.69.6.16" ] "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 => "93f9ba8e2f8f5769-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 => "3.14.83.200" ] "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 => "Wed, 14 May 2025 10:31:55 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InJCSlE4RFhVZEJlYXZZaExZam9vM2c9PSIsInZhbHVlIjoibWFvT000QVg2QmptaytwaWd3enNuYTdUM21wUTBqd09xOHdUcTIzcWM3UDdHSkV5SG1VbW0vMTA1OEhQaGZSKzhiR2IwTE9Bd3Z2cWlrVDQzNjljSEk5b2JreGdkakJjSnUySVFVdUZXeDcreUZyTGhYR2VwUCsxVHp2SXprOHkiLCJtYWMiOiIyYmJkYmIxNzk1MmRlZTVmNDRhYzMwMzI3YmUzNzc4ZGZjNmVkMmRjYTFjMmM2NzNiYTE4N2IwZWM4Mjg2MTg4IiwidGFnIjoiIn0%3D; expires=Wed, 14 May 2025 12:31:56 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJCSlE4RFhVZEJlYXZZaExZam9vM2c9PSIsInZhbHVlIjoibWFvT000QVg2QmptaytwaWd3enNuYTdUM21wUTBqd09xOHdUcTIzcWM3UDdHSkV5SG1VbW0vMTA1OEhQaGZSKzhiR2IwT ▶" 1 => "tagmyfish_session=eyJpdiI6IjBHYm1kOFpTUEs4V2JVdzMyanFza3c9PSIsInZhbHVlIjoiSnBFMWhQM3lWdU5PMzh3R2JNcUdsT0hsMmxnempQZHV4NTgyazZwcVlzQkkzUjg2NFQ4bGZ6V1ZPQ1FmTVNZMnMxSjFocDlGSmxScU5BK2xMeGZLUDExejNtZGxGdW01eks0MXdzSHpQTnVXV25KTWM1Sml3eFNuN2dSNjh5VloiLCJtYWMiOiI2ODA4MTJmOTY2Y2FkZGI4MDQ4NTQ1MGE3MDYyMTE2ZTI4ZGNhN2RkZGFjZGU2OGYxMjk0ZmM2NmMyYmVlMTlmIiwidGFnIjoiIn0%3D; expires=Wed, 14 May 2025 12:31:56 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6IjBHYm1kOFpTUEs4V2JVdzMyanFza3c9PSIsInZhbHVlIjoiSnBFMWhQM3lWdU5PMzh3R2JNcUdsT0hsMmxnempQZHV4NTgyazZwcVlzQkkzUjg2NFQ4bGZ6V1ZPQ1FmTVNZMn ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InJCSlE4RFhVZEJlYXZZaExZam9vM2c9PSIsInZhbHVlIjoibWFvT000QVg2QmptaytwaWd3enNuYTdUM21wUTBqd09xOHdUcTIzcWM3UDdHSkV5SG1VbW0vMTA1OEhQaGZSKzhiR2IwTE9Bd3Z2cWlrVDQzNjljSEk5b2JreGdkakJjSnUySVFVdUZXeDcreUZyTGhYR2VwUCsxVHp2SXprOHkiLCJtYWMiOiIyYmJkYmIxNzk1MmRlZTVmNDRhYzMwMzI3YmUzNzc4ZGZjNmVkMmRjYTFjMmM2NzNiYTE4N2IwZWM4Mjg2MTg4IiwidGFnIjoiIn0%3D; expires=Wed, 14-May-2025 12:31:56 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InJCSlE4RFhVZEJlYXZZaExZam9vM2c9PSIsInZhbHVlIjoibWFvT000QVg2QmptaytwaWd3enNuYTdUM21wUTBqd09xOHdUcTIzcWM3UDdHSkV5SG1VbW0vMTA1OEhQaGZSKzhiR2IwT ▶" 1 => "tagmyfish_session=eyJpdiI6IjBHYm1kOFpTUEs4V2JVdzMyanFza3c9PSIsInZhbHVlIjoiSnBFMWhQM3lWdU5PMzh3R2JNcUdsT0hsMmxnempQZHV4NTgyazZwcVlzQkkzUjg2NFQ4bGZ6V1ZPQ1FmTVNZMnMxSjFocDlGSmxScU5BK2xMeGZLUDExejNtZGxGdW01eks0MXdzSHpQTnVXV25KTWM1Sml3eFNuN2dSNjh5VloiLCJtYWMiOiI2ODA4MTJmOTY2Y2FkZGI4MDQ4NTQ1MGE3MDYyMTE2ZTI4ZGNhN2RkZGFjZGU2OGYxMjk0ZmM2NmMyYmVlMTlmIiwidGFnIjoiIn0%3D; expires=Wed, 14-May-2025 12:31:56 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6IjBHYm1kOFpTUEs4V2JVdzMyanFza3c9PSIsInZhbHVlIjoiSnBFMWhQM3lWdU5PMzh3R2JNcUdsT0hsMmxnempQZHV4NTgyazZwcVlzQkkzUjg2NFQ4bGZ6V1ZPQ1FmTVNZMn ▶" ] ]
0 of 0array:3 [▼ "_token" => "ynev57gJDTksGWZiVe03n5gGOFqIppRocDgaaQ0q" "_previous" => array:1 [▶ "url" => "https://dev.tagmyfish.com/waters/river/roaring-river-california" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
