number of errors=174
number of warnings=0
Group=chkGrpBBox
select l.geonameid,l.countrycode,l.name,l.featurecode,p.geonameid,p.name,p.featurecode from geoname l,geoname p, geoname_bbox b where l.featurecode in ('ADM2','ADM3','ADM4','ADM5') and p.featurecode='ADM2' and l.countrycode=p.countrycode and l.admincode1=p.admincode1 and l.admincode2=p.admincode2 and p.geonameid=b.geonameid and (south>l.longlat[1] or l.longlat[1]>north or (west
[{key=AE,number=54}, {key=CN,number=35}, {key=VN,number=20}, {key=BG,number=16}, {key=PH,number=9}, {key=CD,number=8}, {key=FM,number=7}, {key=ID,number=5}, {key=CU,number=4}, {key=BJ,number=3}, {key=TW,number=3}, {key=US,number=2}, {key=CL,number=1}, {key=EC,number=1}, {key=GN,number=1}, {key=MA,number=1}, {key=MY,number=1}, {key=NP,number=1}, {key=SE,number=1}, {key=UG,number=1}]
geonameid countrycode name featurecode geonameid name featurecode
13060605 AE Marsa Dubai ADM3 13060552 Sector 3 ADM2
13060614 AE Oud Metha ADM3 13060552 Sector 3 ADM2
13060722 AE Al Thanyah Second ADM3 13060552 Sector 3 ADM2
13060647 AE Al Karama ADM3 13060552 Sector 3 ADM2
13060703 AE Al Satwa ADM3 13060552 Sector 3 ADM2
13060610 AE Al Hamriya ADM3 13060552 Sector 3 ADM2
13060700 AE Al Barsha Third ADM3 13060552 Sector 3 ADM2
13060654 AE Al Barsha Second ADM3 13060552 Sector 3 ADM2
13060766 AE Al Qouz Ind.Fourth ADM3 13060552 Sector 3 ADM2
13060615 AE Trade Center First ADM3 13060552 Sector 3 ADM2
13060606 AE Al Manara ADM3 13060552 Sector 3 ADM2
13060603 AE Al Qouz Ind.Second ADM3 13060552 Sector 3 ADM2
13060661 AE Al Bada' ADM3 13060552 Sector 3 ADM2
13060663 AE Al Jadaf ADM3 13060552 Sector 3 ADM2
13060595 AE Al Thanyah Fourth ADM3 13060552 Sector 3 ADM2
13060664 AE Al Barsha First ADM3 13060552 Sector 3 ADM2
13060665 AE Al Safa First ADM3 13060552 Sector 3 ADM2
13060690 AE Trade Center Second ADM3 13060552 Sector 3 ADM2
13060772 AE Umm Suqeim First ADM3 13060552 Sector 3 ADM2
13060696 AE Al Merkadh ADM3 13060552 Sector 3 ADM2
13060695 AE Zaa'Beel Second ADM3 13060552 Sector 3 ADM2
13060601 AE Al Qouz Ind.First ADM3 13060552 Sector 3 ADM2
13060593 AE Al Shindagha ADM3 13060552 Sector 3 ADM2
13060671 AE Burj Khalifa ADM3 13060552 Sector 3 ADM2
13060739 AE Jumeira Second ADM3 13060552 Sector 3 ADM2
13060645 AE Al Qouz Third ADM3 13060552 Sector 3 ADM2
13060740 AE Al Thanyah First ADM3 13060552 Sector 3 ADM2
13060680 AE Al Safa Second ADM3 13060552 Sector 3 ADM2
13060749 AE Jumeira First ADM3 13060552 Sector 3 ADM2
13060681 AE Al Wasl ADM3 13060552 Sector 3 ADM2
13060752 AE Jumeira Bay ADM3 13060552 Sector 3 ADM2
13060685 AE Umm Suqeim Third ADM3 13060552 Sector 3 ADM2
13060588 AE Umm Suqeim Second ADM3 13060552 Sector 3 ADM2
13060675 AE Business Bay ADM3 13060552 Sector 3 ADM2
13060628 AE Al Qouz First ADM3 13060552 Sector 3 ADM2
13060717 AE Al Thanyah Third ADM3 13060552 Sector 3 ADM2
13060713 AE Al Safouh Second ADM3 13060552 Sector 3 ADM2
13060715 AE Al Safouh First ADM3 13060552 Sector 3 ADM2
13060736 AE Al Raffa ADM3 13060552 Sector 3 ADM2
13060759 AE Madinat Dubai Al Melaheyah ADM3 13060552 Sector 3 ADM2
13060559 AE Umm Al Sheif ADM3 13060552 Sector 3 ADM2
13060734 AE Ghadeer Al Tair ADM3 13060552 Sector 3 ADM2
13060733 AE Al Souq Al Kabeer ADM3 13060552 Sector 3 ADM2
13060567 AE Al Kifaf ADM3 13060552 Sector 3 ADM2
13060721 AE Al Qouz Fourth ADM3 13060552 Sector 3 ADM2
13060618 AE Mankhool ADM3 13060552 Sector 3 ADM2
13060623 AE Zaa'Beel First ADM3 13060552 Sector 3 ADM2
13060625 AE Nakhlat Jumeira ADM3 13060552 Sector 3 ADM2
13060774 AE Al Hudaiba ADM3 13060552 Sector 3 ADM2
13060720 AE Al Thanyah Fifth ADM3 13060552 Sector 3 ADM2
13060726 AE Umm Hurair First ADM3 13060552 Sector 3 ADM2
13060775 AE Al Qouz Ind.Third ADM3 13060552 Sector 3 ADM2
13060711 AE Umm Hurair Second ADM3 13060552 Sector 3 ADM2
13060730 AE Al Jafiliya ADM3 13060552 Sector 3 ADM2
6460495 BG Vidno ADM3 730517 Obshtina Kavarna ADM2
6459440 BG Stalevo ADM3 732262 Obshtina Dimitrovgrad ADM2
6459753 BG Sracimir ADM3 727220 Obshtina Silistra ADM2
6460643 BG Rabrovo ADM3 732972 Obshtina Boynitsa ADM2
6460477 BG Metodievo ADM3 864565 Obshtina Dobrich-Selska ADM2
6460914 BG Dolno Prakhovo ADM3 733637 Obshtina Ardino ADM2
6461037 BG Volovarci ADM3 729792 Obshtina Kardzhali ADM2
6459973 BG Calapica ADM3 864567 Obshtina Rodopi ADM2
6460003 BG Joakim Gruevo ADM3 864570 Obshtina Stamboliyski ADM2
6460769 BG Pravenci ADM3 728733 Obshtina Novi Pazar ADM2
6459757 BG Dobrotica ADM3 727174 Obshtina Sitovo ADM2
6459853 BG Petrov dol ADM3 727919 Obshtina Provadia ADM2
6459688 BG Bel kamen ADM3 725585 Obshtina Yakoruda ADM2
6461146 BG Surnica ADM3 725987 Obshtina Velingrad ADM2
6461313 BG Ravninata ADM3 727551 Obshtina Rudozem ADM2
6459810 BG Dobrotich ADM3 725677 Obshtina Valchidol ADM2
11790142 BJ Adjarra I ADM3 8693304 Adjara ADM2
11790246 BJ Ségbeya ADM3 7668937 Commune of Kpomasse ADM2
11789921 BJ Passagon ADM3 7668931 Commune of Bohicon ADM2
2311125 CD Tshela ADM3 12278108 Luozi ADM2
2313364 CD Lukula ADM3 12278108 Luozi ADM2
2313001 CD Matadi ADM3 12278108 Luozi ADM2
2311549 CD Seke-Banza ADM3 12278108 Luozi ADM2
2311326 CD Songololo ADM3 12278020 Mbanza-Ngungu ADM2
2316700 CD Boma ADM3 12278030 Bangu ADM2
8260603 CD Moanda ADM3 12278030 Bangu ADM2
2313293 CD Luozi ADM3 12278020 Mbanza-Ngungu ADM2
8261467 CL Chilean Antarctic Territory ADM3 4036651 Provincia Antártica Chilena ADM2
1786585 CN Yingshang Xian ADM3 1793752 Suzhou Shi ADM2
1790409 CN Xianju Xian ADM3 1803243 Lishui Shi ADM2
1806884 CN Huichang Xian ADM3 1806430 Ji’an Shi ADM2
1804249 CN Ledu Xian ADM3 1788850 Xining Shi ADM2
8740492 CN Jiagedaqi District ADM3 2037961 Daxing’anling Diqu ADM2
6586361 CN Xindu ADM3 1795266 Shijiazhuang Shi ADM2
2035377 CN Qianxi Xian ADM3 1795266 Shijiazhuang Shi ADM2
1529307 CN Midong Qu ADM3 1529101 Urumqi Shi ADM2
1281486 CN Cona Xian ADM3 1280019 Shannan Diqu ADM2
1789055 CN Xing’an Xian ADM3 1790838 Wuzhou Shi ADM2
8649242 CN Xinmin ADM4 2038066 Chifeng Shi ADM2
8596168 CN Jinyintan ADM4 1786656 Yinchuan Shi ADM2
10252143 CN Yueyahu ADM4 1786656 Yinchuan Shi ADM2
8053971 CN Jiao Qu ADM3 1815461 Changzhi Shi ADM2
1807670 CN Huairen Xian ADM3 1805302 Jinzhong Shi ADM2
1815763 CN Changdao Xian ADM3 1787083 Yantai Shi ADM2
6573947 CN Shizhong Qu ADM3 1805517 Jining Shi ADM2
1788947 CN Xingping Shi ADM3 1791635 Weinan Shi ADM2
6571323 CN Lianjiang Qu ADM3 1784987 Zhanjiang Shi ADM2
1794783 CN Shou Xian ADM3 1807680 Huainan Shi ADM2
8051573 CN Songling Qu ADM3 2037961 Daxing’anling Diqu ADM2
8079496 CN Dushanzi Qu ADM3 1529400 Kelamayi Shi ADM2
1802705 CN Long’an Xian ADM3 1799866 Nanning Shi ADM2
1802429 CN Longsheng Gezu Zizhixian ADM3 1790838 Wuzhou Shi ADM2
6642194 CN Xixiu Qu ADM3 1817965 Anshun Shi ADM2
1815535 CN Changshun Xian ADM3 1798280 Qiannan Bouyeizu Miaozu Zizhizhou ADM2
1803447 CN Lingwu City ADM3 1786656 Yinchuan Shi ADM2
1281267 CN Fugong Xian ADM3 1281672 Baoshan Shi ADM2
1798864 CN Ping’an Xian ADM3 1788850 Xining Shi ADM2
1529353 CN Kuitun Shi ADM3 1529434 Yili ADM2
10031873 CN Qixingguan ADM3 1816372 Bijie Diqu ADM2
2037034 CN Hangjin Houqi ADM3 1806529 Ordos Shi ADM2
8648736 CN Manghatu ADM4 1786656 Yinchuan Shi ADM2
1792542 CN Tongxin Xian ADM3 1786512 Wuzhong Shi ADM2
11288134 CN Jingdong Yi Autonomous County ADM3 1803589 Lincang Shi ADM2
11287709 CU Municipio de Chambas ADM2 11287709 Municipio de Chambas ADM2
11288072 CU La Habana Del Este ADM2 11288072 La Habana Del Este ADM2
3537298 CU Santa María del Rosario ADM3 11288070 Cotorro ADM2
11288073 CU La Habana Vieja ADM2 11288073 La Habana Vieja ADM2
10793219 EC Manga del Cura ADM3 3658324 El Carmen ADM2
7626927 FM Nukuoro Municipality ADM2 7626927 Nukuoro Municipality ADM2
7626971 FM Namoluk Municipality ADM2 7626971 Namoluk Municipality ADM2
7626980 FM Polowat Municipality ADM2 7626980 Polowat Municipality ADM2
7626947 FM Lamotrek Municipality ADM2 7626947 Lamotrek Municipality ADM2
7626949 FM Ngulu Municipality ADM2 7626949 Ngulu Municipality ADM2
7626955 FM Ulithi Municipality ADM2 7626955 Ulithi Municipality ADM2
7626959 FM Ettal Municipality ADM2 7626959 Ettal Municipality ADM2
11185070 GN Doura ADM3 2418435 Kouroussa ADM2
6378835 ID Kecamatan Karanganyar ADM3 6792336 Kabupaten Pekalongan ADM2
7569562 ID Desa Tiwu Riwung ADM4 1636422 Kabupaten Manggarai ADM2
12490792 ID Desa Kampung Hilir ADM4 8740093 Kabupaten Natuna ADM2
12490778 ID Kelurahan Sungai Lekop ADM4 9849917 Kota Batam ADM2
7056912 ID Labuapi District ADM3 6984549 Kabupaten Sumbawa Barat ADM2
6546499 MA Almahbass ADM3 2595329 Assa-Zag ADM2
1735907 MY Julau ADM3 1735861 Bahagian Sarikei ADM2
12095563 NP Meringden ADM3 12095528 Taplejung ADM2
11950753 PH Barangobong ADM4 1711034 Province of Ilocos Norte ADM2
11898988 PH Magsaysay ADM4 1713986 Province of Eastern Samar ADM2
11815322 PH Los Cochinos ADM4 1726347 Province of Bataan ADM2
12068528 PH Lantawan ADM4 1707668 Province of Lanao del Norte ADM2
12068530 PH Mabuhay ADM4 1707668 Province of Lanao del Norte ADM2
12068531 PH Capocao ADM4 1707668 Province of Lanao del Norte ADM2
12068532 PH Cabongbongan ADM4 1707668 Province of Lanao del Norte ADM2
12068535 PH Tagulo ADM4 1707668 Province of Lanao del Norte ADM2
12068537 PH Kauswagan ADM4 1707668 Province of Lanao del Norte ADM2
8133388 SE Landskrona, del ADM3 2706766 Helsingborg ADM2
11703394 TW Xiaoqiu Village ADM4 1676511 Kinmen County ADM2
11703393 TW Daqiu Village ADM4 1676511 Kinmen County ADM2
11696328 TW Wuchiou Township ADM3 1676511 Kinmen County ADM2
8198091 UG Onyona ADM5 443331 Gulu District ADM2
7169342 US City of Atlantic Beach ADM3 4153840 Duval County ADM2
7174401 US City of Seabrook ADM3 4680335 Chambers County ADM2
8335962 VN Phường Mười Một ADM3 1904879 Quận Bảy ADM2
8550217 VN Xã Quảng Đại ADM3 1905224 Thành Phố Sầm Sơn ADM2
8550216 VN Xã Quảng Hùng ADM3 1905224 Thành Phố Sầm Sơn ADM2
8673287 VN Xã Tịnh Hòa ADM3 1905613 Thành Phố Quảng Ngãi ADM2
8673289 VN Xã Tịnh Kỳ ADM3 1905613 Thành Phố Quảng Ngãi ADM2
8673306 VN Xã Tịnh Ấn Tây ADM3 1905613 Thành Phố Quảng Ngãi ADM2
8673291 VN Xã Tịnh Khê ADM3 1905613 Thành Phố Quảng Ngãi ADM2
8673264 VN Xã Nghĩa Hà ADM3 1905613 Thành Phố Quảng Ngãi ADM2
8673292 VN Xã Tịnh Long ADM3 1905613 Thành Phố Quảng Ngãi ADM2
8564080 VN Xã Liêm Tiết ADM3 1905638 Thành Phố Phủ Lý ADM2
8673294 VN Xã Tịnh Thiện ADM3 1905613 Thành Phố Quảng Ngãi ADM2
9091512 VN Xã Tân Định ADM3 1566754 Tân Uyên ADM2
9091514 VN Xã Lạc An ADM3 1566754 Tân Uyên ADM2
9091516 VN Xã Thường Tân ADM3 1566754 Tân Uyên ADM2
9091515 VN Xã Đất Cuốc ADM3 1566754 Tân Uyên ADM2
8564070 VN Xã Đinh Xá ADM3 1905638 Thành Phố Phủ Lý ADM2
8673299 VN Xã Tịnh Ấn Đông ADM3 1905613 Thành Phố Quảng Ngãi ADM2
8673296 VN Xã Tịnh Châu ADM3 1905613 Thành Phố Quảng Ngãi ADM2
9091523 VN Phường Tân Phước Khánh ADM3 1905478 Thị Xã Tân Uyên ADM2
9091522 VN Phường Thái Hòa ADM3 1905478 Thị Xã Tân Uyên ADM2