Links

WKT_SPATIAL_CONTAINS

Checks if the first WKT formatted spatial object contains the second

Syntax

WKT_SPATIAL_CONTAINS(first, second)

Arguments

Name
Type
Description
Default 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

first
second
Output
'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 time_filter()
LIMIT 1;

Query result

first
second
Output
'POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))'
'POINT(10 0)'
true