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