ArcGIS字段计算器公式汇总

 !面积1! + !面积2! - !面积3! * !面积4!

round(!Shape_Area!, 2)

!Shape_Area! // 400

!Shape_Area! // 400 + 2

random.randint(0, 10)

!字段1! + " " + !字段2!

!字符串01![:3]  # 提取前3位

!字符串01!.replace('县', '市')

format(!TBMJ!, '.5f')

datetime.datetime.now()

DateAdd(!日期字段!, 10)  # 增加10天

if !条件字段! == '条件值':    '结果1'else:    '结果2'

max(if !条件字段! == '条件值1' then !值字段1! else 0, if !条件字段! == '条件值2' then !值字段2! else 0)

!shape.geodesicArea!

东：!shape.extent.XMax!西：!shape.extent.XMin!南：!shape.extent.YMin!北：!shape.extent.YMax!

rec=0def Increment(Start=1, Interval=1):    global rec    if (rec == 0):        rec = Start    else:        rec = rec + Interval    return rec

UniqueDict = {}def isDuplicateIndex(inValue):    UniqueDict.setdefault(inValue, 0)    UniqueDict[inValue] += 1    return str(UniqueDict[inValue]).zfill(3)

def getnums():    return arcgis.rand('Integer 5 15')

total = 0def AccumulateValue(arg):    global total    if total:        total += arg    else:        total = arg    return total

rec = 0def SequentialNumber():    global rec    pStart = 1    pInterval = 1    if (rec == 0):        rec = pStart    else:        rec = rec + pInterval    return rec

def shiftXCoordinate(shape):    shiftValue = 100    point = shape.getPart(0)    point.X += shiftValue    return point

lastValue = 0def PercentChange(arg):    global lastValue    newValue = arg    if lastValue:        percentage = ((newValue - lastValue) / lastValue) * 100    else:        percentage = 0    lastValue = newValue    return percentage

def ss(a):    index1 = a.find(u'°')    index2 = a.find(u'′')    index3 = a.find(u'″')    degree = float(a[0:index1])    minutes = float(a[index1 + 1:index2])    seconds = float(a[index2 + 1:index3])    result = degree + minutes / 60 + seconds / 3600    return result

import redef ss(a):    va = re.findall(u'[\u4e00-\u9fa5]+', a)    result = ''.join(va)    return result

(8 - len(str(!数值01!))) * '0' + str(!数值01!)

!你的字段!.center(8, "0")

!BSM!.find("8")#例如这里我找8的位置

def getVertexCount(feat):    partnum = 0    partcount = feat.partCount    pntcount = 0    while partnum < partcount:        part = feat.getPart(partnum)        pnt = part.next()        while pnt:            pntcount += 1            pnt = part.next()            if not pnt:                pnt = part.next()        partnum += 1    return pntcount

"大" if !数值字段! > 100 else "中" if !数值字段! > 50 else "小"

round(!Shape_Area! / 10000, 2)#转换公顷保留2位round(!Shape_Area! / 10000*15, 2)#转换亩保留2位

import urllib.parseurllib.parse.quote_plus(!字符串字段!)

import urllib.parseurllib.parse.unquote(!编码字符串字段!)

"优" if !成绩! >= 90 else "良" if !成绩! >= 75 else "中" if !成绩! >= 60 else "差"

format(!数值字段!, '.2f') if !条件字段! else "N/A"

!shape1!.distanceTo(!shape2)!

!shape_point!.within(!shape_polygon!)

def runningTotal():    total = 0    for val in !数值字段!:        total += val        yield total

!日期字段!.year + (!日期字段!.month - 1) // 3

arcpy.Point(!经度字段!, !纬度字段!).toUTM()

统计平均值 = !数值字段!.sum() / float(!数值字段!.count())

arcpy.Geocoding.GeocodeAddresses(!地址字段!, !X坐标字段!, !Y坐标字段!)

(!数值字段! - !数值字段!.min()) / (!数值字段!.max() - !数值字段!.min()