Lewiston Lake
General data
- Water type: Artificial lake
- Progression: Trinity River (California) -> Klamath River -> Pacific Ocean -> Planet Earth
- Climates: Temperate
- Continents: North America
- Countries: United States of America
Lewiston Lake is a reservoir impounded by Lewiston Dam on the Trinity River, in Trinity County, California. Lewiston Lake is near the towns of Weaverville and Lewiston in Trinity County, California. It is in the canyon between the Trinity Mountains and Marble Mountains of the southern Klamath Mountains System. It is used for transbasin diversion to the Sacramento River and flood control, as well as for hydroelectric generation. Lewiston reservoir is within the Trinity Unit of the Whiskeytown-Shasta-Trinity National Recreation Area, in the Shasta-Trinity National Forest. It is a popular destination for fishing, kayaking, and camping.
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.6%) | 75.54ms |
| 1 x Booting (24.39%) | 24.37ms |
select * from `sessions` where `id` = 'xJwlzGREOmozrE0UbQcj19VjmfRNYNvpw1hrb6mB' limit 1| Bindings |
|
| Backtrace |
|
select * from `waters` where `type` = 'Artificial lake' and `alias` = 'lewiston-lake' and `published` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (3845) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`parent_id` in (3845)| 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 (3845)| 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 (3845)| Backtrace |
|
with recursive `laravel_cte` as ((select `waters`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `waters` where `waters`.`id` = 712) 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, 711, 712) 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` = 3845| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 3 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` = 3845| 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` = 3845 and `tags`.`context_id` is not null and `type` = 'water'| Bindings |
|
| Backtrace |
|
select * from `tags` where `tags`.`context_id` = 3845 and `tags`.`context_id` is not null and `type` = 'water' order by `created_at` desc limit 100| Bindings |
|
| Backtrace |
|
select * from `sessions` where `id` = 'xJwlzGREOmozrE0UbQcj19VjmfRNYNvpw1hrb6mB' limit 1| Bindings |
|
| Backtrace |
|
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiNGlOeUN3d2NiUENHOFkzQnBKUVVTR3FlZDJ4VVNhNXNpVWhMWWFiRCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjI6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vd2F0ZXJzL2FydGlmaWNpYWwtbGFrZS9sZXdpc3Rvbi1sYWtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1747688336, null, '172.18.0.5', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'xJwlzGREOmozrE0UbQcj19VjmfRNYNvpw1hrb6mB')| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:35 [▼ "x-real-ip" => array:1 [▶ 0 => "172.70.131.131" ] "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.131.131" ] "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 => "942683e8cfb086ea-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.17.135.107" ] "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 => "Mon, 19 May 2025 20:58:56 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImRycnV6QkMzTDJYejVSY0RTdzRaM3c9PSIsInZhbHVlIjoiTEVrOEpwdCtnZkRRaWozZXFsL3I0TDBQM29JTXpQNmdaQXAzTUd4b1lmQUlDOGIvZXMxYzRSSmNZeGpBK2VhZ3BoSW9kbXYvUVk4eXR5YTVDbUdEOW5sZ0dUenM4d1RwWXRCUnozNkJlT2pVajR0M2Q1cGZwbDZwRUNRb1IyYkkiLCJtYWMiOiI0ZTVkMWRjOTI4MjViODZiZWI1OTU0YTI3NTA1MmM4ZDkwYzZkMmI5MDg0MTg5NTBlNGNiODNjOGJkN2U3Zjg5IiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 22:58:56 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImRycnV6QkMzTDJYejVSY0RTdzRaM3c9PSIsInZhbHVlIjoiTEVrOEpwdCtnZkRRaWozZXFsL3I0TDBQM29JTXpQNmdaQXAzTUd4b1lmQUlDOGIvZXMxYzRSSmNZeGpBK2VhZ3BoSW9kb ▶" 1 => "tagmyfish_session=eyJpdiI6ImV0bVlzTXJkd3R0TEoxYytwUzRIVXc9PSIsInZhbHVlIjoiU25vMUdBZ0NNZG9WekJPOHVFZnJTRXJBNDlkbEFBUUg4Sm02Y0NxaTZQR0k4NEtFVk8rUnJZZndWRWtPei84S09ZV0F1WEVmMkxFNlR1b1ZKUjdiQ1lwamMrZC9GbUt1NkcxNnFnYjRMMjR5UFNCbFBMUXFORU9KMFAxeUJPNDIiLCJtYWMiOiJlNDFlNTM5OWE0NTQ4NWQxYTMwOTMzZWNmZTY1ZjlmZmE2NWIzOTFjOTIwNDIzYzY2ZWY4MzFiYjBmNGNjYjJhIiwidGFnIjoiIn0%3D; expires=Mon, 19 May 2025 22:58:56 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6ImV0bVlzTXJkd3R0TEoxYytwUzRIVXc9PSIsInZhbHVlIjoiU25vMUdBZ0NNZG9WekJPOHVFZnJTRXJBNDlkbEFBUUg4Sm02Y0NxaTZQR0k4NEtFVk8rUnJZZndWRWtPei84S0 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImRycnV6QkMzTDJYejVSY0RTdzRaM3c9PSIsInZhbHVlIjoiTEVrOEpwdCtnZkRRaWozZXFsL3I0TDBQM29JTXpQNmdaQXAzTUd4b1lmQUlDOGIvZXMxYzRSSmNZeGpBK2VhZ3BoSW9kbXYvUVk4eXR5YTVDbUdEOW5sZ0dUenM4d1RwWXRCUnozNkJlT2pVajR0M2Q1cGZwbDZwRUNRb1IyYkkiLCJtYWMiOiI0ZTVkMWRjOTI4MjViODZiZWI1OTU0YTI3NTA1MmM4ZDkwYzZkMmI5MDg0MTg5NTBlNGNiODNjOGJkN2U3Zjg5IiwidGFnIjoiIn0%3D; expires=Mon, 19-May-2025 22:58:56 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImRycnV6QkMzTDJYejVSY0RTdzRaM3c9PSIsInZhbHVlIjoiTEVrOEpwdCtnZkRRaWozZXFsL3I0TDBQM29JTXpQNmdaQXAzTUd4b1lmQUlDOGIvZXMxYzRSSmNZeGpBK2VhZ3BoSW9kb ▶" 1 => "tagmyfish_session=eyJpdiI6ImV0bVlzTXJkd3R0TEoxYytwUzRIVXc9PSIsInZhbHVlIjoiU25vMUdBZ0NNZG9WekJPOHVFZnJTRXJBNDlkbEFBUUg4Sm02Y0NxaTZQR0k4NEtFVk8rUnJZZndWRWtPei84S09ZV0F1WEVmMkxFNlR1b1ZKUjdiQ1lwamMrZC9GbUt1NkcxNnFnYjRMMjR5UFNCbFBMUXFORU9KMFAxeUJPNDIiLCJtYWMiOiJlNDFlNTM5OWE0NTQ4NWQxYTMwOTMzZWNmZTY1ZjlmZmE2NWIzOTFjOTIwNDIzYzY2ZWY4MzFiYjBmNGNjYjJhIiwidGFnIjoiIn0%3D; expires=Mon, 19-May-2025 22:58:56 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6ImV0bVlzTXJkd3R0TEoxYytwUzRIVXc9PSIsInZhbHVlIjoiU25vMUdBZ0NNZG9WekJPOHVFZnJTRXJBNDlkbEFBUUg4Sm02Y0NxaTZQR0k4NEtFVk8rUnJZZndWRWtPei84S0 ▶" ] ]
0 of 0array:3 [▼ "_token" => "4iNyCwwcbPCG8Y3BpJQUSGqed2xUSa5siUhLYabD" "_previous" => array:1 [▶ "url" => "https://dev.tagmyfish.com/waters/artificial-lake/lewiston-lake" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
