[postgis-users] Midpoint function?

Pradeep B V pradeepbv at gmail.com
Thu Jun 21 05:32:42 PDT 2007


Is there any other function equivalent to the line_interpolate_point(the_geom,
0.5) to find the midpoint of a MULTILINESTRING?

the line_interpolate_point works only with LINESTRINGS.

- Pradeep B V
www.btis.in


On 6/21/07, Rodrigo Martín LÓPEZ GREGORIO <
rodrigomartin at lopezgregorio.com.ar> wrote:
>
> 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
> >
> >   GEOGRAM A 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
> >
> >
>
> _______________________________________________
> 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/7dddbe36/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/7dddbe36/attachment.jpg>


More information about the postgis-users mailing list