Geometry knn inner join（几何K近邻内连接(Geometry knn inner join)）

Supported in: Batch

Selects the k closest points from the neighbors dataset for each valid input geometry from the base dataset. Internally converts the input datasets to the given coordinate reference system, and back to WGS84. The entire neighbors dataset must be able to fit into driver and executor memory. A 3 gb executor should be able to handle up to 1 million points in the neighbors dataset.

Transform categories: Geospatial, Join

Declared arguments

• Base dataset: Base dataset to use in join.
  Table
• Condition for columns to select on the left: All columns in the left input schema will be tested to see if they match this condition. If they match, the column will be selected in the output.
  ColumnPredicate
• Condition for columns to select on the right: All columns in the right input schema will be tested to see if they match this condition. If they match, the column will be selected in the output.
  ColumnPredicate
• Join key: The GeoJSON column from the query dataset and the geopoint column from the neighbors dataset.
  Tuple\, Column\\>
• K: The number of neighbors to select from the right dataset for each valid geometry in the left dataset.
  Literal\
• Neighbors dataset: Dataset of potential neighbors to use in join.
  Table
• Projected coordinate system: Input geometries will be converted to this coordinate system prior to the join, and distance will be measured in the units of the given coordinate system. Formatted as "authority:id", so for example UTM zone 18N could be identified by EPSG:32618.
  Literal\
• optional Prefix for columns from right: Prefix to add to all column names on the right hand side.
  Literal\

Examples

Example 1: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryCol, col],
  )
• Join key: (geometryCol, geometryCol)
• K: 2
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: rhs_

Inputs:

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0

ri.foundry.main.dataset.right

geometryCol	col
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3

Output:

geometryCol	lhsCol	rhs_geometryCol	rhs_col
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2

---

Example 2: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• Join key: (geometryColLhs, geometryColRhs)
• K: 1
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs-1

ri.foundry.main.dataset.right

geometryColRhs	rhs-1

Output:

geometryColLhs	lhs-1	geometryColRhs	rhs-1

---

Example 3: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryCol, col],
  )
• Join key: (geometryCol, geometryCol)
• K: 2
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: rhs_

Inputs:

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryCol	col
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3

Output:

geometryCol	lhsCol	rhs_geometryCol	rhs_col
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	43.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	43.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2

---

Example 4: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryCol, col],
  )
• Join key: (geometryCol, geometryCol)
• K: 3
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: rhs_

Inputs:

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0

ri.foundry.main.dataset.right

geometryCol	col
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3

Output:

geometryCol	lhsCol	rhs_geometryCol	rhs_col
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2

---

Example 5: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• Join key: (geometryColLhs, geometryColRhs)
• K: 1
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs-1

ri.foundry.main.dataset.right

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal2
null	rhsVal3

Output:

geometryColLhs	lhs-1	geometryColRhs	rhs-1

---

Example 6: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• Join key: (geometryColLhs, geometryColRhs)
• K: 1
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs-1

Output:

geometryColLhs	lhs-1	geometryColRhs	rhs-1

---

Example 7: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryCol, col1, arrayCol],
  )
• Join key: (geometryCol, geometryCol)
• K: 5
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:4326
• Prefix for columns from right: rhs_

Inputs:

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0

ri.foundry.main.dataset.right

geometryCol	col1	arrayCol	toDrop
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1	[ 0.0, 1.1 ]	1.0
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2	[ 0.0, 1.1 ]	1.0
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3	[ 0.0, 1.1 ]	1.0

Output:

geometryCol	lhsCol	rhs_geometryCol	rhs_col1	rhs_arrayCol
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1	[ 0.0, 1.1 ]
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2	[ 0.0, 1.1 ]
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0	{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3	[ 0.0, 1.1 ]

---

Example 8: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• Join key: (geometryColLhs, geometryColRhs)
• K: 1
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
null	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal2
null	rhsVal3

Output:

geometryColLhs	lhs-1	geometryColRhs	rhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null

---

Example 9: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [],
  )
• Join key: (geometryColLhs, geometryColRhs)
• K: 1
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal2
null	rhsVal3

Output:

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"}	43.0

---

