Supported in: Batch, Streaming
Inner joins left and right datasets together based on whether input geometries overlap. Includes just touching geometries in the results.
Transform categories: Geospatial, Join
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | col1Lhs |
---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 |
ri.foundry.main.dataset.right
geometryColRhs | col1Rhs |
---|---|
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
{"coordinates": [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]], "type": "Polygon"} | rhsVal2 |
{"coordinates": [0.0, 0.0], "type":"Point"} | rhsVal3 |
{"coordinates": [15.0, 15.0], "type":"Point"} | rhsVal4 |
{"coordinates": [[-1.0, -1.0], [5.0, 5.0]], "type":"LineString"} | rhsVal5 |
{"coordinates": [[20.0, 20.0], [21.0, 23.0]], "type":"LineString"} | rhsVal6 |
{"coordinates": [[-1.0, -1.0], [5.0, 5.0]], "type":"LineString"} | rhsVal7 |
{"coordinates": [[20.0, 20.0], [21.0, 23.0]], "type":"LineString"} | rhsVal8 |
{"coordinates": [[[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]]], "type":"MultiPolygon"} | rhsVal9 |
{"coordinates": [[[[170.0, 170.0], [190.0, 170.0], [190.0, 190.0], [170.0, 190.0], [170.0, 170.0]]], [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]]], "type":"MultiPolygon"} | rhsVal10 |
Output:
geometryColLhs | col1Lhs | geometryColRhs | col1Rhs |
---|---|---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 | {"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 | {"coordinates": [0.0, 0.0], "type":"Point"} | rhsVal3 |
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 | {"coordinates": [[-1.0, -1.0], [5.0, 5.0]], "type":"LineString"} | rhsVal5 |
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 | {"coordinates": [[-1.0, -1.0], [5.0, 5.0]], "type":"LineString"} | rhsVal7 |
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 | {"coordinates": [[[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], [[[12.0, 12.0], [17.0, 12.0], [17.0, 17.0], [12.0, 17.0], [12.0, 12.0]]]], "type":"MultiPolygon"} | rhsVal9 |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | lhs1 |
---|---|
{} | 42.0 |
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 43.0 |
ri.foundry.main.dataset.right
geometryColRhs | rhs1 |
---|---|
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
Output:
geometryColLhs | lhs1 | geometryColRhs | rhs1 |
---|---|---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 43.0 | {"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | col1Lhs |
---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 |
ri.foundry.main.dataset.right
geometryColRhs | col1Rhs |
---|---|
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
Output:
geometryColLhs | col1Lhs | right_geometryColRhs | right_col1Rhs |
---|---|---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 | {"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | col1Lhs |
---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 42.0 |
ri.foundry.main.dataset.right
geometryColRhs | col1Rhs |
---|---|
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
Output:
geometryColLhs | geometryColRhs |
---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | {"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | lhs1 |
---|---|
null | 42.0 |
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 43.0 |
ri.foundry.main.dataset.right
geometryColRhs | rhs1 |
---|---|
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
{"coordinates": [0.0, 0.0], "type":"Point"} | rhsVal2 |
null | rhsVal3 |
Output:
geometryColLhs | lhs1 | geometryColRhs | rhs1 |
---|---|---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 43.0 | {"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 43.0 | {"coordinates": [0.0, 0.0], "type":"Point"} | rhsVal2 |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | lhs1 |
---|---|
null | 42.0 |
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 43.0 |
ri.foundry.main.dataset.right
geometryColRhs | rhs1 |
---|---|
{"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
Output:
geometryColLhs | lhs1 | geometryColRhs | rhs1 |
---|---|---|---|
{"coordinates": [[[0.0, 0.0], [10.0, 0.0], [10.0, 10.0], [0.0, 10.0], [0.0, 0.0]]], "type": "Polygon"} | 43.0 | {"coordinates": [[[2.0, 2.0], [7.0, 2.0], [7.0, 7.0], [2.0, 7.0], [2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | lhs1 |
---|---|
{"coordinates": [[[170.0, 170.0], [190.0, 170.0], [190.0, 190.0], [170.0, 190.0], [170.0, 170.0]]], "type": "Polygon"} | 42.0 |
ri.foundry.main.dataset.right
geometryColRhs | rhs1 |
---|---|
{"coordinates": [[[175.0, 175.0], [195.0, 175.0], [195.0, 195.0], [175.0, 195.0], [175.0, 175.0]]], "type": "Polygon"} | rhsVal1 |
Output:
geometryColLhs | lhs1 | geometryColRhs | rhs1 |
---|---|---|---|
{"coordinates": [[[170.0, 170.0], [190.0, 170.0], [190.0, 190.0], [170.0, 190.0], [170.0, 170.0]]], "type": "Polygon"} | 42.0 | {"coordinates": [[[175.0, 175.0], [195.0, 175.0], [195.0, 195.0], [175.0, 195.0], [175.0, 175.0]]], "type": "Polygon"} | rhsVal1 |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | lhs1 |
---|---|
{"coordinates": [[[0.0, 0.0], [5.0, 5.0], [0.0, 10.0], [10.0, 5.0], [0.0, 0.0]]], "type":"Polygon"} | 42.0 |
ri.foundry.main.dataset.right
geometryColRhs | rhs1 |
---|---|
{"coordinates": [[[0.0, 5.0], [2.5, 7.5], [4.0, 5.0], [2.5, 2.5], [0.0, 5.0]]], "type":"Polygon"} | rhsVal1 |
{"coordinates": [[[0.0, 5.0], [2.0, 7.0], [4.0, 5.0], [2.0, 3.0], [0.0, 5.0]]], "type":"Polygon"} | rhsVal2 |
Output:
geometryColLhs | lhs1 | geometryColRhs | rhs1 |
---|---|---|---|
{"coordinates": [[[0.0, 0.0], [5.0, 5.0], [0.0, 10.0], [10.0, 5.0], [0.0, 0.0]]], "type":"Polygon"} | 42.0 | {"coordinates": [[[0.0, 5.0], [2.5, 7.5], [4.0, 5.0], [2.5, 2.5], [0.0, 5.0]]], "type":"Polygon"} | rhsVal1 |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs |
---|
{"coordinates": [0.0, 0.0], "type":"Point"} |
ri.foundry.main.dataset.right
geometryColRhs |
---|
{"coordinates": [0.0, 0.0], "type":"Point"} |
{"coordinates": [15.0, 15.0], "type":"Point"} |
Output:
geometryColLhs | geometryColRhs |
---|---|
{"coordinates": [0.0, 0.0], "type":"Point"} | {"coordinates": [0.0, 0.0], "type":"Point"} |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | lhs1 |
---|---|
{"coordinates": [0.0, 0.0], "type":"Point"} | 42.0 |
ri.foundry.main.dataset.right
geometryColRhs | rhs1 |
---|---|
{"coordinates": [0.0, 0.0], "type":"Point"} | rhsVal1 |
{"coordinates": [15.0, 15.0], "type":"Point"} | rhsVal2 |
Output:
geometryColLhs | lhs1 | geometryColRhs | rhs1 |
---|---|---|---|
{"coordinates": [0.0, 0.0], "type":"Point"} | 42.0 | {"coordinates": [0.0, 0.0], "type":"Point"} | rhsVal1 |
Argument values:
geometryColLhs
, geometryColRhs
)Inputs: ri.foundry.main.dataset.left
geometryColLhs | lhs1 |
---|---|
{"coordinates": [[[0.0, 0.0, 0.0], [10.0, 0.0, 0.0], [10.0, 10.0, 0.0], [10.0, 10.0, 10.0], [0.0, 10.0, 10.0], [0.0, 0.0, 10.0], [0.0, 0.0, 0.0]]], "type": "Polygon"} | 42.0 |
ri.foundry.main.dataset.right
geometryColRhs | rhs1 |
---|---|
{"coordinates": [[[2.0, 2.0, 2.0], [7.0, 2.0, 2.0], [7.0, 7.0, 2.0], [7.0, 7.0, 7.0], [2.0, 7.0, 7.0], [2.0, 2.0, 7.0], [2.0, 2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |
{"coordinates": [[[12.0, 12.0, 12.0], [17.0, 12.0, 12.0], [17.0, 17.0, 12.0], [17.0, 17.0, 17.0], [12.0, 17.0, 17.0], [12.0, 12.0, 17.0], [12.0, 12.0, 12.0]]], "type": "Polygon"} | rhsVal2 |
Output:
geometryColLhs | lhs1 | geometryColRhs | rhs1 |
---|---|---|---|
{"coordinates": [[[0.0, 0.0, 0.0], [10.0, 0.0, 0.0], [10.0, 10.0, 0.0], [10.0, 10.0, 10.0], [0.0, 10.0, 10.0], [0.0, 0.0, 10.0], [0.0, 0.0, 0.0]]], "type": "Polygon"} | 42.0 | {"coordinates": [[[2.0, 2.0, 2.0], [7.0, 2.0, 2.0], [7.0, 7.0, 2.0], [7.0, 7.0, 7.0], [2.0, 7.0, 7.0], [2.0, 2.0, 7.0], [2.0, 2.0, 2.0]]], "type": "Polygon"} | rhsVal1 |