number of errors=9
number of warnings=44
Group=chkGrpShp
Group=ckgGrpIsland
Group=ckgGrpWP
select geoname.geonameid,name,countrycode,featureclass,geoname.featurecode,relevance,st_area(wkb_geometry), geoshapeid,case when st_area(wkb_geometry) >0.1 then 'ERR' else 'WRN' end as ERRWRN from geoname,geoname_bbox where geoname.geonameid=geoname_bbox.geonameid and st_area(wkb_geometry)>0.03 and wkb_geometry is not null and not exists (select 1 from alternatename where alternatename.geonameid=geoname.geonameid and namelocale='link') and featureclass='T' and geoshapeid not in (5595,23568) order by st_area(wkb_geometry) desc
[{key=RU,number=12}, {key=GL,number=10}, {key=BR,number=6}, {key=CL,number=5}, {key=ID,number=5}, {key=CA,number=4}, {key=CH,number=2}, {key=AQ,number=1}, {key=KG,number=1}, {key=MM,number=1}, {key=MR,number=1}, {key=QA,number=1}, {key=SB,number=1}, {key=SN,number=1}, {key=TH,number=1}, {key=VN,number=1}]
geonameid name countrycode featureclass featurecode relevance st_area geoshapeid errwrn 2596029 Île aux Bois MR T ISL 8 89.82273724233087 24753 ERR 1528008 Ostrov Kayrak KG T ISL 9 21.388850944730066 25279 ERR 289691 Qaţar QA T PEN 8 1.0442014022540196 25154 ERR 2022648 Ostrov Khardang-Sise RU T ISL 5 0.37358773028227893 735792 ERR 9290500 Cù Lao Bưng VN T ISL 5 0.3663674588791288 711040 ERR 3421954 Markham Ø GL T ISL 4 0.2853190632939442 747087 ERR 1481545 Letkya Kyun MM T ISL 4 0.14145106200297247 827500 ERR 2056275 Ostrov Kyuryuelyakh-Sis RU T ISL 4 0.11505529995286767 735548 ERR 1509416 Ostrov Bol’shoy RU T ISL 3 0.1024721573839491 733208 ERR 6049442 Langley Island CA T ISL 3 0.08513012568098889 779849 WRN 2760204 Schnauder Ø GL T ISL 4 0.08124105762304326 14810 WRN 1633369 Pulau Padangtikar ID T ISL 5 0.08114586120504566 687922 WRN 2660406 Haslital CH T VAL 5 0.07248889285711937 289487 WRN 3396062 Ilha dos Macacos BR T ISL 5 0.07148004920816782 722015 WRN 6632964 Farmer Island AQ T ISL 3 0.07116626467100153 7037 WRN 1505487 Ostrov Isachenko RU T ISL 3 0.05583117572742744 3534 WRN 1544217 Ostrov Bol’shoy Zelënyy RU T ISL 3 0.05437810318584396 733755 WRN 11961494 Ile d'Eguèye SN T ISL 3 0.05417163182863753 716586 WRN 3420094 Saqqarliit GL T ISL 6 0.05291732806994346 26734 WRN 3397613 Ilha Japichaua BR T ISL 5 0.0508691539349797 721966 WRN 3420424 Qorsunnitsoq GL T ISL 5 0.050804726429364455 26735 WRN 5947843 Ellice Island CA T ISL 3 0.04988585967697777 779903 WRN 1650742 Pulau Baika ID T ISL 5 0.04926247944535625 13152 WRN 3421386 Nunarsuit GL T ISL 5 0.04475908430816594 18765 WRN 1151249 Ko Phuket TH T ISL 6 0.04286513602169218 25349 WRN 2102122 Vangunu Island SB T ISL 5 0.04209795875571432 26316 WRN 5969543 Halliq Island CA T ISL 3 0.041311856154344004 16458 WRN 3394042 Ilha Mututi BR T ISL 5 0.040502201559656524 721882 WRN 1495178 Ostrov Pestsovyy RU T ISL 4 0.040257816453241904 3479 WRN 3876354 Isla Piazzi CL T ISL 3 0.039572186954452866 6078 WRN 3868278 Isla Vidal Gormaz CL T ISL 4 0.038844413634880275 24992 WRN 1501728 Ostrov Kruglyy RU T ISL 3 0.03854792648681595 24701 WRN 3876887 Isla Pedro Montt CL T ISL 3 0.03796598693039591 24997 WRN 1213573 Pulau Tanahbala ID T ISL 5 0.036411438149503345 8132 WRN 3419165 Tunertooq GL T ISL 5 0.034929373503392765 17211 WRN 1641508 Pulau Kangean ID T ISL 5 0.0349289746854401 25488 WRN 6114686 Qikiqtarjuaq Island CA T ISL 3 0.034757136887862215 26707 WRN 2661640 Val de Bagnes CH T VAL 3 0.034740077450543735 289166 WRN 3393128 Ilha do Pará BR T ISL 5 0.034683690674176856 721730 WRN 1489176 Ostrov Troynoy RU T ISL 4 0.03465525701417099 3630 WRN 1500459 Ostrov Litke RU T ISL 5 0.0345774163894517 3266 WRN 2026356 Ostrov Bol’shoy RU T ISL 3 0.03383751667490631 3712 WRN 550935 Ostrov Ketlitsa RU T ISL 6 0.033768498851227874 1657 WRN 3401172 Ilha Curumu BR T ISL 4 0.033450555482442135 721844 WRN 3421165 Pamialluk GL T ISL 5 0.03271834753505518 24047 WRN 3395499 Ilha de Maracá BR T ISL 4 0.032543293604924826 4510 WRN 3419099 Tuttutooq GL T ISL 6 0.031633152643172874 747063 WRN 3419971 Sermersuut GL T ISL 5 0.03152621282876685 17306 WRN 3420380 Qunnerit GL T ISL 5 0.0313092427716583 24010 WRN 3868611 Isla Van der Meulen CL T ISL 4 0.031180206705867353 5717 WRN 3879072 Isla Nalcayec CL T ISL 3 0.030958330737364113 450604 WRN 2018070 Ostrov Pegas-Ary RU T ISL 4 0.03051143201057382 734284 WRN 1636456 Pulau Mandul ID T ISL 5 0.030216270615857715 687962 WRN