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.

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

Was this helpful?