I have some spatial data (MapInfo files) that contains self-intersecting polygons. These cause problems in my processing, in particular I can't generate geometric unions in PostGIS. Is there an easy way to resolve the issue? I can deal with multi-polygons if that should be necessary.
How do I clean up self-intersecting polygons in a spatial database?
2k Views Asked by Peter Becker At
1
There are 1 best solutions below
Related Questions in GEOSPATIAL
- How to find 25 uniformly distributed documents in a geo bounding box?
- How to find polygon in geoJson saved in MongoDB
- mongodb shard geo documents
- Access to Geospatial Analytics service Dashbord in Bluemix HTTP 404
- MongoDB text search and geoWithin search
- How do I enter an "empty" POINT() geometry value into a MySQL field of type POINT?
- Radius Based Search on lat,lon in AWS CloudSearch
- doing a merge/mesh on two or more topojson features
- Elasticsearch geospatial search, problems with index setup
- Find Mongoid geospacial circles that contain a point
- $geoWithin with mongoDB aggregate causes BadValue bad geo query
- Getting Entity Framework to work with SQL Server geospatial indexes
- How can I interpolate a point along a line string using DbGeography?
- UnionAggregate on geometry datatype to fuse geometry
- How can I plot a georeferenced dataset in R?
Related Questions in POLYGON
- How can i add polygon on google maps IOS?
- Polygon shape margin in Java
- SVG simple animations
- Newbe help on getting from polygon shape file to Leaflet polygon
- creating polygons based on intersection
- R polygon: fill values >0 in a density plot
- CSS Container Wrap shaped Polygons
- position polygon accurately in Corona SDK? (relative to known vertices - issue is it creates it own centre
- Extracting polygon given coordinates from an image using OpenCV
- Draw arbitrary convex shape knowing the lengths of its sides
- Scale animation on polygon
- Get the mesh name from the selected vertex
- oracle spatial compute area of polgons inside a class of polygon group by polygon ID
- How can I create an internal spiral for a polygon?
- Drawing filled polygon with libGDX's earclippingtriangulator and PolygonSpriteBatch
Related Questions in POSTGIS
- Play Framework Unable to build entity manager factory when Working with PostGIS
- ST_SetSRID ST_Point PostGIS giving strange output
- Create a Geoserver layer with data from a Postgis SQL view with Python/gsconfig
- NoMethodError using activerecord_postgis_adapter
- Access PostGIS functions in PyCharm Database Navigator
- how to detect polygons within other (many) polygons in postgis
- iterate and write separately linestrings (generate_series)
- What is wrong with this ST_CONTAINS statement PostGIS - Find point in polygon
- Accurate Bounding Box From Geography Polygon
- Getting Postgis/JDBC to work with BoneCP in Spring
- How do you pass in timestamp variable into JDBC request for jmeter
- PostGIS only works with root user
- Symbol not found - POSTGIS on PostgreSQL 9.3.3 Mac OS X 10.10
- Cannot CREATE EXTENSION postgis, $libdir/postgis-2.1 not found
- Using psql options in npgsql
Related Questions in OGC
- How do I clean up self-intersecting polygons in a spatial database?
- How to determine what schema files (xsd) to include on my svcutil command line?
- How do i 'add web/service reference' to the following web service?
- Element or attribute do not match QName production
- why is proxy code Generated by svctuil so small?
- Good tool for analyzing a request log for an OGC service like a WMS or WFS service
- Geoserver WMTS service in leaflet dont display tiles, columns is out of range
- Combining two simple SQL Server queries takes long running time
- Data at the root level is invalid. Line 1, position 1 on valid in memory xml
- Combining Openlayers, WM(T)S, and OGCAPI
- what have I done wrong when implementing Leaflet draw. How to use WFST in this specific example?
- Create, Update and Delete operations in pygeoapi
- Geopandas: buffer with vector in 3D
- Distance Algorithm used in SQL2008 for Geography Data Types
- Jaxb for OGC Schemas
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I figured it out myself: an
st_buffer(wkb_geometry,0)does the trick, at least on my sample data.