number of errors=96
number of warnings=0
country=LK
select countrycode,name,geonameid,admincode1,featureclass,featurecode,relevance from geoname where countrycode in ('LK') and not featureCode in ('ADM1H','ADM2H','ADM3H','ADM4H','ADM5H','ADMD') and admincode1 is not null and admincode1<>'00' and not exists (select 1 from geoname b where b.countrycode=geoname.countrycode and b.admincode1=geoname.admincode1 and b.featurecode='ADM1' and b.countrycode in ('LK')) order by countrycode,name
countrycode name geonameid admincode1 featureclass featurecode relevance LK Arangoda Ela 1251004 31 H STM 1 LK Bambarakande Wewa 1250407 31 H RSV 1 LK Beraliyawala 1249963 31 V FRST 2 LK Birihorowwa 1249872 31 V FRST 2 LK Bulatlebbe Aru 1249434 31 H STM 2 LK Dee Ela 1248505 31 H STM 1 LK East Channel 1247416 31 H CHNM 1 LK Ehela Atta Patana 1247321 31 V FRST 2 LK Elakotaliya Oya 1247252 31 H STM 1 LK Etavil 1246821 31 H MRSH 1 LK Galwala Kandura 1246111 31 H STM 1 LK Guruwala Oya 1245186 31 H STM 1 LK Hammilla Kulam 1244904 31 H RSV 1 LK Ilachan Kulam 1243275 31 H RSV 1 LK Ilanthai Kulam 1243246 31 H RSV 1 LK Imbilan Ara 1243143 31 H STM 1 LK Kadaveen Ela 1242683 31 H STM 1 LK Kadiun Ela 1242583 31 H STM 1 LK Kallar Channel 1242151 31 H DTCH 1 LK Kal Odai 1242098 31 H INLT 1 LK Kambiliya Ebbe 1241905 31 H WTRH 1 LK Kannankudah 1241574 31 S ESTX 1 LK Kannapate Ela 1241569 31 H STM 1 LK Kannippanian Aru 1241555 31 H STM 2 LK Kantalai Forest Reserve 1241540 31 L RESF 5 LK Karandaatte Ela 1241260 31 H STM 1 LK Karanda Oya 1241234 31 H STM 1 LK Karanda Oya 1241233 31 H STM 1 LK Kinana 1240326 31 V FRST 2 LK Kodiunne Ela 7420140 31 H STM 1 LK Kokkilai Lagoon 1239719 31 H LGN 5 LK Kokkilai Lagoon Sanctuary 1239718 31 L RES 6 LK Kollanveli Kulam 1239620 31 H RSV 1 LK Kottuvattai Kulam 1238977 31 H RSV 1 LK Kudakollewa 7440073 31 H RSV 1 LK Kuluwana 1238422 31 V SCRB 2 LK Kumbukkan Forest Reserve 1238325 31 L RESF 5 LK Kunchu Kulam 1238198 31 H RSV 1 LK Kunjan Odai 1238171 31 H STM 1 LK Lahagala Tank 1237864 31 H RSV 1 LK Lahuhela Oya 1237859 31 H STM 1 LK Madura Aru 1237292 31 H STMI 1 LK Maduru Oya 1237262 31 H STM 4 LK Makulewala Kandura 1236605 31 H STM 1 LK Mawana Ela 1235743 31 H STM 1 LK Mawana Ela 1235744 31 H STM 1 LK Medawachchi Ela 1235514 31 H STM 1 LK Megas Ulpota Dola 1235374 31 H STM 1 LK Menthodai Kulam 1235295 31 H RSV 1 LK Middle Channel 1235224 31 H CHNM 1 LK Moogamana Ela 1234794 31 H STM 1 LK Murungatena Kalapu 1234233 31 H LGN 1 LK Mutuporugala Wewa 1234137 31 H RSV 2 LK Nadumathurai 1234026 31 V FRST 2 LK Nagalle Ela 1233999 31 H STM 2 LK Namal Oya 1233816 31 H STM 1 LK Narivili Aru 1233629 31 H STM 2 LK Neeri Ella 1233377 31 V SCRB 2 LK Netheli Aru 1233206 31 H STM 1 LK Neugal Aar 1233187 31 H STM 1 LK Nikagollakumbura 1233141 31 V FRST 2 LK Nilai Aru 1233047 31 H RSV 1 LK Nochchitulavali Mottai 1232883 31 H WTRH 1 LK Palaitivu 1231990 31 T ISL 3 LK Palayairathalai Kulam 1231888 31 H RSV 1 LK Paraiyanveli Kulam 1231010 31 H RSV 1 LK Paravippanchan 1230915 31 V SCRB 2 LK Pawana Aru 1230698 31 H STMI 1 LK Pawana Vette 1230697 31 H MRSH 1 LK Peedar Canal 7420223 31 H CNL 1 LK Pettiyan Oya 1230305 31 H STM 1 LK Point Pedro Shoal 1229988 31 H SHOL 1 LK Pota Kulam 1229786 31 H RSV 1 LK Pulukanitta Kulam 1229453 31 H RSV 1 LK Rota Aar 1228517 31 H STM 1 LK Salamba Kulam 1228366 31 H RSV 1 LK Saymena Aar 1228219 31 H STM 1 LK South Banks 1227622 31 H SHOL 1 LK Southern Channel 1227620 31 H CHNM 1 LK Timbiri Aru 1226508 31 H STM 1 LK Town Pier 6313978 31 S PIER 1 LK Uppu Kuli 1225448 31 H RSV 1 LK Ura Vidda Arambe 1225387 31 V FRST 2 LK Vairayankadangu Kalappu 1225196 31 H STMM 1 LK Vellai Aru 1224915 31 H STM 1 LK Viralipuli Kulam 1224736 31 V SCRB 2 LK Watawala Kandiya 1224113 31 H RSV 1 LK Watta Madu 1224082 31 H WTRH 1 LK Welikumbure Ela 1223677 31 H STM 1 LK Welipakuna 1223665 31 H PND 1 LK Wendirigolla Oya 1223529 31 H STM 1 LK Yala East Intermediate Zone 1222936 31 L AREA 5 LK Yala Strict Natural Reserve 1222922 31 L RESN 5 LK Yan Oya 1222895 31 H STM 3 LK Yodiyankadu Aru 1222756 31 H STM 1 LK York Island 1222746 31 S TRIG 1