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

lnglat coordinate column must equal geography column

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