select webflatfileid, comname, sciname, webflatfile.vcode, rating, Day, height, width, spcode, photodata, country_state, locality, age, sex, month, dname, comments from webflatfile left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND country_state LIKE '%USA% Oregon%'
select webflatfileid, comname, sciname, webflatfile.vcode, rating, Day, height, width, spcode, photodata, country_state, locality, age, sex, month, dname, comments from webflatfile left join filelist on webflatfile.vcode = filelist.vcode where found=2 AND country_state LIKE '%USA% Oregon%' order by spcode, comname, rating DESC LIMIT 100
590 Images found.
|
Common Loon Gavia immer |
 s72/5/015 Common Loon |
Horned Grebe Podiceps auritus |
 c22/21/001 Horned Grebe |  h21/9/019 Horned Grebe |  h21/10/002 Horned Grebe |  s72/3/026 Horned Grebe |
|
Eared Grebe Podiceps nigricollis |
 c44/6/044 Eared Grebe |  s42/1/001 Eared Grebe |  b13/49/014 Eared Grebe |  s72/3/018 Eared Grebe |
|
Western Grebe Aechmophorus occidentalis |
 c44/6/004 Western Grebe |  b13/49/050 Western Grebe |  h21/9/034 Western Grebe |
Clark's Grebe Aechmophorus clarkii |
 c44/6/005 Clark's Grebe |  c44/6/006 Clark's Grebe |  b13/49/011 Clark's Grebe |
American White Pelican Pelecanus erythrorhynchos |
 h21/10/005 American White Pelican |
Brown Pelican Pelecanus occidentalis |
 c22/40/182 Brown Pelican |
Double-crested Cormorant Phalacrocorax auritus |
 s42/2/002 Double-crested Cormorant |  s42/2/003 Double-crested Cormorant |  s42/2/005 Double-crested Cormorant |
Brandt's Cormorant Phalacrocorax penicillatus |
 w02/47/039 Brandt's Cormorant |  s72/15/004 Brandt's Cormorant |  w02/47/068 Brandt's Cormorant |
Pelagic Cormorant Phalacrocorax pelagicus |
 w02/47/122 Pelagic Cormorant |  p19/1/590 Pelagic Cormorant |  p19/1/601 Pelagic Cormorant |  p19/1/604 Pelagic Cormorant |
 s72/3/043 Pelagic Cormorant |
American Bittern Botaurus lentiginosus |
 s72/5/003 American Bittern |
White-faced Ibis Plegadis chihi |
 c44/4/185 White-faced Ibis |  c44/4/186 White-faced Ibis |  c44/6/065 White-faced Ibis |  b57/4/254 White-faced Ibis |
 b57/4/255 White-faced Ibis |  b57/4/256 White-faced Ibis |
Tundra Swan Cygnus columbianus |
 s72/9/020 Tundra Swan |  s72/9/021 Tundra Swan |
Greater White-fronted Goose Anser albifrons |
 h21/10/016 Greater White-fronted Goose |  p27/1/003 Greater White-fronted Goose |
Ross's Goose Chen rossii |
 s72/3/051 Ross's Goose |  s72/3/053 Ross's Goose |  s72/3/052 Ross's Goose |  s72/3/054 Ross's Goose |
 s72/3/055 Ross's Goose |  s72/3/056 Ross's Goose |  s72/3/057 Ross's Goose |
Canada Goose Branta canadensis |
 s72/12/009 Canada Goose |  s72/9/001 Canada Goose |  s72/9/070 Canada Goose |
Wood Duck Aix sponsa |
 s72/1/029 Wood Duck |  s72/3/077 Wood Duck |
American Wigeon Anas americana |
 m17/67/048 American Wigeon |
Gadwall Anas strepera |
 s72/8/003 Gadwall |  s72/3/020 Gadwall |
Green-winged Teal Anas crecca |
 s72/9/047 Green-winged Teal |
Mallard Anas platyrhynchos |
 f20/9/422 Mallard |
Northern Shoveler Anas clypeata |
 c22/21/004 Northern Shoveler |  c22/21/005 Northern Shoveler |  c22/21/006 Northern Shoveler |  s72/1/018 Northern Shoveler |
|
Ring-necked Duck Aythya collaris |
 w02/47/191 Ring-necked Duck |
Lesser Scaup Aythya affinis |
 h21/8/006 Lesser Scaup |
Black Scoter Melanitta nigra |
 h21/10/019 Black Scoter |
Bufflehead Bucephala albeola |
 m17/67/176 Bufflehead |  m17/67/177 Bufflehead |
Common Goldeneye Bucephala clangula |
 s72/1/005 Common Goldeneye |
Common Merganser Mergus merganser |
 s72/3/007 Common Merganser |  s72/3/008 Common Merganser |  s72/3/009 Common Merganser |  v16/1/017 Common Merganser |
|
Ruddy Duck Oxyura jamaicensis |
 c44/4/188 Ruddy Duck |  s72/5/036 Ruddy Duck |
Trumpeter Swan Cygnus buccinator |
 t12/1/135 Trumpeter Swan |  t12/1/136 Trumpeter Swan |  t12/1/137 Trumpeter Swan |
Cackling Goose Branta hutchinsii |
 s72/1/009 Cackling Goose |
Bald Eagle Haliaeetus leucocephalus |
 w02/47/015 Bald Eagle |
Northern Harrier Circus cyaneus |
 b61/2/039 Northern Harrier |  b61/2/040 Northern Harrier |
Northern Goshawk Accipiter gentilis |
 s72/10/008 Northern Goshawk |
Swainson's Hawk Buteo swainsoni |
 s72/3/069 Swainson's Hawk |  s72/3/070 Swainson's Hawk |  s72/3/071 Swainson's Hawk |  s72/3/072 Swainson's Hawk |
 s72/3/073 Swainson's Hawk |
Red-tailed Hawk Buteo jamaicensis |
 s72/12/018 Red-tailed Hawk |  s72/12/019 Red-tailed Hawk |  s72/12/020 Red-tailed Hawk |  s72/12/021 Red-tailed Hawk |
 s72/9/013 Red-tailed Hawk |  s72/9/014 Red-tailed Hawk |  s72/9/031 Red-tailed Hawk |  s72/9/052 Red-tailed Hawk |
 s72/9/053 Red-tailed Hawk |  s72/9/054 Red-tailed Hawk |  s72/9/072 Red-tailed Hawk |  s72/3/047 Red-tailed Hawk |
 s72/3/046 Red-tailed Hawk |  s72/3/048 Red-tailed Hawk |
Rough-legged Hawk Buteo lagopus |
 s72/9/060 Rough-legged Hawk |