Geometry knn 内部結合

対応している処理：バッチ処理

ベースデータセットの各有効な入力ジオメトリに対して、隣接データセットから k の最も近い点を選択します。内部的には、入力データセットを指定された座標参照システムに変換し、WGS84 に戻します。隣接データセット全体がドライバーとエクゼキュータのメモリに収まる必要があります。3GB のエクゼキュータは、隣接データセットに最大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>
• optional 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 | | ----- | ----- | ----- | ----- | | {"coordinates": [-112.14843750000001,33.440609443703586], "type":"Point"} | 42.0 | {
   latitude: 33.44082430962016,
   longitude: -112.14560508728029,
  } | null |

---

例 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 | | ----- | ----- | ----- | ----- |

---

例 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 |

---

例 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:
  columnNameIsIn(
   columnNames: [geometryCol, lhsCol],
  )
• 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 ] |

---