arcgis多面体数据转面,PostGIS-将多面转换为单面

最新推荐文章于 2024-08-09 12:32:30 发布

媒小匣

最新推荐文章于 2024-08-09 12:32:30 发布

阅读量930

点赞数

文章标签： arcgis多面体数据转面

在PostGIS中，可以使用ST_GeometryN与ST_NumGeometries及generate_series函数将包含多面体的形状文件转换为单个面。通过这个方法，可以从多面体几何中提取单独的面。示例中创建了一个包含多面体的表，并展示了如何通过这些函数拆分多面体，保留其他属性不变，得到单个面的几何数据。

摘要由CSDN通过智能技术生成

Is it possible to import a shape file containing multipolygons into single polygon in PostGIS? Whenever I try importing a shape file of a polygon, it is stored as a multipolygon (as opposed to a single polygon) in a geom column. Thus, I am unable to extract it as a single polygon value from the multipolygon.

All helpful suggestions much appreciated

解决方案

You can use ST_GeometryN together with ST_NumGeometries and the generate_series function to obtain what you need.

Let's assume you have the table from Jakub's example:

CREATE TABLE multi AS(

SELECT 1 as id, 2 as test, ST_GeomFromText('MULTIPOLYGON(((0 0,4 0,4 4,0 4,0 0)),((1 1,2 1,2 2,1 2,1 1)), ((-1 -1,-1 -2,-2 -2,-2 -1,-1 -1)))') AS geom

);

This one contains a multipolygon, an id and another column.

To get each single polygon from the table including all other