Example 10: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  columnNameIsIn(
   columnNames: [],
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• Join key: (geometryColLhs, geometryColRhs)
• K: 1
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:2868
• Prefix for columns from right: null

Inputs:

ri.foundry.main.dataset.left

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal2
null	rhsVal3

Output:

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null

---

Example 11: Base case

Argument values:

• Base dataset: ri.foundry.main.dataset.left
• Condition for columns to select on the left:
  allColumns(
  
  )
• Condition for columns to select on the right:
  columnNameIsIn(
   columnNames: [geometryCol, col1, arrayCol],
  )
• Join key: (geometryCol, geometryCol)
• K: 1
• Neighbors dataset: ri.foundry.main.dataset.right
• Projected coordinate system: epsg:4326
• Prefix for columns from right: rhs_

Inputs:

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0
{"coordinates": [[40.0, 0.0], [0.0, 40.0]], "type":"LineString"}	44.0
{"coordinates": [[[20.0, 10.0], [27.0, 10.0], [27.0, 17.0], [20.0, 17.0], [20.0, 10.0]]], "type": "Polygon"}	45.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	46.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"}	47.0
{"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"}	48.0

ri.foundry.main.dataset.right

geometryCol	col1	arrayCol	toDrop
{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]	1.0
{  latitude: 100.0,  longitude: 100.0, }	rhsVal2	[ 0.0, 1.1 ]	1.0

Output:

geometryCol	lhsCol	rhs_geometryCol	rhs_col1	rhs_arrayCol
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"coordinates": [[40.0, 0.0], [0.0, 40.0]], "type":"LineString"}	44.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"coordinates": [[[20.0, 10.0], [27.0, 10.0], [27.0, 17.0], [20.0, 17.0], [20.0, 10.0]]], "type": "Polygon"}	45.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	46.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"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"}	47.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"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"}	48.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]

---

---

中文翻译

几何K近邻内连接(Geometry knn inner join)

支持：批处理(Batch)

对于基础数据集(Base dataset)中每个有效的输入几何图形，从邻居数据集(Neighbors dataset)中选择K个最近的点。内部会将输入数据集转换为指定的坐标参考系统，然后再转换回WGS84。整个邻居数据集必须能够放入驱动(Driver)和执行器(Executor)内存中。一个3GB的执行器应能处理邻居数据集中最多100万个点。

转换类别：地理空间(Geospatial)，连接(Join)

声明参数(Declared arguments)

• 基础数据集(Base dataset)： 用于连接的基础数据集。
  表(Table)
• 左侧列选择条件(Condition for columns to select on the left)： 左侧输入模式中的所有列都将被测试是否匹配此条件。如果匹配，该列将被选中输出。
  列谓词(ColumnPredicate)
• 右侧列选择条件(Condition for columns to select on the right)： 右侧输入模式中的所有列都将被测试是否匹配此条件。如果匹配，该列将被选中输出。
  列谓词(ColumnPredicate)
• 连接键(Join key)： 来自查询数据集的GeoJSON列和来自邻居数据集的地理点列。
  元组\<列\<几何>, 列\<地理点>>
• K值(K)： 对于左侧数据集中的每个有效几何图形，从右侧数据集中选择的邻居数量。
  字面量\<整数>
• 邻居数据集(Neighbors dataset)： 用于连接的可能邻居数据集。
  表(Table)
• 投影坐标系(Projected coordinate system)： 输入几何图形将在连接前转换为该坐标系，距离将以给定坐标系的单位进行测量。格式为"authority:id"，例如UTM 18N区可标识为EPSG:32618。
  字面量\<字符串>
• 可选 右侧列前缀(Prefix for columns from right)： 添加到右侧所有列名的前缀。
  字面量\<字符串>

示例(Examples)

示例1：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, col],
  )
• 连接键： (geometryCol, geometryCol)
• K值： 2
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： rhs_

输入：

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0

ri.foundry.main.dataset.right

geometryCol	col
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3

输出：

geometryCol	lhsCol	rhs_geometryCol	rhs_col
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2

---

示例2：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• 连接键： (geometryColLhs, geometryColRhs)
• K值： 1
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs-1

ri.foundry.main.dataset.right

geometryColRhs	rhs-1

输出：

geometryColLhs	lhs-1	geometryColRhs	rhs-1

---

示例3：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, col],
  )
• 连接键： (geometryCol, geometryCol)
• K值： 2
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： rhs_

输入：

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryCol	col
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3

输出：

geometryCol	lhsCol	rhs_geometryCol	rhs_col
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	43.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	43.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2

---

示例4：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, col],
  )
• 连接键： (geometryCol, geometryCol)
• K值： 3
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： rhs_

输入：

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0

ri.foundry.main.dataset.right

geometryCol	col
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3

输出：

