Tulip garden it salt road, nanjing city in jiangsu province 22 1 unit. 403, the general address is like this there is a rule, but more than 30 data like this can't be sure. Do you have a rule, some provinces and cities, some no unit room, incomplete, some area at the next lower level is not the way, is a way, the streets, ring, the next level of plot are various, such as landscape, Minneapolis, Kang Ye, its moments of beauty, the open source community... Some address not households, but businesses, such as staff canteen, tower 2, area, and in the face of such data, how to deal with, I now is to parse, a bit stupid, is time-consuming, data is not accurate, later have to frequently check, pursuing big religion teach

CodePudding user response:

I suggest you use first keyword province city area county town road building unit level, so use the substr to break up, and then in different fields and then unified combination