Matching latitude and longitude trecordmatch

Five Stars

Matching latitude and longitude trecordmatch

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.

Tags (1)
Highlighted
Thirteen Stars

Re: Matching latitude and longitude trecordmatch

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


-----------
Five Stars

Re: Matching latitude and longitude trecordmatch

Thank you very much vapukov!

 

I'm gonna try it!