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

valid geometry for country shape, fix with st_makevalid()

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

select geoshapeid,countrycode,source,sourceid,ST_isValidReason(wkb_geometry) as reason,st_geometrytype(wkb_geometry) from geoname_shape where level=1 and not st_isvalid(wkb_geometry) order by countrycode

Self-intersection at or near point: find with SELECT geoshapeid,ST_isValidReason(wkb_geometry) from geoname_shape where NOT ST_isValid(wkb_geometry) 
fix with ST_Buffer(foo.the_geom,0.0)

geoshapeid	countrycode	source	sourceid	reason	st_geometrytype