number of errors=103
number of warnings=0
Group=chkGrpHierarchy
select p.countrycode,p.admincode1,p.name,p.geonameid,p.featurecode,c.geonameid,c.featurecode,geoname_hierarchy.creationtime,geoname_hierarchy.createdbyuserid,geoname_hierarchy.type,st_distance(ST_GeographyFromText('Point(' || p.longlat[0] || ' ' || p.longlat[1] || ')'),ST_GeographyFromText('Point(' || c.longlat[0] || ' ' || c.longlat[1] || ')'))::int as dist_m from geoname p,geoname c, geoname_hierarchy where p.geonameid=parentid and c.geonameid=childid and p.name=c.name and p.featureclass=c.featureclass order by 1,2
countrycode admincode1 name geonameid featurecode geonameid featurecode creationtime createdbyuserid type dist_m AF 26 Kalafgān 1138657 PPLA2 1467682 PPLX 2014-06-09 17:16:49.330379 null null 1583 AF 26 Kalafgān 1138657 PPLA2 1467683 PPLX 2014-06-09 17:16:49.330379 null null 2170 AF 26 Kalafgān 1138657 PPLA2 1467680 PPLX 2014-06-09 17:16:49.330379 null null 909 AF 30 Barmazit 1146870 PPL 1146869 PPLX 2014-06-09 17:16:49.330379 null null 1781 AF 30 Sulţān Ḩājī Walī 1405925 PPL 1124237 PPLX 2018-04-30 22:24:47.265339 null null 2285 AF 30 Barmazit 1146870 PPL 1146868 PPLX 2014-06-09 17:16:49.330379 null null 2510 AF 31 Qarqīn 1129516 PPLA2 1425684 PPLX 2014-06-09 17:16:49.330379 null null 3142 AF 31 Qarqīn 1129516 PPLA2 1475088 PPLX 2014-06-09 17:16:49.330379 null null 1878 AF 31 Qarqīn 1129516 PPLA2 1143079 PPLX 2014-06-09 17:16:49.330379 null null 6655 AT 03 Brunn am Gebirge 2781321 PPLA3 2601250 PPLX 2014-06-09 17:16:49.330379 null null 1695 AU 02 Ferodale 11238479 PPL 2166742 PPLX 2018-04-30 22:24:47.265339 null null 5530 AU 04 Spring Bluff 2148765 PPL 10114329 PPLX 2018-04-30 22:24:47.265339 null null 1411 BG 38 Ribnik 727635 PPL 727634 PPLX null null null 735 BG 50 Komarevo 730212 PPL 725256 PPLX null null null 336 BG 57 Byala Reka 732713 PPL 732709 PPLX null null null 1841 BG 63 Inovo 730892 PPL 727026 PPLX null null null 164 BG 63 Dunavtsi 731809 PPL 725912 PPLX null null null 986 BY 03 Parechcha 623205 PPL 8076654 PPLX 2018-04-30 22:24:47.265339 null null 2236 BY 06 Paluzh 623826 PPL 623825 PPL null null null 1323 BY 06 Belynichi 630245 PPLA2 621818 PPLX 2014-06-09 17:16:49.330379 null null 1334 CA 08 Bar River 5894257 PPL 11186271 PPLX 2018-04-30 22:24:47.265339 null null 3152 CA 10 Lachenaie 6325515 PPL 6024236 PPLX 2014-06-09 17:16:49.330379 null null 1593 CO 29 La Dolores 3778839 PPL 3778727 PPLX 2018-04-30 22:24:47.265339 null null 666 DK 21 Bøjden 2623765 PPL 3223195 PPL null null null 706 FI 01 Brissas 840623 PPL 7521727 PPLX 2014-06-09 17:16:49.330379 null null 134 FI 02 Stora Ormskär 848110 ISL 10073035 ISL 2021-04-07 12:56:37.483737 272368 24 FI 15 Ristinummi 7779093 PPL 842875 PPLX null null null 431 FI 15 Karperö 653920 PPLX 7779092 PPLX 2014-06-09 17:16:49.330379 null null 253 IR 07 Kheyrātlī 125121 PPLX 7451215 PPLX 2014-06-09 17:16:49.330379 null null 501 IR 07 Mehdīābād 128409 PPLX 6680614 PPLX null null null 190 IR 08 Kāh Chāh 11076067 PPL 129875 PPLX 2018-04-30 22:24:47.265339 null null 827 IR 08 Pāshkam 6758040 PPL 6758047 PPLX 2018-04-30 22:24:47.265339 null null 561 IR 35 Shahrak-e Īzad Shahr 7637486 PPL 130698 PPLX 2018-04-30 22:24:47.265339 null null 27 IR 40 Allāhābād 143823 PPL 2533 PPLX 2014-06-09 17:16:49.330379 null null 105 JP 12 Shikabe 2128180 PPL 11776769 PPLX 2018-04-30 22:24:47.265339 null null 6345 JP 17 Sakaidechō 1853190 PPLA2 1853188 PPLX null null null 1489 JP 32 Tsurumachi 1863977 PPL 1849575 PPLX null null null 836 KG 03 Tësh 8137715 PPL 11133600 PPLX 2018-04-30 22:24:47.265339 null null 3943 KH 29 Kamrieng 1831103 PPL 11320734 PPLX 2018-04-30 22:24:47.265339 null null 550 KR 15 Neungseongdong 1900632 PPL 1840112 PPLX 2018-04-30 22:24:47.265339 null null 524 KZ 03 Zavodskoy 1537947 PPL 10838448 PPLX 2018-04-30 22:24:47.265339 null null 3559 KZ 03 Makinsk 1521230 PPLA2 11149644 PPLX 2018-04-30 22:24:47.265339 null null 3796 KZ 03 Nikol’skoye 1520688 PPL 11149731 PPLX 2018-04-30 22:24:47.265339 null null 3531 KZ 12 Senokosnoye 1519401 PPL 11473176 PPLX 2018-04-30 22:24:47.265339 null null 3368 KZ 12 Aktau 1526269 PPL 11452134 PPLX 2018-04-30 22:24:47.265339 null null 3436 LU RM Bech-Kleinmacher 3283390 PPL 2960808 PPL null null null 319 LV 05 Cēsis 460570 PPLA 456679 PPLX 2018-04-30 22:24:47.265339 null null 3022 MA 03 Douar Ait Taleb 2553033 PPL 8542731 PPLX 2014-06-09 17:16:49.330379 null null 74 MA 09 Azrou 10375056 PPL 10375123 PPLX 2018-04-30 22:24:47.265339 null null 571 MK 35 Gradsko 790217 PPLA 863700 PPLX 2014-06-09 17:16:49.330379 null null 1739 MX 05 Las Tejerías 11618851 PPL 11619052 PPLX 2018-04-30 22:24:47.265339 null null 249 MX 15 Emiliano Zapata 3827603 PPL 3817972 PPLX 2018-04-30 22:24:47.265339 null null 294 MX 19 Santa Isabel 11414125 PPL 11414308 PPLX 2018-04-30 22:24:47.265339 null null 896 MX 21 Atlixco 3532592 PPL 11095706 PPLX 2018-04-30 22:24:47.265339 null null 2705 MX 21 Lomas de San Alfonso 11077353 PPL 11076981 PPLX 2018-04-30 22:24:47.265339 null null 263 MX 21 San Francisco Acatepec 3533456 PPL 11076820 PPLX 2018-04-30 22:24:47.265339 null null 260 MX 21 Xalpatlaco 11095557 PPL 11095721 PPLX 2018-04-30 22:24:47.265339 null null 371 MX 21 Las Lilas 11095517 PPL 11095755 PPLX 2018-04-30 22:24:47.265339 null null 93 MX 22 La Paz 11410961 PPL 11411336 PPLX 2018-04-30 22:24:47.265339 null null 395 MX 26 Brisas del Valle 11272050 PPL 11272094 PPLX 2018-04-30 22:24:47.265339 null null 891 MX 27 Ignacio Zaragoza 3802783 PPL 11425287 PPLX 2018-04-30 22:24:47.265339 null null 843 MX 30 La Posta 11583941 PPL 11584077 PPLX 2018-04-30 22:24:47.265339 null null 633 NZ G2 Porirua 2184397 PPL 6244950 PPLW null null null 3003 OM 01 Abū Nukhaylah 11835131 PPL 11832194 PPLX 2018-04-30 22:24:47.265339 null null 4428 PE 15 Santa Rosa 3929139 PPLA3 9891742 PPLX 2018-04-30 22:24:47.265339 null null 2641 PH 07 Catarman 1717928 PPL 11258481 PPLX 2018-04-30 22:24:47.265339 null null 467 PK 03 Shera Ghund 1384941 PPL 10237371 PPLX 2018-04-30 22:24:47.265339 null null 266 PK 08 Bakra 1182334 PPL 7038478 PPLX 2010-07-11 10:44:16.031662 null null 1012 RU 10 Andreykovichi 581901 PPL 530228 PPL null null null 807 RU 22 Mayskiy 528248 PPLA2 874042 PPL 2010-07-11 10:44:16.031662 null null 46 RU 38 Krymsk 540251 PPLA2 866298 PPLX null null null 623 RU 42 Zamosh’ye 465068 PPL 573146 PPL null null null 893 RU 59 Lutkovka 2020655 PPLX 6608003 PPLX null null null 1146 RU 60 Gan’kovo 7079991 PPL 7079994 PPLX 2018-04-30 22:24:47.265339 null null 901 RU 68 Koban 547044 PPL 520596 PPL null null null 2675 TR 31 Samandağ 301975 PPLA2 6692069 PPLX 2010-07-11 10:44:16.031662 null null 1083 TR 48 Ovacık 303127 PPL 314297 PPLX 2018-04-30 22:24:47.265339 null null 673 UA 02 Zhadove 687253 PPL 687251 PPL null null null 1771 UA 05 Mariupol 701822 PPL 9529598 PPLX 2018-04-30 22:24:47.265339 null null 11777 UA 11 Privetnoye 696239 PPLA3 692321 PPLX 2018-04-30 22:24:47.265339 null null 93 UA 13 Petropavlivska Borshchahivka 697418 PPL 6284998 PPLX null null null 592 UA 24 Stara Lishnia 692886 PPL 702973 PPLX null null null 349 UA 27 Cholivka 710870 PPL 873887 PPLX null null null 551 US CA Roosevelt 5388662 PPL 9958188 PPLX 2018-04-30 22:24:47.265339 null null 1120 US IL Union 4914267 PPL 7909997 PPLX 2018-04-30 22:24:47.265339 null null 1384 UY 09 Playa Verde 3441064 PPL 10098415 PPLX 2018-04-30 22:24:47.265339 null null 1020 UZ 01 Andijon 1514588 PPLA 11205691 PPLX 2018-04-30 22:24:47.265339 null null 8426 UZ 01 Asaka 1513271 PPLA2 11003002 PPLX 2018-04-30 22:24:47.265339 null null 4176 UZ 01 Sovay 11229828 PPL 11229829 PPLX 2018-04-30 22:24:47.265339 null null 1430 UZ 01 Oxunboboyev 8163769 PPL 11229554 PPLX 2018-04-30 22:24:47.265339 null null 1318 UZ 01 Lo‘g‘umbek 1513265 PPL 8149314 PPLX 2018-04-30 22:24:47.265339 null null 1488 UZ 01 Otchopar 8149609 PPL 11229278 PPLX 2018-04-30 22:24:47.265339 null null 3401 UZ 03 Jaloyir 1514110 PPL 11056896 PPLX 2018-04-30 22:24:47.265339 null null 1074 UZ 03 Bahrin 11057381 PPL 11057431 PPLX 2018-04-30 22:24:47.265339 null null 1091 UZ 03 Karimbobo 1513719 PPL 11056979 PPLX 2018-04-30 22:24:47.265339 null null 1253 UZ 03 Mehnatobod 11056903 PPL 11056918 PPLX 2018-04-30 22:24:47.265339 null null 3835 UZ 03 Shoberdi 10646193 PPL 10646192 PPLX 2018-04-30 22:24:47.265339 null null 3801 UZ 03 Yoyilma 11056855 PPL 11056897 PPLX 2018-04-30 22:24:47.265339 null null 2881 UZ 06 Madyorovul 7537358 PPL 11057235 PPLX 2018-04-30 22:24:47.265339 null null 3763 UZ 12 Tol-Tugay 1215944 PPL 1215943 PPLX 2018-04-30 22:24:47.265339 null null 1712 VE 20 La Curva 3759066 PPL 3795112 PPLX null null null 389 VE 20 Piesalon 3758863 PPL 3795439 PPLX null null null 493 ZA 03 Hlohlolwane 1013266 PPL 11239102 PPLX 2018-04-30 22:24:47.265339 null null 3020