Spatial Accessors
Components used to obtain properties about a geography data type or a set of geographies.
ST Geometry Type
Description
This component adds a column containing the geography type of the geography in each row of the input table.
Inputs
Source table [Table]Geo column [Column]
Outputs
Result table [Table]
External links
ST NumGeometries
Description
This component creates a new table with an additional column with the number of parts in each input geography.
Inputs
Source table [Table]Geo column [Column]
Outputs
Result table [Table]
External links
ST NumPoints
Description
This component creates a new table with an additional column with the number of points in each input geography.
Inputs
Source table [Table]Geo column [Column]
Outputs
Result table [Table]
External links
ST Point N
Description
This component adds a new column with the point at the n-th position in the original input geography.
The geography must be of type linestring.
It will set the column value to null if the original geography is not a linestring, if it is empty, or if there is no vertex at the given index.
Inputs
Source table [Table]Geo column [Column]Point index [Number]
Outputs
Result table [Table]
External links
ST X / ST Y
Description
This component creates a new table with additional columns containing X and Y coordinates of the geographies in the input table. This only applies to the case of point geographies.
Inputs
Source table [Table]Geo column [Column]
Outputs
Result table [Table]
External links
Last updated
Was this helpful?