[postgis-users] Finding the min point point along an line and ST_Line_Substring

dave.potts at pinan.co.uk dave.potts at pinan.co.uk
Thu Mar 19 02:03:43 PDT 2015


Brilliant !

Thanks Mike
Dave.
> On 19 March 2015 at 21:10, <dave.potts at pinan.co.uk> wrote:
>> I have a line string  geometry,  I am trying to find the min point
>> between
>> the start and end point of this line
>>
>> Can I use st_Line_substring(foo,0.5,0.5) to return the min point ?
>>
>> Are there any pit falls I should be aware of ?
>
> You mean mid-point? It's more direct to use
> ST_Line_Interpolate_Point(foo, 0.5) to get a point geometry.
>
> I suppose be aware that in 2.1 this function was renamed to
> ST_LineInterpolatePoint.
>
> -Mike
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>




More information about the postgis-users mailing list