WKT_SPATIAL_CONTAINS

Checks if the first WKT formatted spatial object contains the second

Syntax

WKT_SPATIAL_CONTAINS(first, second)

Arguments

NameTypeDescriptionDefault Value

first

string

The WKT formatted spatial object which should be contained by the second argument

second

string

The WKT formatted spatial object which should contain the first object

Examples

firstsecondOutput

'POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))'

'POINT(10 0)'

true

'POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))'

'POINT(15 0)'

false

Transformation job example

SQL

CREATE JOB function_operator_example
    ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data 
  MAP_COLUMNS_BY_NAME
    SELECT first, second,
        WKT_SPATIAL_CONTAINS(first, second) AS Output
    FROM default_glue_catalog.upsolver_samples.orders_raw_data
    LET first = 'POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))',
        second = 'POINT(10 0)'
    WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
    LIMIT 1;

Query result

firstsecondOutput

'POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))'

'POINT(10 0)'

true

Last updated