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

timezone geography not same area as geometry

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

select countrycode,timezoneid,st_area(wkb_geometry) as geometryarea,st_area(geography::geometry) as geographyarea,100*(@ st_area(wkb_geometry)-st_area(geography::geometry))/st_area(wkb_geometry) as pct,sourcegeoshapeid,timezoneshapeid from geoname_timezone where (@ st_area(wkb_geometry)-st_area(geography::geometry))/st_area(wkb_geometry) > 0.1 and st_area(wkb_geometry)>0.001 order by 1,5

fix with:
 update geoname_timezone set geography =ST_GeographyFromText(st_astext(st_multi(wkb_geometry))) where timezoneshapeid=0;

countrycode	timezoneid	geometryarea	geographyarea	pct	sourcegeoshapeid	timezoneshapeid