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 |