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% New% York%'
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% New% York%' order by spcode, comname, rating DESC LIMIT 100
2872 Images found.
|
Human Homo sapiens |
 m17/18/107 Human |  m17/18/108 Human |  m17/18/109 Human |  b52/1/358 Human |
 m17/34/010 Human |  s36/28/001 Human |  m17/23/240 Human |  m17/14/001 Human |
 b52/3/069 Human |  s36/25/058 Human |  m17/42/001 Human |  m17/28/004 Human |
 m17/28/005 Human |  m17/28/008 Human |  m17/73/181 Human |  m17/50/004 Human |
 m17/61/003 Human |  d03/6/084 Human |  s36/26/001 Human |  b52/1/356 Human |
 b52/1/359 Human |  h36/9/001 Human |  b52/1/360 Human |  b52/1/361 Human |
 m17/38/004 Human |  s36/32/054 Human |  m17/20/220 Human |
Solitary Tinamou Tinamus solitarius |
 h02/15/001 Solitary Tinamou |
Manx Shearwater Puffinus puffinus |
 d14/1/013 Manx Shearwater |
Red-throated Loon Gavia stellata |
 s60/9/003 Red-throated Loon |  b52/1/519 Red-throated Loon |
Common Loon Gavia immer |
 g14/12/001 Common Loon |  g14/12/002 Common Loon |  g14/12/003 Common Loon |
Pied-billed Grebe Podilymbus podiceps |
 s79/2/044 Pied-billed Grebe |  c27/7/392 Pied-billed Grebe |  c27/7/393 Pied-billed Grebe |  c27/7/395 Pied-billed Grebe |
 c27/7/391 Pied-billed Grebe |
Horned Grebe Podiceps auritus |
 b52/1/306 Horned Grebe |
Double-crested Cormorant Phalacrocorax auritus |
 s60/3/003 Double-crested Cormorant |  s36/36/022 Double-crested Cormorant |  s36/36/023 Double-crested Cormorant |  s36/39/058 Double-crested Cormorant |
 m17/50/010 Double-crested Cormorant |  s36/36/024 Double-crested Cormorant |  s36/31/039 Double-crested Cormorant |  m17/29/004 Double-crested Cormorant |
 s60/3/004 Double-crested Cormorant |  s60/3/005 Double-crested Cormorant |  s36/35/010 Double-crested Cormorant |  m17/22/014 Double-crested Cormorant |
 m17/15/001 Double-crested Cormorant |  m17/22/018 Double-crested Cormorant |  m17/15/003 Double-crested Cormorant |  m17/50/011 Double-crested Cormorant |
 m17/50/012 Double-crested Cormorant |  m17/42/034 Double-crested Cormorant |  m17/42/035 Double-crested Cormorant |  m17/42/037 Double-crested Cormorant |
 m17/42/039 Double-crested Cormorant |  m17/46/008 Double-crested Cormorant |  m17/46/009 Double-crested Cormorant |  m17/34/074 Double-crested Cormorant |
 m17/37/017 Double-crested Cormorant |  m17/63/011 Double-crested Cormorant |  m17/5/012 Double-crested Cormorant |
Great Cormorant Phalacrocorax carbo |
 m17/23/003 Great Cormorant |
Guanay Cormorant Phalacrocorax bougainvillii |
 h02/4/012 Guanay Cormorant |  l01/11/001 Guanay Cormorant |
American Bittern Botaurus lentiginosus |
 s60/9/004 American Bittern |  s60/7/002 American Bittern |  c27/7/001 American Bittern |
Least Bittern Ixobrychus exilis |
 t12/1/030 Least Bittern |  t12/1/031 Least Bittern |  s36/5/021 Least Bittern |  t12/1/023 Least Bittern |
 t12/1/024 Least Bittern |  t12/1/025 Least Bittern |  t12/1/033 Least Bittern |  s36/6/004 Least Bittern |
 t12/1/037 Least Bittern |
Black-crowned Night-Heron Nycticorax nycticorax |
 s36/39/056 Black-crowned Night-Heron |  s36/8/001 Black-crowned Night-Heron |  m17/32/007 Black-crowned Night-Heron |  m17/32/010 Black-crowned Night-Heron |
 s36/3/010 Black-crowned Night-Heron |  s36/39/057 Black-crowned Night-Heron |  s36/8/002 Black-crowned Night-Heron |  m17/32/009 Black-crowned Night-Heron |
 m17/32/011 Black-crowned Night-Heron |  m17/37/029 Black-crowned Night-Heron |  m17/37/030 Black-crowned Night-Heron |  m17/37/033 Black-crowned Night-Heron |
 m17/23/035 Black-crowned Night-Heron |  s36/30/002 Black-crowned Night-Heron |  m17/30/037 Black-crowned Night-Heron |