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 '%New% Zealand% North% Island%'
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 '%New% Zealand% North% Island%' order by spcode, comname, rating DESC LIMIT 100
283 Images found.
|
Brown Kiwi Apteryx australis |
 v12/1/001 Brown Kiwi |  v12/1/002 Brown Kiwi |  v12/1/003 Brown Kiwi |  v12/4/001 Brown Kiwi |
 v12/4/002 Brown Kiwi |  v12/4/003 Brown Kiwi |  v12/4/004 Brown Kiwi |  v12/4/005 Brown Kiwi |
|
Little Spotted Kiwi Apteryx owenii |
 v12/1/004 Little Spotted Kiwi |
Great Spotted Kiwi Apteryx haastii |
 c20/1/001 Great Spotted Kiwi |
White-faced Storm-Petrel Pelagodroma marina |
 s51/5/005 White-faced Storm-Petrel |
Great-winged Petrel Pterodroma macroptera |
 c20/1/004 Great-winged Petrel |  c20/1/005 Great-winged Petrel |
Cook's Petrel Pterodroma cookii |
 s51/5/011 Cook's Petrel |  s51/5/012 Cook's Petrel |  c20/9/001 Cook's Petrel |
Parkinson's Petrel Procellaria parkinsoni |
 r16/3/026 Parkinson's Petrel |
Buller's Shearwater Puffinus bulleri |
 s51/5/016 Buller's Shearwater |
Little Shearwater Puffinus assimilis |
 c20/2/001 Little Shearwater |
Little Penguin Eudyptula minor |
 c20/7/006 Little Penguin |  c20/1/008 Little Penguin |  c20/1/009 Little Penguin |  c20/1/010 Little Penguin |
 v12/1/050 Little Penguin |
New Zealand Grebe Poliocephalus rufopectus |
 c20/1/012 New Zealand Grebe |  c20/7/009 New Zealand Grebe |  c20/7/010 New Zealand Grebe |  h27/2/004 New Zealand Grebe |
|
Little Black Cormorant Phalacrocorax sulcirostris |
 c20/1/019 Little Black Cormorant |  c20/1/020 Little Black Cormorant |  c20/1/022 Little Black Cormorant |  c20/4/001 Little Black Cormorant |
|
Great Cormorant Phalacrocorax carbo |
 c20/2/005 Great Cormorant |  c20/4/007 Great Cormorant |
Pied Cormorant Phalacrocorax varius |
 c20/4/002 Pied Cormorant |  c20/4/004 Pied Cormorant |  c20/7/011 Pied Cormorant |
Spotted Shag Phalacrocorax punctatus |
 c20/1/023 Spotted Shag |  c20/1/024 Spotted Shag |  c20/1/026 Spotted Shag |
Little Pied Cormorant Phalacrocorax melanoleucos |
 c20/1/013 Little Pied Cormorant |  c20/1/014 Little Pied Cormorant |  c20/1/016 Little Pied Cormorant |  c20/1/017 Little Pied Cormorant |
|
Australasian Gannet Morus serrator |
 g22/3/010 Australasian Gannet |  c20/1/032 Australasian Gannet |  c20/1/037 Australasian Gannet |  s66/1/184 Australasian Gannet |
 s66/1/185 Australasian Gannet |  s66/1/186 Australasian Gannet |  r16/3/062 Australasian Gannet |  r16/3/063 Australasian Gannet |
 r16/3/064 Australasian Gannet |  c20/4/012 Australasian Gannet |  c20/4/013 Australasian Gannet |  c20/4/016 Australasian Gannet |
 v12/1/056 Australasian Gannet |  g22/3/008 Australasian Gannet |  g22/3/009 Australasian Gannet |  c20/9/003 Australasian Gannet |
 s66/1/187 Australasian Gannet |
Brown Bittern Botaurus poiciloptilus |
 c20/1/070 Brown Bittern |
White-faced Heron Ardea novaehollandiae |
 c20/1/068 White-faced Heron |  c20/1/069 White-faced Heron |  c20/7/012 White-faced Heron |
Black Swan Cygnus atratus |
 c20/7/014 Black Swan |  c20/2/013 Black Swan |  c20/2/015 Black Swan |
Cape Barren Goose Cereopsis novaehollandiae |
 c20/6/004 Cape Barren Goose |
Paradise Shelduck Tadorna variegata |
 c20/1/059 Paradise Shelduck |  c20/1/062 Paradise Shelduck |
Brown Teal Anas aucklandica |
 w02/12/018 Brown Teal |  c20/1/056 Brown Teal |  c20/1/057 Brown Teal |  w02/12/022 Brown Teal |
|
Australian Shoveler Anas rhynchotis |
 c20/1/050 Australian Shoveler |  c20/1/051 Australian Shoveler |  c20/2/016 Australian Shoveler |
New Zealand Scaup Aythya novaseelandiae |
 c20/1/045 New Zealand Scaup |  c20/1/046 New Zealand Scaup |  c20/7/017 New Zealand Scaup |  c20/7/018 New Zealand Scaup |
|
Pacific Black Duck Anas superciliosa |
 c20/1/049 Pacific Black Duck |
Swamp Harrier Circus approximans |
 c20/1/073 Swamp Harrier |  c20/1/076 Swamp Harrier |
New Zealand Falcon Falco novaeseelandiae |
 c20/1/077 New Zealand Falcon |  c20/2/025 New Zealand Falcon |
California Quail Callipepla californica |
 c20/9/004 California Quail |
Red Junglefowl Gallus gallus |
 c20/5/013 Red Junglefowl |
Indian Peafowl Pavo cristatus |
|
Buff-banded Rail Rallus philippensis |
 h27/7/029 Buff-banded Rail |
Weka Gallirallus australis |
 c20/1/264 Weka |  h27/7/030 Weka |