[postgis-users] Midpoint function?

[Rodrigo Martín LÓPEZ GREGORIO]

Hi Matt.

I think what you want may be:

line_interpolate_point(the_geom,0.5)

(or ST_line_interpolate_point(the_geom,0.5) depending on your Postgis
version)

where the_geom is a linestring and 0.5 means half of the total 2d length of
the linestring.

You can reed more details in the documentation:

http://postgis.refractions.net/docs/ch06.html#line_interpolate_point

Rodrigo

On 6/21/07, Matt Doughty <matt.doughty at geograma.com> wrote:
>
>  Hi List,
>
>
>
> Is there a function in PostGIS that finds the midpoint of a line?
>
>
>
> Matt
>
>
>
>
>
>
>
> Matt Doughty
>
>   GEOGRAMA S.L.
>
> Tel.:  +34 945 13 13 72    652 77 14 15
>
> Fax: +34 945 23 03 40
>
> www.geograma.com
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070621/a8a66813/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3743 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070621/a8a66813/attachment.jpg>