geometryCol	lhsCol	rhs_geometryCol	rhs_col
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2

---

示例5：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• 连接键： (geometryColLhs, geometryColRhs)
• K值： 1
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs-1

ri.foundry.main.dataset.right

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal2
null	rhsVal3

输出：

geometryColLhs	lhs-1	geometryColRhs	rhs-1

---

示例6：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• 连接键： (geometryColLhs, geometryColRhs)
• K值： 1
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs-1

输出：

geometryColLhs	lhs-1	geometryColRhs	rhs-1

---

示例7：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, col1, arrayCol],
  )
• 连接键： (geometryCol, geometryCol)
• K值： 5
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:4326
• 右侧列前缀： rhs_

输入：

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0

ri.foundry.main.dataset.right

geometryCol	col1	arrayCol	toDrop
{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1	[ 0.0, 1.1 ]	1.0
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2	[ 0.0, 1.1 ]	1.0
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3	[ 0.0, 1.1 ]	1.0

输出：

geometryCol	lhsCol	rhs_geometryCol	rhs_col1	rhs_arrayCol
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0	{  latitude: 33.440609443703586,  longitude: -112.14843750000001, }	rhsVal1	[ 0.0, 1.1 ]
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	rhsVal2	[ 0.0, 1.1 ]
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0	{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal3	[ 0.0, 1.1 ]

---

示例8：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• 连接键： (geometryColLhs, geometryColRhs)
• K值： 1
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
null	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal2
null	rhsVal3

输出：

geometryColLhs	lhs-1	geometryColRhs	rhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0	{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null

---

示例9：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColLhs, lhs-1],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [],
  )
• 连接键： (geometryColLhs, geometryColRhs)
• K值： 1
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal2
null	rhsVal3

输出：

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"}	43.0

---

示例10：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  columnNameIsIn(
   columnNames: [],
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryColRhs, rhs-1],
  )
• 连接键： (geometryColLhs, geometryColRhs)
• K值： 1
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:2868
• 右侧列前缀： null

输入：

ri.foundry.main.dataset.left

geometryColLhs	lhs-1
{"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"}	42.0
{"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"}	43.0

ri.foundry.main.dataset.right

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.440895931474124,  longitude: -112.11796760559083, }	rhsVal2
null	rhsVal3

输出：

geometryColRhs	rhs-1
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null
{  latitude: 33.44082430962016,  longitude: -112.14560508728029, }	null

---

示例11：基本情况

参数值：

• 基础数据集： ri.foundry.main.dataset.left
• 左侧列选择条件：
  allColumns(
  
  )
• 右侧列选择条件：
  columnNameIsIn(
   columnNames: [geometryCol, col1, arrayCol],
  )
• 连接键： (geometryCol, geometryCol)
• K值： 1
• 邻居数据集： ri.foundry.main.dataset.right
• 投影坐标系： epsg:4326
• 右侧列前缀： rhs_

输入：

ri.foundry.main.dataset.left

geometryCol	lhsCol
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0
{"coordinates": [[40.0, 0.0], [0.0, 40.0]], "type":"LineString"}	44.0
{"coordinates": [[[20.0, 10.0], [27.0, 10.0], [27.0, 17.0], [20.0, 17.0], [20.0, 10.0]]], "type": "Polygon"}	45.0
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	46.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"}	47.0
{"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"}	48.0

ri.foundry.main.dataset.right

geometryCol	col1	arrayCol	toDrop
{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]	1.0
{  latitude: 100.0,  longitude: 100.0, }	rhsVal2	[ 0.0, 1.1 ]	1.0

输出：

geometryCol	lhsCol	rhs_geometryCol	rhs_col1	rhs_arrayCol
{"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,10.0],[10.0,10.0],[10.0,0.0],[0.0,0.0]]]}	42.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"coordinates": [55.0, 5.0], "type":"Point"}	43.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"coordinates": [[40.0, 0.0], [0.0, 40.0]], "type":"LineString"}	44.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"coordinates": [[[20.0, 10.0], [27.0, 10.0], [27.0, 17.0], [20.0, 17.0], [20.0, 10.0]]], "type": "Polygon"}	45.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"coordinates": [[[21.0, 21.0], [27.0, 21.0], [27.0, 27.0], [21.0, 27.0], [21.0, 21.0]]], "type": "Polygon"}	46.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"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"}	47.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]
{"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"}	48.0	{  latitude: 5.0,  longitude: 5.0, }	rhsVal1	[ 0.0, 1.1 ]