[postgis-users] ST_StartPoint() for MultiLineStrings

Sandro Santilli strk at keybit.net
Tue Oct 2 15:07:49 PDT 2012


I'd rather keep it as it is, or even have it throw an exception.
If you want all endpoints use ST_Boundary (which should be extended
to support boundary node rule, btw).

I was also thinking that ST_StartPoint could probably be improved
to avoid full detoasting of the geometry...

--strk;

On Thu, Sep 27, 2012 at 08:06:38AM -0700, Martin Davis wrote:
> 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
> >
> 

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list