Nearest Join

This node will merge the left (top) and the right (bottom) table based on the distance between their geometries of the two selected columns to one another. Distance is calculated in CRS units and is returned in the column NearDist. Both layers must be in the same Coordinate Reference System (CRS), otherwise, the CRS of right table will be transformed to that of the left table.

The node is based on the GeoPandas project and uses the following related information and functions:

Options

Top (left) geometry column

Select the geometry column from the top (left) input table to join on.

Bottom (right) geometry column

Select the geometry column from the bottom (right ) input table to join on.

Join mode

The join mode specifies the type of join that will occur and which geometry column is retained in the output table.

Available options:

  • Inner: Use intersection of index values and retain only the geometry column from the top (left) input table.
  • Left: Use the index and retain the geometry column from the top (left) input table.
  • Right: Use the index and retain the geometry column from the bottom (right) input table.
Maximum distance

Maximum distance within which to query for nearest geometry. Must be greater than 0

Distance unit

Choose the distance unit to use.

Available options:

  • Use unit from input CRS: Do not re-project but use the unit of the input CRS.
  • Meter: Use the default projection with meter as unit. The projection is the UTM CRS for the UTM zone in which the centroid of the input geometries lies. This projection works well for most latitudes but may not work for some extreme northern locations like Svalbard or far northern Norway in which case you might want to use your own projection prior using this node.
  • Kilometer: Use the default projection with kilometer as unit. The projection is the UTM CRS for the UTM zone in which the centroid of the input geometries lies. This projection works well for most latitudes but may not work for some extreme northern locations like Svalbard or far northern Norway in which case you might want to use your own projection prior using this node.
  • Miles: Use the default projection with miles as unit. The projection is the UTM CRS for the UTM zone in which the centroid of the input geometries lies. This projection works well for most latitudes but may not work for some extreme northern locations like Svalbard or far northern Norway in which case you might want to use your own projection prior using this node.
  • Degree: Use the epsg:4326 with degree as unit.
Keep CRS from left input table

If checked the CRS of the left input table is retained even if a re-projection was necessary for the selected distance unit.

Exclude the nearest geometries that are equal to the input geometry

If checked, the nearest geometries that are equal to the input geometry will not be returned.

Column selection

Top input (left table)

Select the columns from the top (left) input table to include into the result table.

Bottom input (right table)

Select the columns from the bottom (right) input table to include into the result table.

Input Ports

Icon

Left table with geometry column to join on

Icon

Right table with geometry column to join on

Output Ports

Icon

Joined geo table

Popular Predecessors

  • No recommendations found

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

  • No workflows found

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension Geospatial Analytics Extension for KNIME from the below update site following our NodePit Product and Node Installation Guide:

v5.2

A zipped version of the software site can be downloaded here.

Plugin provider: SDL, Harvard, Cambridge US
Plugin version: 1.3.0.202412051033
On NodePit since: 2023-12-06
Last update: 2024-12-18
KNIME versions: From v5.2 to v5.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!