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 answers
Related Questions in GEOSPATIAL
- Estimating distance between points and its relative elevation for multiple countries and geometries, using R sf
- Folium Timestampedgeojson - How to add dynamic html for the title of the map
- Convert lat,lon,data points to matrix (2D grid) at 0.5 degree resolution in Python
- Having trouble merging these two datasets for a Spatial Analysis
- How to extract vineyard land cover from CORINE in R?
- find point in inside polygon ..with mysql
- map distance in pixels to meters
- Efficiently Turn Matrix of Intersecting Routes Into Simplified Spatial Network (Graph)
- Oracle SDO_INTERSECTION returning null where an intersection exists in SRID 4326
- Plotting data on shapefile with the same CRS, but things are not lining up as I would expect
- get the band with the maximum value from a xarray stack
- Can spatial features be used as an input for a machine learning model?
- Make SpatRaster from sf point object
- Apache Sedona Version Issues
- MemoryError: Unable to allocate 19.1 GiB for an array with shape (52199, 49069) and data type int64
Related Questions in POLYGON
- How can i show the layer like polygon cover all marker in mapbox
- Rotate a multipolygon without changing the inner spatial relation
- fabric.js reset polygon bounding box after a point is moved
- How do I find the line segments formed by the meeting of two sides of two polygons?
- Draw polygon next to an another one
- cannot import name 'RESTClient' from 'polygon'
- Edited polygon not showing up after saving changes in Google Maps API
- Given a convex polygon as a set of edges how to fill the area inside depending on the distance to the closest edge
- Distribution of n number of equi-distant point in polygon
- Subtracting polygons and converting them to not have holes in python
- Algorithm to convert SVG path to CSS clip path polygon
- Update a polygon that have intersections in two or more polygons
- SVG Coordinates not working with % values
- Drawing and editing geofence using @react-google-maps/api
- "QGIS: Displaying labels outside polygons for line features inside using field values"
Related Questions in POSTGIS
- Connecting to Postgres running in a Docker container using psql
- Publishing PostGIS-Raster Using Mapserver
- PostgreSQL: Speed Up Updating a Column using Aggregate Value from Another Column
- Getting inner holes in a multipolygon using PostGis
- How to select all groups of intersecting polygons from a single table using PostGIS
- Polygon overlap queries very slow
- North/South/East/West coordinate in postgis to use with st_contains
- Prepopulating PostGIS with OSM data works with Docker Desktop, but not with Azure pipeline
- TypeORM/NestJS "type "geography" does not exist" when running tests
- Failure to retrieve PostGIS Geometry with Go `orb` and `wkb`
- Defining a unique key on a PostGIS table
- fill psql db -> current transaction is aborted, commands ignored until end of transaction block
- Postgresql: create index issue"Index row requires 23653 maximum size 8191" error 54000
- I have Shape Area and Shape Length of a polygon shapefile. How can I convert these to geometries in PostgreSQL?
- Optimising neighbour query in postgis
Related Questions in OGC
- geotools gaussian projection data source for WMS
- How to update 'Allow' headers in DRF to match an OPTIONS request's permissions?
- How to reposition CITYGML files?
- Is there an open-source option to convert CityGML and an ADE to tilesets?
- MapServer OGC API Setup
- MapServer (WMS) OAPIF connection - disable schema establishing
- Combining Openlayers, WM(T)S, and OGCAPI
- Geopandas: buffer with vector in 3D
- GeoServer Maven Build Plugin AuthKey Authentication
- WFS GetFeature request feature with lat/lng literal
- Java How to set new coordinates to a geometry in 2D
- Geoserver WMTS service in leaflet dont display tiles, columns is out of range
- OpenLayers very poor performance when WMTS getCapabilities TileMatrixSet does not list low zoom level TileMatrix's
- Geoserver - OGC API Features - API Definition
- OGC API Features and GeoServer
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?
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)
I figured it out myself: an
st_buffer(wkb_geometry,0)does the trick, at least on my sample data.