How to get the Nth LineString from a MultiLineString in PostGIS?

Question

I need a way to get the Nth LineString from a MultiLineString in PostGIS / PostgreSQL, something like ST_PointN that gets the Nth point from a LineString.

score 4 · Accepted Answer · answered Dec 16 '11 at 19:07

4

PostGIS function:

ST_GeometryN(a_geom geometry, dimension int)

answered Dec 16 '11 at 19:07

Paco Valdez

1,915
14
26

How to get the Nth LineString from a MultiLineString in PostGIS?

1 Answers1