There is A table. A, there is A name the name and full address address
Such as the name is XXX, detailed address is Beijing xueyuan road haidian district

Another table B, is the country with latitude and longitude table, have a short name shortname, lat LNG longitude, latitude, etc.
For example: Beijing 116 33
6Haidian 116 33
6Xueyuan road street, 116, 33
6,
,
Presently intends to address matching according to list A table to B's short name, then put table B of latitude and longitude (with repetitive manual screening) then again backfill to table A latitude and longitude fields in

Such as the above example Beijing xueyuan road haidian district can match to the
Beijing 116 33
6Haidian 116 33
6Xueyuan road street, 116, 33
6These three data

CodePudding user response:

The product manager of white piao

CodePudding user response:

Matching rule all didn't write clear, Beijing normal university should also match?