WKT_SPATIAL_CONTAINS
Checks if the first WKT formatted spatial object contains the second
Syntax
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
Query result
first | second | Output |
---|---|---|
'POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))' | 'POINT(10 0)' | true |
Last updated