How do I convert MULTIPOLYS into LINESTRINGS in PostGIS

Asked Oct 28 '13 at 11:39

Active Oct 28 '13 at 11:39

Viewed 1,081 times

I have a table with a geom column as a geometry(MULTIPOLYGON)

I would like to create an additional column of type geometry(LINESTRING)

How can I do this using a PostGIS Query?

I need to be able to use the linestring in Geoserver to style labels along the line.

asked Oct 28 '13 at 11:39

Mark Cupitt

Would this help? http://gis.stackexchange.com/questions/49950/mulitlinestring-to-linestring – Martin F Oct 28 '13 at 17:40
You could use ST_ExteriorRing. There is an example converting MULTIPOLYGONs to MULTILINESTRING. – travis Oct 28 '13 at 20:47

0 Answers0