Parsers
Components to process data from an external format, such as WKT or GeoJSON, into a table format including the processed geographies/geometries in a column when applicable.
Draw Custom Features
Description
This component allows drawing new custom geospatial features.
By clicking on "Draw features" you will be able to use a point and click UI to define custom features (points, lines or polygons) that will be used to generate a GeoJSON string.
Inputs
GeoJSON string [String]
Outputs
Result table [Table]
ST as GeoJSON
Description
This component generates a new column with the GeoJSON representation of geographies in another column.
Inputs
Source table [Table]Column with geographies definition [Column]
Outputs
Result table [Table]
External links
ST as Text
Description
This component generates a new column with the WKT representation of geographies in another column.
Inputs
Source table [Table]Column with geographies definition [Column]
Outputs
Result table [Table]
External links
ST Geog from Text
Description
This component creates a new column with geometries created from the values in another column. This column can contain geometries defined in both WKT or GeoJSON format.
Inputs
Source table [Table]Text column with geography definition [Column]
Outputs
Result table [Table]
External links
ST GeogPoint
Description
This component creates a new table with an additional column with point geographies. Geographies are created based on columns containing latitude and longitude values.
The new column containing the points will be named geom. If there is already a column with that name in the input table, the component will return an error. Please rename any columns named geom from the input before connecting this component.
Inputs
Source table [Table]Latitude column [Column]Longitude column [Column]
Outputs
Result table [Table]
External links
Table from GeoJSON
Description
This creates a new table from a GeoJSON string.
By clicking on "Draw features" you will be able to use a point and click UI to define custom features (points, lines or polygons) that will be used to generate the GeoJSON string.
Inputs
GeoJSON string [String]
Outputs
Result table [Table]
WKB from GeoJSON
Description
This component creates a new column with geometries in WKB format created from the values in another column.
Databricks users: This component is only needed for legacy cluster-based Databricks connections that use WKB binary format. If you are using the recommended SQL Warehouse connection with native GEOMETRY type, use the standard geometry parsing components instead.
Inputs
Source table
Settings
Column with geometries definition: Expects a String column that contains GeoJSON defintion of geometries.
Outputs
Output table: This component return a table with the same columns as the input, plus an additional binary column that contians WKB geometries
WKB from Text
Description
This component creates a new column with geometries in WKB format created from the values in another column.
Databricks users: This component is only needed for legacy cluster-based Databricks connections that use WKB binary format. If you are using the recommended SQL Warehouse connection with native GEOMETRY type, use the standard geometry parsing components instead.
Inputs
Source table
Settings
Column with geometries definition: Expects a String column that contains WKT definition of geometries.
Outputs
Output table: This component return a table with the same columns as the input, plus an additional binary column that contians WKB geometries
Last updated
Was this helpful?