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]

Last updated