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:
Select the geometry column from the left (top) input table to join on.
Select the geometry column from the right (bottom) input table to join on.
The join mode determines of which input table the rows should be retained.
Maximum distance within which to query for nearest geometry. Must be greater than 0
Enter the Coordinate reference system (CRS) to use. The input field supports the following types:
Common EPSG codes that can be universally used for mapping coordinates everywhere in the world are:
There are EPSG codes for specific regions that provide a higher accuracy in the corresponding regions:
For a selection of projections that preserve different properties see this Wikipedia article. Once you have found the appropriate projection name or coordinate reference system you can search for its EPSG code at https://epsg.io/. To do so simply type the projection name into the search field (e.g. Pseudo-Mercator). The result page will show you the EPSG code that you can enter in this field (e.g. EPSG:3857) but also the distance unit e.g. meter or degree and the area of use where the projection works best.
If you are looking for a projection for a specific area, try out the Projection wizard page which suggests projection with specific properties for a defined area on the globe. Once you have found the appropriate projection simply click on the WKT link next to the suggested projection name, copy it to your clipboard and paste it into this field.
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.
A zipped version of the software site can be downloaded here.
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.Try NodePit Runner!
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to email@example.com, follow @NodePit on Twitter or botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.