[OpenLayers-Users] Get point on line?

[paweluz]

well.. 

- get the length of all geometry - ST_Length(geometry) e.g length = 120.0 m
- what distance you want your new point e.g in 45.0 m  then you do :
120x=45 /120
x=0.375

- then you do 

select astext(ST_LINE_SUBSTRING(
                    ST_LineMerge(the_geom),
                    0,  0.375)) from table   


- then get the last point of the new line geometry... 

I think that is all :)

good luck :)

-- 
View this message in context: http://n2.nabble.com/Get-point-on-line--tp2739966p2767657.html
Sent from the OpenLayers Users mailing list archive at Nabble.com.