• arcpy更新属性并获取自然间断法分级渲染labels


    #coding=utf-8
    import xlrd
    import arcpy
    
    
    wb=xlrd.open_workbook(ur'e:	est小区面_TableToExcel.xls')
    sheet1 = wb.sheets()[0]  
    nrows = sheet1.nrows
    ncols = sheet1.ncols
    name=''
    value=0.0
    courts={}
    for i in range(nrows):
        if i==0:
            continue
        name=sheet1.cell(i,0).value
        value=sheet1.cell(i,1).value
        if not courts.has_key(name):
            courts[name]=value
    
    
    arcpy.env.workspace=r'E:	estData80.gdb'
    fes = arcpy.ListFeatureClasses(feature_dataset='RG')
    for fc in fes:
        if fc==ur'小区面':
            with arcpy.da.UpdateCursor(fc,["Name","P3"]) as cursor:
                for row in cursor:
                    courtname = row[0]
                    if courts.has_key(courtname):
                        row[1] = courts[courtname]
                        cursor.updateRow(row)
                        print courtname
                del cursor
    
    print 'over'
    #coding=utf-8
    
    import arcpy
    mxd = arcpy.mapping.MapDocument(r"e:	estp3.mxd")
    for lyr in arcpy.mapping.ListLayers(mxd):
        print lyr.symbologyType
        if lyr.symbologyType == "GRADUATED_COLORS":
            lyr.symbology.valueField = "Shape_Area"
            lyr.symbology.numClasses = 20
        print lyr.symbology.classBreakLabels
    mxd.save()
    del mxd
    
    print 'over'

  • 相关阅读:
    ●sql语句-添加表和字段的说明
    ●sql-行列转换
    ●获取汉字全拼
    ●获取汉字首拼
    ●导出excel(NPOI)
    ●导出excel(office组件)
    JQuery
    CSS网页美化设计属性
    表单 框架集及CCS 20140916
    常见标签的属性及使用 20140915
  • 原文地址:https://www.cnblogs.com/yansc/p/13999281.html
Copyright © 2020-2023  润新知