[postgis-users] Fwd: Hello everyone, That is my first message.I am using PostGIS not so long and so I ask you to help me.

[Александр Дымчишин]

I'm trying to solve the transport problem and make the visualization
using Geotools.
In attached pic that is what I mean. My car is between V3 and V4. Its
position can I get with a query like "*SELECT ST_Line_Interpolate_Point*(
linestring1, 0.6);" Ok, I got it's position, but how can I receive nearest
real vertices v3 and v4? I hope, there is a method with only one query.
Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110522/cbd6e5c4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: trouble.png
Type: image/png
Size: 4562 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110522/cbd6e5c4/attachment.png>