number of errors=18
number of warnings=0
Group=chkGrpTimezone
select geoname.countrycode,geonameid,name,geoname.population,geoname.featurecode,geoname.timezoneid,geoname_timezone.timezoneid from geoname full outer join geoname_timezone on st_dwithin(geoname.geography::geometry,wkb_geometry,0.1) and geoname.countrycode=geoname_timezone.countrycode where featurecode='ADM1' and geoname_timezone.timezoneid is null and geoname.countrycode in (select distinct countrycode from geoname_timezone) order by 1
countrycode geonameid name population featurecode timezoneid timezoneid IL 11821181 Judea and Samaria Area 491923 ADM1 Asia/Jerusalem null MA 11281886 Dakhla-Oued Ed-Dahab 142955 ADM1 Africa/Casablanca null MH 7303519 Jabat Island 95 ADM1 Pacific/Majuro null MH 7303510 Rongelap Atoll 19 ADM1 Pacific/Kwajalein null MH 7303499 Enewetak Atoll 853 ADM1 Pacific/Kwajalein null PF 4030621 Îles Tuamotu-Gambier 16267 ADM1 Pacific/Tahiti null PG 2087246 West Sepik Province 185741 ADM1 Pacific/Port_Moresby null PG 2097846 East Sepik Province 450530 ADM1 Pacific/Port_Moresby null SC 11876017 Outer Islands 574 ADM1 Indian/Mahe null TF 6690917 La Terre-Adélie 80 ADM1 Indian/Kerguelen null TF 936339 Archipel des Crozet 30 ADM1 Indian/Kerguelen null UM 4743755 Navassa Island 0 ADM1 Pacific/Midway null UM 5854926 Jarvis Island 0 ADM1 Pacific/Midway null UM 5854952 Palmyra Atoll 10 ADM1 Pacific/Midway null UM 5854922 Howland Island 0 ADM1 Pacific/Midway null UM 5854907 Baker Island 0 ADM1 Pacific/Midway null UM 5854936 Kingman Reef 0 ADM1 Pacific/Midway null VN 1904987 Ðắk Nông 737907 ADM1 Asia/Ho_Chi_Minh null