[postgis-users] Point (x%) on a linestring

Paul Ramsey pramsey at refractions.net
Thu Aug 12 15:22:05 PDT 2004


One of the many under documented jewels...

   line_interpolate_point(geometry,float8)

Alex Martins Daher wrote:

> Hi all!
> 
> I have a multilinestring like this one:
> MULTILINESTRING((-51.4933730667105 -29.1662071724963,-51.4933280072013 -29.1666495955688))
> 
> And I want to know what is the point on the linestring that is x% from the start.
> For instance, the centroid of that geometry is 50% from the start.
> 
> Is there any function that can do that: I pass the geometry anda the percentage and returns
> the point (geometry) that is x% from the start.
> 
> I took a look at that docs but couldn't find anything.
> 
> Regards,
> Alex
> _______________________________________________
> 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