number of errors=5
number of warnings=0
Group=chkGrpShp
select geoshapeid,countrycode,source,sourceid,ST_isValidReason(wkb_geometry) as reason from geoname_shape where level<0 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 858860 null hydrosheds 434 Ring Self-intersection[-60.010534627 53.7608409540001] 858867 null hydrosheds 434 Ring Self-intersection[91.0077777777786 30.7802777777775] 858944 null hydrosheds 434 Ring Self-intersection[122.754722222222 -29.3861111111107] 858954 null hydrosheds 434 Ring Self-intersection[36.0398611111112 0.695416666666745] 858958 null hydrosheds 434 Ring Self-intersection[141.431794637298 -6.81333445231098]