2025-03-03     2025-03-04     2025-03-05

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