number of errors=0
number of warnings=0
Group=chkGrpPostalCode
select countrycode,zip,placename,estlonglat from zip_code where estlonglat is not null and (geography is null or round(estlonglat[0]::numeric,5)!= round(st_x(geography::geometry)::numeric,5) or round(estlonglat[1]::numeric,5)!= round(st_y(geography::geometry)::numeric,5))
update zip_code set geography=st_GeomFromText('Point(' || estlonglat[0] || ' ' || estlonglat[1] || ')')::geography where estlonglat is not null and (geography is null or round(estlonglat[0]::numeric,5)!= round(st_x(geography::geometry)::numeric,5) or round(estlonglat[1]::numeric,5)!= round(st_y(geography::geometry)::numeric,5))
countrycode zip placename estlonglat