Geometry knn left join（几何K近邻左连接（Geometry knn left 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\> - 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 |
|---|---|---|---|
| {"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"} | 42.0 | null | null |
| {"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"} | 43.0 | null | null |
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 |
| null | 43.0 | null | 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 left join）¶
支持：批处理（Batch）
对于基础数据集（base dataset）中每个有效的输入几何图形，从邻居数据集（neighbors dataset）中选择K个最近的点。内部会将输入数据集转换为指定的坐标参考系统（coordinate reference system），然后再转换回WGS84。整个邻居数据集必须能够放入驱动器和执行器内存中。一个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列和邻居数据集中的地理点（geopoint）列。
元组\<列\<几何图形>, 列\<地理点>> - 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 |
|---|---|---|---|
| {"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"} | 42.0 | null | null |
| {"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"} | 43.0 | null | null |
示例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 |
| null | 43.0 | null | 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 ] |