Spatial Join

This node will merge the left (top) and the right (bottom) table based on their spatial relationship of the two selected columns to one another. 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 determines of which input table the rows should be retained.

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.
Match mode

Defines which predicate is used for matching.

Available options:

  • Contains: Matches if no point of the right object lies in the exterior of the left object and at least one point of the interior of right object lies in the interior of the left object.
  • Contains the center of: Matches if the right object's representative point intersects only with the interior of the left object (not its boundary or exterior).
  • Contains properly: Matches if the right object is completely inside the left object, with no common boundary points.
  • Covers: Matches if every point of the right object is a point on the interior or boundary of the left object.
  • Crosses: Matches if the interior of the left object intersects the interior of the right object but does not contain it, and the dimension of the intersection is less than the dimension of the one or the other.
  • Has its center in: Matches if the left object's representative point intersects only with the interior of the right object (not its boundary or exterior).
  • Intersects: Matches if the boundary or interior of the left object intersects in any way with those of the right object.
  • Overlaps: Matches if the geometries have more than one but not all points in common, have the same dimension, and the intersection of the interiors of the geometries has the same dimension as the geometries themselves.
  • Touches: Matches if the objects have at least one point in common and their interiors do not intersect with any part of the other.
  • Within: Matches if the left object's boundary and interior intersect only with the interior of the right object (not its boundary or exterior).

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 (top) table with geometry column to join on

Icon

Right (bottom) 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!