土地利用现状分类面积统计表生成

# -*- coding: cp936 -*- import xlwt import arcpy #统计图层 inf = r'C:\Users\Administrator\Desktop\1\dltb.shp' inf_lyr = r'C:\Users\Administrator\Desktop\1\dltb.lyr' arcpy.MakeFeatureLayer_management(inf, inf_lyr) #获取镇代码 ZDM = [] with arcpy.da.SearchCursor(inf,'*') as cursors: for cursor in cursors: if ZDM: if cursor[9][0:9] not in ZDM: ZDM.append(cursor[9][0:9]) else: ZDM.append(cursor[9][0:9]) ZDM.sort() #获取村代码 CDM = [] with arcpy.da.SearchCursor(inf,'*') as cursors: for cursor in cursors: if CDM: if cursor[9][0:12] not in CDM: CDM.append(cursor[9][0:12]) else: CDM.append(cursor[9][0:12]) CDM.sort() #地类分项按村汇总 def caculate_cdm(cdm): with arcpy.da.SearchCursor(inf,'*') as cursors: #湿地 SUM_0303 = 0 SUM_0304 = 0 SUM_0306 = 0 SUM_0402 = 0 SUM_0603 = 0 SUM_1105 = 0 SUM_1106 = 0 SUM_1108 = 0 #耕地 SUM_0101 = 0 SUM_0102 = 0 SUM_0103 = 0 #园地 SUM_0201 = 0 SUM_0202 = 0 SUM_0203 = 0 SUM_0204 = 0 #林地 SUM_0301 = 0 SUM_0302 = 0 SUM_0305 = 0 SUM_0307 = 0 #草地 SUM_0401 = 0 SUM_0403 = 0 SUM_0404 = 0 #商服用地 SUM_05H1 = 0 SUM_0508 = 0 #工矿用地 SUM_0601 = 0 SUM_0602 = 0 #住宅用地 SUM_0701 = 0 SUM_0702 = 0 #公共用地 SUM_08H1 = 0 SUM_08H2 = 0 SUM_0809 = 0 SUM_0810 = 0 #特殊用地 SUM_09 = 0 #交通用地 SUM_1001 = 0 SUM_1002 = 0 SUM_1003 = 0 SUM_1004 = 0 SUM_1005 = 0 SUM_1006 = 0 SUM_1007 = 0 SUM_1008 = 0 SUM_1009 = 0 #水域用地 SUM_1101 = 0 SUM_1102 = 0 SUM_1103 = 0 SUM_1104 = 0 SUM_1107 = 0 SUM_1109 = 0 SUM_1110 = 0 #其他用地 SUM_1201 = 0 SUM_1202 = 0 SUM_1203 = 0 SUM_1204 = 0 SUM_1205 = 0 SUM_1206 = 0 SUM_1207 = 0 for cursor in cursors: if cursors[9][0:12] == cdm: cmc = cursors[10] #湿地汇总 if cursor[7] == '0303': SUM_0303 += cursor[34] elif cursor[7] == '0304': SUM_0304 += cursor[34] elif cursor[7] == '0306': SUM_0306 += cursor[34] elif cursor[7] == '0402': SUM_0402 += cursor[34] elif cursor[7] == '0603': SUM_0603 += cursor[34] elif cursor[7] == '1105': SUM_1105 += cursor[34] elif cursor[7] == '1106': SUM_1106 += cursor[34] elif cursor[7] == '1108': SUM_1108 += cursor[34] #耕地汇总 elif cursor[7] == '0101': SUM_0101 += cursor[34] elif cursor[7] == '0102': SUM_0102 += cursor[34] elif cursor[7] == '0103': SUM_0103 += cursor[34] #园地汇总 elif cursor[7] == '0201': SUM_0201 += cursor[34] elif cursor[7] == '0202': SUM_0202 += cursor[34] elif cursor[7] == '0203': SUM_0203 += cursor[34] elif cursor[7] == '0204': SUM_0204 += cursor[34] #林地汇总 elif cursor[7] == '0301': SUM_0301 += cursor[34] elif cursor[7] == '0302': SUM_0302 += cursor[34] elif cursor[7] == '0305': SUM_0305 += cursor[34] elif cursor[7] == '0307': SUM_0307 += cursor[34] #草地汇总 elif cursor[7] == '0401': SUM_0401 += cursor[34] elif cursor[7] == '0403': SUM_0403 += cursor[34] elif cursor[7] == '0404': SUM_0404 += cursor[34] #商服汇总 elif cursor[7] == '05H1': SUM_05H1 += cursor[34] elif cursor[7] == '0508': SUM_0508 += cursor[34] #工矿汇总 elif cursor[7] == '0601': SUM_0601 += cursor[34] elif cursor[7] == '0602': SUM_0602 += cursor[34] #住宅汇总 elif cursor[7] == '0701': SUM_0701 += cursor[34] elif cursor[7] == '0702': SUM_0702 += cursor[34] #公共汇总 elif cursor[7] == '08H1': SUM_08H1 += cursor[34] elif cursor[7] == '08H2': SUM_08H2 += cursor[34] elif cursor[7] == '0809': SUM_0809 += cursor[34] elif cursor[7] == '0810': SUM_0810 += cursor[34] #特殊汇总 elif cursor[7] == '09': SUM_09 += cursor[34] #交通汇总 elif cursor[7] == '1001': SUM_1001 += cursor[34] elif cursor[7] == '1002': SUM_1002 += cursor[34] elif cursor[7] == '1003': SUM_1003 += cursor[34] elif cursor[7] == '1004': SUM_1004 += cursor[34] elif cursor[7] == '1005': SUM_1005 += cursor[34] elif cursor[7] == '1006': SUM_1006 += cursor[34] elif cursor[7] == '1007': SUM_1007 += cursor[34] elif cursor[7] == '1008': SUM_1008 += cursor[34] elif cursor[7] == '1009': SUM_1009 += cursor[34] #水域汇总 elif cursor[7] == '1101': SUM_1101 += cursor[34] elif cursor[7] == '1102': SUM_1102 += cursor[34] elif cursor[7] == '1103': SUM_1103 += cursor[34] elif cursor[7] == '1104': SUM_1104 += cursor[34] elif cursor[7] == '1107': SUM_1107 += cursor[34] elif cursor[7] == '1109': SUM_1109 += cursor[34] elif cursor[7] == '1110': SUM_1110 += cursor[34] #其他汇总 elif cursor[7] == '1201': SUM_1201 += cursor[34] elif cursor[7] == '1202': SUM_1202 += cursor[34] elif cursor[7] == '1203': SUM_1203 += cursor[34] elif cursor[7] == '1204': SUM_1204 += cursor[34] elif cursor[7] == '1205': SUM_1205 += cursor[34] elif cursor[7] == '1206': SUM_1206 += cursor[34] elif cursor[7] == '1207': SUM_1207 += cursor[34] Total_00 = SUM_0303 + SUM_0304 +