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

timezone shape equal geoname shape where source is edit interface

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

select timezoneid,geoname_timezone.countrycode,timezoneshapeid,geoname_timezone.sourcegeoshapeid from geoname_timezone,geoname_shape where geoshapeid=geoname_timezone.sourcegeoshapeid and not st_equals(geoname_timezone.wkb_geometry,geoname_shape.wkb_geometry)

fix with:
 update geoname_timezone set wkb_geometry=geoname_shape.wkb_geometry from geoname_shape where geoshapeid=geoname_timezone.sourcegeoshapeid and not st_equals(geoname_timezone.wkb_geometry,geoname_shape.wkb_geometry);

timezoneid	countrycode	timezoneshapeid	sourcegeoshapeid