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

shape equal geoname shape where source is edit interface

number of errors=0
number of warnings=0
Group=chkGrpShp

select b.geoshapeid,b.countrycode,b.sourcegeoshapeid,a.modificationtime from geoname_shape a,geoname_shape b where a.geoshapeid=b.sourcegeoshapeid and not st_equals(a.wkb_geometry,b.wkb_geometry)

update geoname_shape set wkb_geometry=a.wkb_geometry from geoname_shape a where a.geoshapeid=geoname_shape.sourcegeoshapeid and not st_equals(a.wkb_geometry,geoname_shape.wkb_geometry);

geoshapeid	countrycode	sourcegeoshapeid	modificationtime