[postgis-users] ST_StartPoint() for MultiLineStrings

Martin Davis mtnclimb at telus.net
Thu Sep 27 08:06:38 PDT 2012


In which case why not just extend ST_StartPoint to include this 
behaviour?  Always nicer to keep the function list as short as possible.

On 9/27/2012 7:31 AM, David William Bitner wrote:
> Perhaps to match a number of people's expectations, there should be an 
> ST_First Point() that is basically 
> ST_StartPoint(ST_GeometryN(ST_Multi(geometry),1))
>
>
>
> On Tue, Sep 25, 2012 at 4:08 PM, Paul Ramsey <pramsey at opengeo.org 
> <mailto:pramsey at opengeo.org>> wrote:
>
>     When ST_NumGeometries == 1, you can run ST_StartPoint on
>     ST_GeometryN(geom,1). Where ST_NumGeometries > 1 you are in
>     "interpretation land". What's the start point of a geometry with two
>     lines?
>
>     P.
>
>     On Tue, Sep 25, 2012 at 1:38 PM, David Quinn
>     <daithiquinn at gmail.com <mailto:daithiquinn at gmail.com>> wrote:
>     > As ST_StartPoint( multilinestring ) returns NULL for PostGIS 2.0
>     > (http://postgis.refractions.net/docs/ST_StartPoint.html ), what
>     > approach can be used to identify the start and end points of a
>     > multilinestring?
>     >
>     > Thanks,
>     > David
>     > _______________________________________________
>     > postgis-users mailing list
>     > postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     > http://postgis.refractions.net/mailman/listinfo/postgis-users
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
> -- 
> ************************************
> David William Bitner
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2012.0.2221 / Virus Database: 2441/5293 - Release Date: 09/26/12
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120927/b5932eb7/attachment.html>


More information about the postgis-users mailing list