Re: [postgis-users] Extract points from multipoint geometries

2010-05-11 Thread strk
On Mon, May 10, 2010 at 11:32:32AM -0400, Charles Galpin wrote: ST_PointN doesn't work for multipoints, ST_GeometryN does. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing

Re: [postgis-users] Extract points from multipoint geometries

2010-05-11 Thread Charles Galpin
Even better, thanks! On May 11, 2010, at 3:15 AM, strk wrote: On Mon, May 10, 2010 at 11:32:32AM -0400, Charles Galpin wrote: ST_PointN doesn't work for multipoints, ST_GeometryN does. --strk; () Free GIS Flash consultant/developer /\ http://strk.keybit.net/services.html

Re: [postgis-users] Extract points from multipoint geometries

2010-05-10 Thread Maxime van Noppen
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

Re: [postgis-users] Extract points from multipoint geometries

2010-05-10 Thread 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