Matching latitude and longitude trecordmatch

[Jorjos]

Hello,

I am trying to make a data quality job that match geocodes and names.

At this moment i am using trecordmatching, but any of the matching functions in this component solve the problem... when i use the key definitions with Bigdecimals (latitude and longitude) doesn't match as a number and doesn't identify the geocodes properly.

For example, if the latitude from the input is 14,56789 and the lookup latitude is 14,57123 it doesn't match, i get a low matching weight

How can i make this match? Are there any other components or processes that could match geocodes? 

Thank you very much in advance.

[vapukov]

it will never match, You need use functions for calc distance

You can do this with Java - https://stackoverflow.com/questions/3694380/calculating-distance-between-two-points-using-latitude-l...

You can use database for this, for example - https://www.gaia-gis.it/fossil/libspatialite/index

or You can test - https://www.disy.net/en/products/geospatial-for-talend/, "free for small projects" not very clean describe the license policy, but You can test and ask

[Jorjos]

Thank you very much vapukov!

I'm gonna try it!