Spatial Accessors
Last updated
Was this helpful?
Last updated
Was this helpful?
Components used to obtain properties about a geography data type or a set of geographies.
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
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
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
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
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