I have two database of village in madagascar, I need to join them. the first one is from an old census the second one from the last census. Let's call them A & B (B being the most recent data)
A & B both have position, region, district, commune, name and position, but there are sliglth differences between A & B (small position change : 0-1km, orthograph change in names...). A has 17000 points, B has 20000 points. I have some information in A database that I need to put into B database
I tried a geographical join (through a voronoi area approach) but only ~65% of A point fall uniquely in a B voronoi Cell. And when I have a unique A point into a B cell sometimes it is not the right point (for example the village names do not match)
I would like to try another method based on "full name" (concatenation of region-district-commune-name), but I am facing orthograph problem, this way I have only 60% of matching before orthograph correction. So I would need to know if there is some fuzzy lookup algorithm in Manifold (8 or9, preferably8) that helps join database base on almost exact primary key column (like in excel : fuzzy look up addin https://www.microsoft.com/en-us/download/details.aspx?id=15011).
If no, second option would be to analyse if my "full name" are similar to decide wether points in A & B table should match or not based on a note given by a string-matching function. Is such a function exist in manifolf? As someone already used this kind of stuff?