# -*- 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 +
- 1
- 2
- 3
- 4
- 5
- 6
前往页