2025-02-28     2025-03-01     2025-03-02

timezoneid of ADM1 same as timezoneid in shape

number of errors=0
number of warnings=0
Group=chkGrpTimezone

select geoname.countrycode,geonameid,name,geoname.timezoneid,geoname_timezone.timezoneid,timezoneshapeid,sourcegeoshapeid from geoname,geoname_timezone where st_within(geoname.geography::geometry,wkb_geometry) and geoname.countrycode=geoname_timezone.countrycode and featurecode='ADM1' and geoname.timezoneid <> coalesce(geoname_timezone.timezoneid,'') and geoname.countrycode in (select distinct countrycode from geoname_timezone) and timezoneshapeid not in (65109) order by 1

countrycode	geonameid	name	timezoneid	timezoneid	timezoneshapeid	sourcegeoshapeid