topic Re: Matching latitude and longitude trecordmatch in Data Quality

Matching latitude and longitude trecordmatch

Jorjos — Thu, 23 Aug 2018 11:08:36 GMT

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.

Re: Matching latitude and longitude trecordmatch

vapukov — Sun, 26 Aug 2018 02:27:52 GMT

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-longitude-what-am-i-doi

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

Re: Matching latitude and longitude trecordmatch

Jorjos — Mon, 27 Aug 2018 09:04:50 GMT

Thank you very much vapukov!

I'm gonna try it!