1、将搜索出来的地理字段与原表地理字段转换为json格式
lonlat=[json.dumps(mapping(nationplace.iloc[i][‘geometry’])[‘coordinates’]) for i in range(len(nationplace))]
nationplace[‘LonLat’]=lonlat
contains=filter(anhuiall.intersects, lakelist)
inlist=[json.dumps(mapping§[‘coordinates’]) for p in contains]
inlist=pd.DataFrame(inlist,columns=[‘LonLat’])
2、通过pandas进行关键字段匹配,注意有关键地理信息的表放在前面,否则地理信息会丢失
selectlake=nationplace.merge(inlist,how=‘inner’,on=‘LonLat’)