Moving a Point along a Path in SQL Server 2008
- by David Pfeffer
I have a geography field stored in my database, holding a linestring path.
I want to move a point n meters along this linestring, and return the destination.
For example, I want the destination point 500 meters along the linestring starting from its beginning.
Here's an example -- what is the YourFunctionHere? Or, is there another way?
DECLARE @g geography;
SET @g = geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656, -122.310 47.690)', 4326);
SELECT @g.YourFunctionHere(100).ToString();