Links

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 PointN

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