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