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
Forteen 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!

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read