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.

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.

Inputs

  • GeoJSON string [String]

Outputs

  • Result table [Table]

Last updated

Was this helpful?