number of errors=50
number of warnings=0
Group=chkGrpShp
select geoname.name,geoname.geonameid,geoname.countrycode,geoname_shape.countrycode,geoname_shape.geoshapeid from geoname,geoname_shape where level=2 and geoname.featurecode='ADM1' and st_within(geography::geometry,wkb_geometry) and (geoname.countrycode<>geoname_shape.countrycode or geoname.admincode1<>geoname_shape.admincode1) order by geoname.countrycode
name geonameid countrycode countrycode geoshapeid Shaki city 828303 AZ AZ 262830 Xocalı Rayonu 148449 AZ AZ 262844 Shusha 409419 AZ AZ 262875 Yevlakh City 828307 AZ AZ 262852 Xankandi Sahari 409421 AZ AZ 262875 Lankaran Sahari 409418 AZ AZ 262873 Hamilton City 3573198 BM BM 426137 Commune de Bangui 2596686 CF CF 28092 Pointe-Noire 7280295 CG CG 27976 Brazzaville department 2572183 CG CG 27982 Arta Region 449265 DJ DJ 28129 Judea and Samaria Area 11821181 IL PS 81882 Alborz Province 7648907 IR IR 28493 Muḩāfaz̧at Mādabā 443123 JO JO 28613 Ajloun 443120 JO JO 28616 Jerash 443121 JO JO 28616 Muḩāfaz̧at al ‘Aqabah 443122 JO JO 28610 Osh City 10300944 KG KG 426325 Muḩāfaz̧at Mubārak al Kabīr 7733358 KW KW 27481 Ulytau Region 12510145 KZ KZ 28656 Jetisu Region 12510144 KZ KZ 28650 Shymkent 1537272 KZ KZ 28651 Xaisomboun Province 11395958 LA LA 28682 Mohafazat Liban-Nord 278297 LB LB 430175 Mohafazat Baalbek-Hermel 6201371 LB LB 28685 Mohafazat Aakkâr 6201370 LB LB 28686 River Gee County 2593120 LR LR 27486 Gbarpolu County 2593119 LR LR 28696 Dakhla-Oued Ed-Dahab 11281886 MA EH 27630 Raionul Dubăsari 618363 MD MD 430164 Zeta 12640530 ME ME 426527 Tuzi 12104729 ME ME 426527 Zrnovci 862958 MK MK 430184 Opština Aračinovo 863831 MK MK 426424 Taoudénit Region 12070575 ML ML 430187 Darhan-Uul Aymag 2055111 MN MN 28758 Orhon Aymag 2055113 MN MN 28763 Govĭ-Sumber 2055112 MN MN 28753 L-Imtarfa 8299723 MT MT 257247 Cidade de Maputo 1105845 MZ MZ 28860 Provincia de Lima 3936451 PE PE 27528 Hela 8521658 PG PG 29104 Jiwaka 8521660 PG PG 29112 West Kordofan State 408659 SD SD 430195 Région de Sédhiou 7303937 SN SN 27557 Région de Kaffrine 7303935 SN SN 29317 Ashgabat 162182 TM TM 426391 San Juan/Laventille 7521946 TT TT 426299 Sebastopol City 694422 UA UA 27604 Socotra 9645387 YE YE 57602