Multipolygon From Multilinestring PostGis

المشرف العام

Administrator
طاقم الإدارة
I have been looking for a answer for days. I dont even know if its possible.

Tried:

ST_AsGeoJson(ST_MakePolygon(ST_transform(geom,4326))) ERROR: Shell is not a line

ST_Polygonize(ST_LineMerge(ST_transform(geom,4326))) This returns one big polygon with all the multilinestrings, but i want separated polygons.

Is it possible? if yes, how can i do this?Hope someone can help, thanks.

TABLE rede.redetotal_geo( circuit_id character varying(9), n_arvores bigint, km double precision, index double precision, geom geometry(MultiLineString,3857))(Multilinestring -> Polygon)



أكثر...
 
أعلى