注: 以下の翻訳の正確性は検証されていません。AIPを利用して英語版の原文から機械的に翻訳されたものです。

Geometry knn left join

サポートされているバージョン：バッチ

ベースデータセットの各有効な入力ジオメトリに対して、隣接データセットから k つの最も近いポイントを選択します。内部的には、入力データセットを指定された座標参照システムに変換し、WGS84 に戻します。隣接データセット全体がドライバーとエグゼキュータのメモリに収まる必要があります。3 GB のエグゼキュータは、隣接データセットに最大 100 万点まで対応できます。変換カテゴリー：ジオスパシャル、結合

宣言された引数

Base dataset - 結合で使用するベースデータセット。
Table
Condition for columns to select on the left - 左の入力スキーマのすべての行がこの条件に一致するかどうかが検証されます。一致する場合、出力で行が選択されます。
ColumnPredicate
Condition for columns to select on the right - 右の入力スキーマのすべての行がこの条件に一致するかどうかが検証されます。一致する場合、出力で行が選択されます。
ColumnPredicate
Join key - クエリデータセットの GeoJSON 行と隣接データセットのジオポイント行。
Tuple<Column<Geometry>, Column<Geo-point>>
K - 左のデータセット内の有効なジオメトリごとに右のデータセットから選択する隣接ポイントの数。
Literal<Integer>
Neighbors dataset - 結合で使用する潜在的な隣接データセット。
Table
Projected coordinate system - 入力ジオメトリが結合前に変換される座標系で、距離は指定された座標系の単位で測定されます。"authority" の形式で、例えば UTM ゾーン 18N は EPSG:32618 で識別できます。
Literal<String>
オプション Prefix for columns from right - 右側のすべての列名に追加する接頭辞。
Literal<String>

例

例 1 - ベースケース

引数の値:

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_ 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | 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 - ベースケース

引数の値:

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 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | geometryColLhs | lhs-1 | geometryColRhs | rhs-1 | | ----- | ----- | ----- | ----- |

例 3 - ベースケース

引数の値:

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_ 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | 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 - ベースケース

引数の値:

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_ 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | 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 - ベースケース

引数の値:

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 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | geometryColLhs | lhs-1 | geometryColRhs | rhs-1 | | ----- | ----- | ----- | ----- |

例 6 - ベースケース

引数の値:

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 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | 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 - ベースケース

引数の値:

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_ 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | geometryCol | lhsCol | rhs_geometryCol | rhs_col1 | rhs_arrayCol | | ----- | ----- | ----- | ----- | ----- | | {"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 | {
latitude: 33.440609443703586,
longitude: -112.14843750000001,
} | rhsVal1 | [ 0.0, 1.1 ] | | {"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 | {
latitude: 33.44082430962016,
longitude: -112.14560508728029,
} | rhsVal2 | [ 0.0, 1.1 ] | | {"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 | {
latitude: 33.440895931474124,
longitude: -112.11796760559083,
} | rhsVal3 | [ 0.0, 1.1 ] |

例 8 - ベースケース

引数の値:

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 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | 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 - ベースケース

引数の値:

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 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | geometryColLhs | lhs-1 | | ----- | ----- | | {"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"} | 42.0 | | {"coordinates": [-112.14560508728029,33.44082430962016], "type":"Point"} | 43.0 |

例 10 - ベースケース

引数の値:

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 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | geometryColRhs | rhs-1 | | ----- | ----- | | {
latitude: 33.44082430962016,
longitude: -112.14560508728029,
} | null | | {
latitude: 33.44082430962016,
longitude: -112.14560508728029,
} | null |

例 11 - ベースケース

引数の値:

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_ 入力: ri.foundry.main.dataset.leftri.foundry.main.dataset.right出力: | geometryCol | lhsCol | rhs_geometryCol | rhs_col1 | rhs_arrayCol | | ----- | ----- | ----- | ----- | ----- | | {"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 | {
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 ] |