Skip to main content
Geographic Information Systems

Return to Question

Tweeted twitter.com/StackGIS/status/1436977887370940417
edited body; edited tags; edited title
Source Link
Taras ♦
Taras ♦
  • 34.1k
  • 4
  • 73
  • 148

How do I convert Converting from a MultiPolygon to Polygon in PostGIS?

I have a table in PostgisPostGIS, where the data is currently stored as a MultiPolygon. Each Multipolygon has only a single Polygon in it.

How do I query and get the containing Polygon, and not MultiPolygon? I am ok ignoring the Edge case where there are Multiple Polygons in the Multi-Polygon Geometry. All I need is the first or only Polygon in that Geometry.

How do I convert from a MultiPolygon to Polygon in PostGIS?

I have a table in Postgis, where the data is currently stored as a MultiPolygon. Each Multipolygon has only a single Polygon in it.

How do I query and get the containing Polygon, and not MultiPolygon? I am ok ignoring the Edge case where there are Multiple Polygons in the Multi-Polygon Geometry. All I need is the first or only Polygon in that Geometry.

Converting from MultiPolygon to Polygon in PostGIS

I have a table in PostGIS, where the data is currently stored as a MultiPolygon. Each Multipolygon has only a single Polygon in it.

How do I query and get the containing Polygon, and not MultiPolygon? I am ok ignoring the Edge case where there are Multiple Polygons in the Multi-Polygon Geometry. All I need is the first or only Polygon in that Geometry.

Source Link
Devdatta Tengshe
Devdatta Tengshe
  • 41.6k
  • 35
  • 144
  • 263

How do I convert from a MultiPolygon to Polygon in PostGIS?

I have a table in Postgis, where the data is currently stored as a MultiPolygon. Each Multipolygon has only a single Polygon in it.

How do I query and get the containing Polygon, and not MultiPolygon? I am ok ignoring the Edge case where there are Multiple Polygons in the Multi-Polygon Geometry. All I need is the first or only Polygon in that Geometry.