Skip to main content

I have several lines (streets) with a condition-value.

In an (excel) table, I have many rows with condition-values and other attributes I would like to join. Now, coming from my streets I need to find the "nearest" value in the excel-table and join its attributes.

What would be the simplest way to do that?

I have seen an approach of calculating "distances" to each value and then sort by lowest distance... Any other convenient way?

 

thx for your ideas, best regards from switzerland.

Hi, maybe if you provide sample data then increase the chance of an answer to your question.


Hi @reservoirdog​, you might find this article on finding nearest features helpful! https://community.safe.com/s/article/find-nearest-features


Thanks @jennaatsafe​ , but I need an approach for searching values (nearest value) than the spatial approach.

The source of the problem is finding the correct value of a normal distribution.

I never found a solution to work directly with mathematical functions, so we divided the normal distribution

in increments. Each increment represents a row in an excel table and I want to find the "nearest value/row" coming from my feature.

 

normal distribution:

normaldistributionincrements in a table:

increments


Reply