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

BigQuery reference

Snowflake reference

Redshift reference

PostgreSQL reference

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

BigQuery reference

Snowflake reference

Redshift reference

PostgreSQL reference

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

BigQuery reference

Redshift reference

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

BigQuery reference

Redshift reference

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.

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.

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