ArcPy数据处理应用之批量字段赋值
该任务要求从文本文件中读取配置信息,根据配置信息中的图层名和新旧字段值对应情况,批量将取值为旧值的要素相应字段赋以新值。
如,A图层BM字段有唯一值11、12、13,其中13需要修改为15,配置文件中保存有相应的配置项即“A,13,15”,其他唯一值11、12的数据不修改。
ArcPy处理代码如下:
... n = 0
... arcpy.env.workspace=r'D:/data.gdb'
... f = open(r'D:/T4_CodeMap.txt','r')
... for line in f.readlines():
... n = n + 1
... data = line.strip().split(',')
... if len(data)==3 and arcpy.Exists(data[0]):
... exp = u"{0} if !YSDM!=='{1}' else !YSDM!".format(data[2],data[1])
... print u"{0} Cal: {1}, exp: {2}".format(n, data, exp)
... arcpy.CalculateField_management(data[0],"YSDM",exp,"PYTHON_9.3")
... else:
... print u"{0}, Skip".format(n)
... f.close()
读取到的配置文件内容(截取部分)如下:
CSLDX_KDCSG,810304,810304102
CSLDX_KDCSG,820100,820100002
CSLDX_KDCSG,820200,820200002
DLJ_KDCSG,330101011,330101012
DLJ_KDCSG,380403003,380403002
DLJ_KDCSG,380506023,380506022
DLJ_KDCSG,810302013,810302012
DLJ_KDCSG,820200013,820200012
GDM_KDCSG,810100002,810100003
GDM_KDCSG,810300,810300003
GDM_KDCSG,810301,810301003
GDM_KDCSG,810302,810302003
GDM_KDCSG,810303,810303003
GDM_KDCSG,810304,810304003
GLM_KDCSG,40600013,406000133
GLM_KDCSG,420201034,420201033
GLM_KDCSG,420301014,420301013
GLM_KDCSG,420500014,420500003
GLM_KDCSG,420600014,420600013
转载自:https://blog.csdn.net/a_dev/article/details/89413376