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% South% 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% South% Island%' order by spcode, comname, rating DESC LIMIT 100
172 Images found.
|
Brown Kiwi Apteryx australis |
 h27/7/001 Brown Kiwi |
Wandering Albatross Diomedea exulans |
 v12/1/016 Wandering Albatross |  r16/5/003 Wandering Albatross |  r16/5/004 Wandering Albatross |  v12/1/015 Wandering Albatross |
|
Royal Albatross Diomedea epomophora |
 a16/9/430 Royal Albatross |  a16/9/435 Royal Albatross |  a16/9/436 Royal Albatross |  l09/18/001 Royal Albatross |
|
Black-browed Albatross Thalassarche melanophris |
 h27/7/004 Black-browed Albatross |
Buller's Albatross Thalassarche bulleri |
 h27/4/003 Buller's Albatross |
Shy Albatross Thalassarche cauta |
 h27/7/009 Shy Albatross |  w02/12/006 Shy Albatross |  h27/7/012 Shy Albatross |  s41/3/009 Shy Albatross |
 a16/9/470 Shy Albatross |  a16/9/471 Shy Albatross |  a16/9/472 Shy Albatross |  a16/9/588 Shy Albatross |
 a16/9/589 Shy Albatross |
Northern Giant-Petrel Macronectes halli |
 h27/7/013 Northern Giant-Petrel |
Southern Fulmar Fulmarus glacialoides |
 h27/7/014 Southern Fulmar |
Cape Petrel Daption capense |
 w02/12/005 Cape Petrel |  a16/9/352 Cape Petrel |  a16/9/353 Cape Petrel |  a16/9/354 Cape Petrel |
 h27/7/015 Cape Petrel |
Fairy Prion Pachyptila turtur |
 a16/9/186 Fairy Prion |  h27/8/001 Fairy Prion |
Gray Petrel Procellaria cinerea |
 h27/7/016 Gray Petrel |  h27/7/017 Gray Petrel |  h27/7/018 Gray Petrel |
White-chinned Petrel Procellaria aequinoctialis |
 s51/5/019 White-chinned Petrel |
Westland Petrel Procellaria westlandica |
 h27/4/006 Westland Petrel |  s51/5/020 Westland Petrel |
Flesh-footed Shearwater Puffinus carneipes |
 h27/7/024 Flesh-footed Shearwater |
Buller's Shearwater Puffinus bulleri |
 a16/9/107 Buller's Shearwater |  a16/9/108 Buller's Shearwater |  s51/5/023 Buller's Shearwater |
Sooty Shearwater Puffinus griseus |
 h27/3/030 Sooty Shearwater |  a16/9/531 Sooty Shearwater |
Hutton's Shearwater Puffinus huttoni |
 a16/9/235 Hutton's Shearwater |
Fiordland Penguin Eudyptes pachyrhynchus |
 s66/1/104 Fiordland Penguin |  s66/1/105 Fiordland Penguin |  w26/6/010 Fiordland Penguin |  w26/6/012 Fiordland Penguin |
 h27/8/008 Fiordland Penguin |  w26/6/008 Fiordland Penguin |
Yellow-eyed Penguin Megadyptes antipodes |
 p19/2/037 Yellow-eyed Penguin |
Little Penguin Eudyptula minor |
 s66/1/142 Little Penguin |  w02/12/008 Little Penguin |  s66/1/141 Little Penguin |  h27/2/003 Little Penguin |
|
White-flippered Penguin Eudyptula albosignata |
 v12/4/029 White-flippered Penguin |  v12/4/030 White-flippered Penguin |  v12/4/031 White-flippered Penguin |  v12/4/032 White-flippered Penguin |
 v12/4/033 White-flippered Penguin |  v12/4/034 White-flippered Penguin |  p19/2/040 White-flippered Penguin |
Great Crested Grebe Podiceps cristatus |
 c20/2/002 Great Crested Grebe |
Rough-faced Shag Phalacrocorax carunculatus |
 s41/3/013 Rough-faced Shag |
Spotted Shag Phalacrocorax punctatus |
 w02/12/013 Spotted Shag |  w02/12/015 Spotted Shag |  r16/3/054 Spotted Shag |  a16/9/547 Spotted Shag |
 a16/9/548 Spotted Shag |  a16/9/549 Spotted Shag |  h27/1/008 Spotted Shag |
Little Pied Cormorant Phalacrocorax melanoleucos |
 h27/1/010 Little Pied Cormorant |  h27/1/011 Little Pied Cormorant |
Little Cormorant Phalacrocorax niger |
 a16/9/286 Little Cormorant |
Bronze Shag Phalacrocorax chalconotus |
 a16/9/523 Bronze Shag |  a16/9/524 Bronze Shag |  a16/9/520 Bronze Shag |  a16/9/521 Bronze Shag |
 a16/9/522 Bronze Shag |  a16/9/525 Bronze Shag |
Royal Spoonbill Platalea regia |
 a16/9/467 Royal Spoonbill |
Paradise Shelduck Tadorna variegata |
 h27/4/013 Paradise Shelduck |  w02/12/024 Paradise Shelduck |  a16/9/347 Paradise Shelduck |
Blue Duck Hymenolaimus malacorhynchos |
 h27/1/016 Blue Duck |
Swamp Harrier Circus approximans |
 h27/1/019 Swamp Harrier |
New Zealand Falcon Falco novaeseelandiae |
 h27/1/021 New Zealand Falcon |
Indian Peafowl Pavo cristatus |
|
Weka Gallirallus australis |
 p19/2/043 Weka |  p19/2/045 Weka |  p19/2/052 Weka |  v12/4/037 Weka |
 v12/4/038 Weka |  p19/2/047 Weka |  p19/2/049 Weka |  v12/4/039 Weka |
 v12/4/040 Weka |
Spotless Crake Porzana tabuensis |
 h27/6/006 Spotless Crake |  h27/6/007 Spotless Crake |
Purple Swamphen Porphyrio porphyrio |
 h27/1/023 Purple Swamphen |
Takahe Notornis mantelli |
 p19/2/054 Takahe |