[postgis-users] Extract points from multipoint geometries

[Charles Galpin]

Thanks Maxime!

On May 10, 2010, at 11:47 AM, Maxime van Noppen wrote:

> On 05/10/2010 05:32 PM, Charles Galpin wrote:
>> I searched the archives and saw this asked in 2005 but it didn't appear to have a resolution then.  I have two points in a multipoint geometry which represent the start and end point of road segments that I need to extract the points back out of, but ST_PointN doesn't work for multipoints, nor can I convert the multipoint to a linestring with ST_MakeLine and use ST_PointN then on the resultant line (because it doesn't work on multipoint geometries either).
>> 
>> Does anyone know a way to do this?
> 
> Hi,
> 
> You can use the ST_Dump function.
> 
> http://postgis.refractions.net/docs/ST_Dump.html
> 
> -- 
> Maxime