topic Re: How to display line length in SDE View SQL Server in Geodatabase Questions

How to display line length in SDE View SQL Server

JoseSanchez — Thu, 15 Feb 2018 20:14:55 GMT

Hello everyone,

The field "SHAPE.STLength()" does not show in the feature class when I try to create a view. Is there any function that allows to calculate in a SQL statement the length of a line form the field SHAPE?

Thanks

Re: How to display line length in SDE View SQL Server

JoseSanchez — Thu, 15 Feb 2018 20:41:21 GMT

Found it:

SELECT [FeatureID], [SHAPE] AS Geometry, SHAPE.STLength() AS Length FROM [database].[owner].[WaterLine]

This shows how to display in a SQL Query or a SQL SDE view the length of a line.

Re: How to display line length in SDE View SQL Server

JoseSanchez — Thu, 15 Feb 2018 20:44:49 GMT

https://tereshenkov.wordpress.com/2015/02/05/sql-server-spatial-functions-for-gis-users/

Re: How to display line length in SDE View SQL Server

JoseSanchez — Mon, 01 Apr 2019 15:59:29 GMT

Additional info:

https://docs.microsoft.com/en-us/sql/relational-databases/spatial/create-construct-and-query-geometry-instances?view=sql-server-2017

Re: How to display line length in SDE View SQL Server

JoseSanchez — Mon, 24 Feb 2020 17:49:48 GMT

This SQL statement displays X and Y coordinates

SELECT [PumpNumber], [SHAPE], SHAPE.STX, SHAPE.STY FROM [PUMP]