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 |