John Day River
General data
- Water type: River
- Progression: Columbia River -> Columbia River Estuary -> Pacific Ocean -> Planet Earth
- Climates: Subtropical
- Continents: North America
- Countries: United States of America
The John Day River is a tributary of the Columbia River, approximately 284 miles (457 km) long, in northeastern Oregon in the United States. It is known as the Mah-Hah River by the Cayuse people. Undammed along its entire length, the river is the fourth longest free-flowing river in the contiguous United States. There is extensive use of its waters for irrigation. Its course furnishes habitat for diverse species, including wild steelhead and Chinook salmon runs. However, the steelhead populations are under federal Endangered Species Act (ESA) protections, and the Chinook salmon have been proposed for such protection. The river was named for John Day, a member of the Pacific Fur Company’s overland expedition to the mouth of the Columbia River that left Missouri in 1810. Day struggled through eastern Oregon during the winter of 1811–12. While descending the Columbia River in April 1812, he and Ramsay Crooks were robbed and stripped naked by Native Americans at the mouth of the river that now bears his name, forcing them to hike 80 miles (130 km) back to friendly Umatilla Indians under extreme conditions. The absence of dams on the river causes its flow to greatly fluctuate throughout the year depending on snowpack and rainfall within the watershed.[8] The highest flow recorded at a gauge on the lower John Day was 43,300 cubic feet per second (1,230 m3/s) on January 2, 1997. The lowest flow was no flow at all, which occurred on September 2, 1966; from August 15 to September 16, 1973; and on nine days in August 1977. The average flow at the gauge is 2,075 cubic feet per second (58.8 m3/s).
| 1 x Application (79.16%) | 79.89ms |
| 1 x Booting (20.83%) | 21.02ms |
select * from `sessions` where `id` = 'arUvZHKLCfWD4jCMzdtDsFLJk4QN9F3uM503jkwZ' limit 1| Bindings |
|
| Backtrace |
|
select * from `waters` where `type` = 'River' and `alias` = 'john-day-river' and `published` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `translations` where `lang` = 'en' and `translations`.`translatable_id` in (2028) and `translations`.`translatable_type` = 'App\\Models\\Water'| Bindings |
|
| Backtrace |
|
select * from `waters` where `waters`.`parent_id` in (2028)| 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 (2028)| 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 (2028)| Backtrace |
|
with recursive `laravel_cte` as ((select `waters`.*, -1 as `depth`, cast(`id` as char(65535)) as `path` from `waters` where `waters`.`id` = 460) 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, 460, 4082) 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` = 2028| Bindings |
|
| Backtrace |
|
select * from `translations` where `translations`.`translatable_type` = 'App\\Models\\Climate' and `translations`.`translatable_id` = 2 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` = 2028| 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` = 2028 and `tags`.`context_id` is not null and `type` = 'water'| Bindings |
|
| Backtrace |
|
select * from `tags` where `tags`.`context_id` = 2028 and `tags`.`context_id` is not null and `type` = 'water' order by `created_at` desc limit 20| Bindings |
|
| Backtrace |
|
select * from `sessions` where `id` = 'arUvZHKLCfWD4jCMzdtDsFLJk4QN9F3uM503jkwZ' limit 1| Bindings |
|
| Backtrace |
|
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiRGxwOUo4VFVLY29ySUhUMTYxalNHeEFTNEM3NjZiMVJqMkhpRnR3cyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTM6Imh0dHBzOi8vZGV2LnRhZ215ZmlzaC5jb20vd2F0ZXJzL3JpdmVyL2pvaG4tZGF5LXJpdmVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1746446585, null, '172.18.0.2', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'arUvZHKLCfWD4jCMzdtDsFLJk4QN9F3uM503jkwZ')| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:30 [▼ "x-real-ip" => array:1 [▶ 0 => "172.70.126.113" ] "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.126.113" ] "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/Chicago" ] "cf-ray" => array:1 [▶ 0 => "93b017b7a8127fb0-ORD" ] "cf-iplongitude" => array:1 [▶ 0 => "-97.82200" ] "cf-iplatitude" => array:1 [▶ 0 => "37.75100" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "cf-ipcontinent" => array:1 [▶ 0 => "NA" ] "cf-connecting-ip" => array:1 [▶ 0 => "3.141.4.8" ] "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, 05 May 2025 12:03:05 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImNOWTdkVlRyNEUxODhzV3U5RG5oeXc9PSIsInZhbHVlIjoid1JhMFNEUTl1dUlheE1WWXZTV1NlVVhrVXJxR1Z6aVZlUHkwZnluNHhQT1d3NUJod1NmcU1WZTVMdW8zcDgwYXRZWFBIOTN1c3ZJNENEWFhQOU12UmtPODU5aGtXZytnNkFkbW9MWncweEJCQThqek5sbEhqUkJzUHpmcW4xOWwiLCJtYWMiOiJkNmNkNDU4YTQ0OWVhZGEzMjczYzIyNGExMjYwYWVlMDBjMWFhNjMxYTY5NGE3YmU0ZTQyMTNlODM0ODBlMGUyIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 14:03:05 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImNOWTdkVlRyNEUxODhzV3U5RG5oeXc9PSIsInZhbHVlIjoid1JhMFNEUTl1dUlheE1WWXZTV1NlVVhrVXJxR1Z6aVZlUHkwZnluNHhQT1d3NUJod1NmcU1WZTVMdW8zcDgwYXRZWFBIO ▶" 1 => "tagmyfish_session=eyJpdiI6IjZmQm5RamE4R21yRlZiS3RQQVZnVmc9PSIsInZhbHVlIjoiVERZN2YzTkdqN3lmN0pBcm9CVEY2d1A3V1UvSmU0eGdyWXRMcUFIUVhYcC9Fa0Zma0xMRjJBUDJQNko5ZXlpMi9aZWxpbkRTRlNtSG5pV2JlNyticUR6QUVqVHhSZk8rQ3dQRDFTNndEcVdFZURXc0FwN0g0MUNaa2hpMjRpNnUiLCJtYWMiOiIxYzE2NWZiOTNjYmRjMDYyMTdkMDZiMDgxYjI2ODZjNzFkNmJiMTBmMDE1Y2IzYzYyNzI4YWExOTc5ODhjOWVjIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 14:03:05 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tagmyfish_session=eyJpdiI6IjZmQm5RamE4R21yRlZiS3RQQVZnVmc9PSIsInZhbHVlIjoiVERZN2YzTkdqN3lmN0pBcm9CVEY2d1A3V1UvSmU0eGdyWXRMcUFIUVhYcC9Fa0Zma0xMRjJBUDJQNko5ZXlpMi ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImNOWTdkVlRyNEUxODhzV3U5RG5oeXc9PSIsInZhbHVlIjoid1JhMFNEUTl1dUlheE1WWXZTV1NlVVhrVXJxR1Z6aVZlUHkwZnluNHhQT1d3NUJod1NmcU1WZTVMdW8zcDgwYXRZWFBIOTN1c3ZJNENEWFhQOU12UmtPODU5aGtXZytnNkFkbW9MWncweEJCQThqek5sbEhqUkJzUHpmcW4xOWwiLCJtYWMiOiJkNmNkNDU4YTQ0OWVhZGEzMjczYzIyNGExMjYwYWVlMDBjMWFhNjMxYTY5NGE3YmU0ZTQyMTNlODM0ODBlMGUyIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 14:03:05 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImNOWTdkVlRyNEUxODhzV3U5RG5oeXc9PSIsInZhbHVlIjoid1JhMFNEUTl1dUlheE1WWXZTV1NlVVhrVXJxR1Z6aVZlUHkwZnluNHhQT1d3NUJod1NmcU1WZTVMdW8zcDgwYXRZWFBIO ▶" 1 => "tagmyfish_session=eyJpdiI6IjZmQm5RamE4R21yRlZiS3RQQVZnVmc9PSIsInZhbHVlIjoiVERZN2YzTkdqN3lmN0pBcm9CVEY2d1A3V1UvSmU0eGdyWXRMcUFIUVhYcC9Fa0Zma0xMRjJBUDJQNko5ZXlpMi9aZWxpbkRTRlNtSG5pV2JlNyticUR6QUVqVHhSZk8rQ3dQRDFTNndEcVdFZURXc0FwN0g0MUNaa2hpMjRpNnUiLCJtYWMiOiIxYzE2NWZiOTNjYmRjMDYyMTdkMDZiMDgxYjI2ODZjNzFkNmJiMTBmMDE1Y2IzYzYyNzI4YWExOTc5ODhjOWVjIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 14:03:05 GMT; path=/; secure; httponly ◀tagmyfish_session=eyJpdiI6IjZmQm5RamE4R21yRlZiS3RQQVZnVmc9PSIsInZhbHVlIjoiVERZN2YzTkdqN3lmN0pBcm9CVEY2d1A3V1UvSmU0eGdyWXRMcUFIUVhYcC9Fa0Zma0xMRjJBUDJQNko5ZXlpMi ▶" ] ]
0 of 0array:3 [▼ "_token" => "Dlp9J8TUKcorIHT161jSGxAS4C766b1Rj2HiFtws" "_previous" => array:1 [▶ "url" => "https://dev.tagmyfish.com/waters/river/john-day-river" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
