number of errors=26
number of warnings=0
country=CO
select countrycode,name,geonameid,admincode1,admincode2,featureclass,featurecode,relevance from geoname where countrycode in ('CO') 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 ('CO')) order by relevance desc,admincode1,admincode2
countrycode name geonameid admincode1 admincode2 featureclass featurecode relevance CO Parque Nacional Natural Las Orquídeas 3793295 02 3666396 L PRK 5 CO Cerro Azul 3673989 09 76109 T MT 5 CO Vereda de San Pedro 3793154 16 3682109 L AREA 5 CO Merecure Parque Agroecológico 7909866 19 3671422 L PRK 5 CO Central Park 9257658 33 3673827 L PRK 5 CO Los Termales 3675892 02 3681369 P PPL 4 CO Isla Andagovia 3783857 11 3667960 T ISL 4 CO Caserío Las Brisas 3770606 29 19110 P PPL 4 CO Río Cali 3687923 29 3687926 H WTRC 4 CO Cerro La Tribuna 7630194 29 19110 T HLL 3 CO Cuchilla De Amozal 9257664 33 3668229 T RDGE 3 CO Quebrada Nahem 9256502 01 9172033 H RVN 1 CO Quebrada Pepe 3810033 26 3674641 H STMI 1 CO Quebrada Sonora 3779215 29 9172412 H RVN 1 CO Puerto Colombia 13415962 10 47707 P PPL 0 CO Cienagas de Tumarado 13416830 11 05837 H LK 0 CO El Barro 13427307 16 73024 P PPL 0 CO Los Mangos 13427312 16 73024 P PPL 0 CO El Paraiso 13427309 16 73024 P PPL 0 CO Mirador 13427310 16 73024 P PPL 0 CO El Diviso 13427315 16 73024 P PPL 0 CO Las Brisas 13427278 16 73483 P PPL 0 CO El Barro 13427304 16 73483 P PPL 0 CO Aposentos 13415201 28 25506 P PPL 0 CO Ingenio del Cauca 13415586 29 19455 P PPL 0 CO Páramo Cruz Verde 13412033 33 11001 T RDGE 0