number of errors=182
number of warnings=0
country=IE
select countrycode,name,geonameid,admincode1,admincode2,featureclass,featurecode,relevance from geoname where countrycode in ('IE') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and not featurecode in ('STM') and admincode1 is not null and admincode1<>'00' and admincode2 is not null and not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.admincode2=geoname.admincode2 and b.featurecode='ADM2' and b.countrycode in ('IE')) order by relevance desc,admincode1,admincode2
countrycode name geonameid admincode1 admincode2 featureclass featurecode relevance IE Lough Gur 2963835 M 16 H LK 8 IE Riverquarter 3301407 M 27 L LCTY 8 IE Saint Patricks Island 2961618 L 07 T ISL 6 IE Dublin Bay 2964571 L 07 H BAY 6 IE North Bull Island 2962213 L 07 T ISL 6 IE Rockabill 3230865 L 07 T ISL 6 IE Colt Island 3230861 L 07 T ISL 6 IE Irelands Eye 2963596 L 07 T ISL 6 IE Dalkey Island 3230510 L 07 T ISL 6 IE Lambay Island 2963039 L 07 T ISL 6 IE Aughinish Island 2966823 M 16 T ISL 6 IE Ballyhoura Mountains 2966553 M 16 T MTS 6 IE Fauscoum 3301433 M 27 T RDGE 6 IE Comeragh Mountains 2965244 M 27 T MTS 6 IE Passage East 2962067 M 27 P PPL 6 IE Little Island 2962857 M 27 T ISL 6 IE Plassey Technological Park 3310137 M 16 L INDS 5 IE Bleach Lough 3310168 M 16 H LK 5 IE Milltown Lake 3310182 M 16 H LK 5 IE Doohyle Lough 3310087 M 16 H LK 5 IE Dromore Lough 3310169 M 16 H LK 5 IE Lough Nagirra 3310035 M 16 H LK 5 IE Lough Coumfea 3301272 M 27 H LK 5 IE Brownstown 3301650 M 27 L LCTY 5 IE Graigavine 3301406 M 27 L LCTY 5 IE Knockaunriark 3301648 M 27 L LCTY 5 IE Dunabrattin Head 2964557 M 27 T CAPE 5 IE Ballysaggart 3300664 M 27 L AREA 5 IE Coumshingaun Lough 2965096 M 27 H LK 5 IE Crooke 3301739 M 27 L LCTY 5 IE Kilfarrasy 3301587 M 27 L LCTY 5 IE Carrickbrean 3301103 M 27 L LCTY 5 IE Belle Lake 3301678 M 27 H LK 5 IE Ballyscanlan Lough 3301596 M 27 H LK 5 IE Coumduala Lough 3301429 M 27 H LK 5 IE Lough Mohra 3301428 M 27 H LK 5 IE Ballin Lough 3301334 M 27 H LK 5 IE Ionaneea Lake 3301071 M 27 H LK 5 IE Clare Rock 3230518 L 07 T RK 4 IE Lamb Island 3230512 L 07 T RK 4 IE Casana Rock 3315300 L 07 T RK 4 IE Lowtherstone 3316386 L 07 T RK 4 IE Burren Rocks 3230847 L 07 T RKS 4 IE Muglins 3230516 L 07 T RK 4 IE Velvet Strand 3230832 L 07 T BCH 4 IE Maiden Rock 3230519 L 07 T RK 4 IE Tailor Rocks 3316309 L 07 T RKS 4 IE Leac Buidhe 3230517 L 07 T RK 4 IE Sutton Strand 3230819 L 07 T BCH 4 IE Cardy Rocks 3316385 L 07 T RKS 4 IE Harp Ear 3316308 L 07 T CAPE 4 IE Kiln Point 2963232 L 07 T PT 4 IE Foynes Island 2964224 M 16 T ISL 4 IE Slievefelim Mountains 2961436 M 16 T MTS 4 IE Glen Bevan 3310022 M 16 T VAL 4 IE Glenanair 3300803 M 16 T VAL 4 IE Carrigeen 3310056 M 16 T CLF 4 IE Greenish Island 3310190 M 16 T ISL 4 IE Blackball Head 3230817 M 27 T CAPE 4 IE Creadan Head 2965069 M 27 T CAPE 4 IE Brownstown Head 2965949 M 27 T CAPE 4 IE Swede Rock 3226223 M 27 T RK 4 IE Monavullagh Mountains 3230120 M 27 T MTS 4 IE Coumtay 3301274 M 27 T RDGE 4 IE Black Rock 3301034 M 27 T RK 4 IE Suir Island 2961317 M 27 T ISL 4 IE Carricknamoan 3301129 M 27 T RK 4 IE Gull Island 2963838 M 27 T ISL 4 IE Woodstown House 3301679 M 27 S HSEC 4 IE Cunnigar Point 3301127 M 27 T PT 4 IE Pollack Rock 3226227 M 27 T RK 4 IE Ardnamult Head 3301666 M 27 T CAPE 4 IE Ballyvoyle Head 2966389 M 27 T CAPE 4 IE Swines Head 2961298 M 27 T CAPE 4 IE Tramore Strand 3301647 M 27 T BCH 4 IE Helvick Head 2963783 M 27 T CAPE 4 IE Slippery Island 3301176 M 27 T ISL 4 IE Carricknagaddy 3301130 M 27 T RK 4 IE Carrickapane 3301128 M 27 T RK 4 IE Knockavelish Head 3301667 M 27 T CAPE 4 IE Black Rock 3301586 M 27 T RK 4 IE Great Newtown Head 2963876 M 27 T CAPE 4 IE Nose of Howth 2962207 L 07 T PT 3 IE Dublin Bar 2964572 L 07 T BAR 3 IE Shenicks Island 2961498 L 07 T ISL 3 IE Drumleck Point 3230818 L 07 T PT 3 IE Burge Bar 3230848 L 07 T BAR 3 IE Scotch Point 3230854 L 07 T PT 3 IE Red Island 3230862 L 07 T ISLT 3 IE Sunk Island 3316307 L 07 T ISL 3 IE The Nose 3230849 L 07 T PT 3 IE Sorrento Point 3230513 L 07 T PT 3 IE Sandycove Point 3230521 L 07 T PT 3 IE Cush Point 3230830 L 07 T PT 3 IE Dún Laoghaire Harbour 3230524 L 07 H HBR 3 IE Knockbane 3230851 L 07 T HLL 3 IE Waller’s Island 3310213 M 16 T ISL 3 IE Oola Hills 3305514 M 16 T HLLS 3 IE Sturamus Island 3310224 M 16 T ISL 3 IE Carrignabinnia 3300900 M 16 T GAP 3 IE Glenacurrane 3300881 M 16 T GAP 3 IE Mine Head 2962591 M 27 T CAPE 3 IE The Gap 3300964 M 27 T GAP 3 IE Killangford Bridge 3301125 M 27 P PPL 3 IE Cabin Point 3301028 M 27 T PT 3 IE Ballyscanlan Hills 3301595 M 27 T HLLS 3 IE Foilakippeen Hill 3301665 M 27 T HLL 3 IE Barnanmaddra Gap 3301270 M 27 T GAP 3 IE Ram Head 3301037 M 27 T CAPE 3 IE Black Knob 3301664 M 27 T PT 3 IE East Point 3301026 M 27 T PT 3 IE The Gap 3301430 M 27 T GAP 3 IE Ardmore Head 3301036 M 27 T CAPE 3 IE Brazen Head 3301649 M 27 T CAPE 3 IE Ferry Point 3301108 M 27 T PT 3 IE Sheep Island 3301589 M 27 T ISL 3 IE Killiney Bay 3230506 L 07 H BAY 2 IE Stark’s Wood 3300845 M 16 V FRST 2 IE Abbey River 2967091 M 16 H STMA 2 IE Green Wood 3300824 M 16 V FRST 2 IE Glenhouse Wood 3301377 M 27 V FRST 2 IE Glendalligan Wood 3301264 M 27 V FRST 2 IE Brownswood 3301403 M 27 V FRST 2 IE Portlaw Wood 3301380 M 27 V FRST 2 IE Colligan Wood 3301196 M 27 V FRST 2 IE Inchindrisla Wood 3301195 M 27 V FRST 2 IE Carran Wood 3301453 M 27 V FRST 2 IE Kilbunny Wood 3301379 M 27 V FRST 2 IE Dromana Forest 2964656 M 27 V FRST 2 IE Tikincor Wood 3301516 M 27 V FRST 2 IE Dungarvan Harbour 2964526 M 27 H HBR 2 IE Mountneill Wood 2962473 M 27 V FRST 2 IE Glen Poer Wood 3301530 M 27 V FRST 2 IE Coolnamuck Wood 3301542 M 27 V FRST 2 IE The Pines 3301636 M 27 V FRST 2 IE Gurteen Wood 3301523 M 27 V FRST 2 IE Spencer Dock 3289063 L 07 H DCK 1 IE Ringsend Gut 2961815 L 07 H INLT 1 IE Scotsmans Bay 3230523 L 07 H BAY 1 IE Sandycove Harbour 3230522 L 07 H COVE 1 IE West Pier 3289067 L 07 S BRKW 1 IE East Pier 3289066 L 07 S BRKW 1 IE Saltpan Bay 3230857 L 07 H BAY 1 IE Howth Sound 3230827 L 07 H SD 1 IE Howth Harbour 3230826 L 07 H HBR 1 IE Great South Wall 3289058 L 07 S BRKW 1 IE Royal Canal Dock 3289062 L 07 H DCK 1 IE Bog of the Ring 3316363 L 07 H BOG 1 IE Doldrum Bay 3230822 L 07 H BAY 1 IE Coliemore Harbour 3230514 L 07 H COVE 1 IE Muglins Sound 3230515 L 07 H CHNM 1 IE Freshwater Bay 3230823 L 07 H BAY 1 IE Dalkey Sound 3230511 L 07 H CHNM 1 IE Talbots Bay 3230846 L 07 H BAY 1 IE Frazer Bank 3230859 L 07 H BNK 1 IE Kilbreedy Loughs 3310084 M 16 H LKS 1 IE Limerick Canal 2962940 M 16 H CNL 1 IE Limerick Harbour 2962939 M 16 H HBR 1 IE Poularone Creek 3310194 M 16 H CRKT 1 IE Spit Bank 3301136 M 27 H SHOL 1 IE Sgilloge Loughs 3301434 M 27 H LKS 1 IE Ardmore Bay 3301035 M 27 H BAY 1 IE Clonmore House 3301391 M 27 S HSEC 1 IE Clonea Bay 3230798 M 27 H BAY 1 IE Creadan House 2965068 M 27 S BLDG 1 IE Knockaderry Reservoir 3301341 M 27 H RSV 1 IE Deadman Sand 3301131 M 27 H SHOL 1 IE Kilmurrin Cove 3301179 M 27 H COVE 1 IE Clonea Castle 2965374 M 27 S EST 1 IE Ardmore Bay 2966910 M 27 H BAY 1 IE Muggorts Bay 2962388 M 27 H BAY 1 IE Tramore Bay 2961119 M 27 H BAY 1 IE Bunmahon Bay 3301177 M 27 H BAY 1 IE Ladys Cove 3301170 M 27 H COVE 1 IE Rinnashark Harbour 3226228 M 27 H HBR 1 IE Ballydowane Bay 3301171 M 27 H BAY 1 IE Back Strand 3226226 M 27 H COVE 1 IE Whitehouse Bank 3301126 M 27 H BNK 1 IE Newpark House 3301747 M 27 S HSEC 1 IE King Channel 3302134 M 27 H CHN 1 IE Pollrone House 3301383 M 27 S HSEC 1 IE Lydiard House 3301137 M 27 S HSEC 1