SQL Server Spatial: Insert a line into a SQL Server geography column. Example SQL

Platform:SQL Server Spatial
Task:Insert a line into a SQL Server geography column. Example SQL
Discussion:
You need to insert a line from two points into a Sql Server geography column.
Example:
INSERT INTO [ARCN_Caribou].[dbo].[CaribouMovements]
           ([CaribouID]
           ,[StartDateTime]
           ,[EndDateTime]
           ,[LineGeography])
     VALUES
           (99999999,GETDATE(),GETDATE(),geography::STLineFromText('LINESTRING(-122.360 47.656, -122.343 47.656 )', 4326))
Back to Index