How to unify the "address" field in the table for subsequent joining on this field?

Question

API

There are several tables with real estate addresses that need to be joined. The tables contain different information on the same objects. The only field to which they will merge is the "address" field, but this field looks different in different databases, for example, "Lenin street 5" and "Lenina street, house 5" and so on and so forth. There is an idea to solve the merging problem by unifying addresses by calling a mapping service (for example, Yandex Maps), passing the original content of the "address" field to the tube and replacing this value with the standard address designation received from the service. How smart is the idea? How to implement it practically?
Is it possible to solve this problem by using address autocomplete services? https://habrahabr.ru/post/214945/

Answer 1

If you are not doing it for yourself on your knee, then I think it is worth recalling that it is forbidden to save the result of geocoding (for example, Yandex maps, as well as Google).
Where it is better to master address parsing, for example, using the open library https://github.com/openvenues/libpostal There are ports for different languages.