[postgis-users] Midpoint function?

[Matt Doughty]

Hi Rodirigo,

 

Thanks- this was what I was looking for, although Pradeep's problem is an interesting one too.

 

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

 

 

________________________________

De: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] En nombre de Rodrigo Martín LÓPEZ GREGORIO
Enviado el: jueves, 21 de junio de 2007 14:06
Para: PostGIS Users Discussion
Asunto: Re: [postgis-users] Midpoint function?

 

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 <mailto: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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070621/abf68798/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3743 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070621/abf68798/attachment.jpg>