Saturday, July 8, 2017

VB - Field calculator

Field calculator

xxxxxxxxxxxxxxxxxxxx

** This script generates "1" for the whole number contours and rest 0 to symbolize the contours in a better way.

def myCalc(val):
  if (val % 1 == 0):
    return 1
  else:
    return 0
__esri_field_calculator_splitter__
myCalc( !CONTOUR!)


xxxxxxxxxxxxxxxxxxxx

** Merge rows as per the column criteria

def myCalc(fld,mg):
  mer = mg
  global merge
  if (fld <=12):
    merge = mer
    return mer
  else:
    return merge
__esri_field_calculator_splitter__
myCalc( !FloodDepth!, !MergeItem! )

xxxxxxxxxxxxxxxxxxxx

**Changing Labels

def myCalc(num):
  if (num == 1 ):
    return "0-1"
  elif num == 2:
    return "1-2"
  elif num == 3:
    return "2-3"
  elif num == 4:
    return "3-4"
  elif num == 5:
    return "4-5"
  elif num == 6:
    return "5+"
__esri_field_calculator_splitter__
myCalc( !FloodDepth! )

No comments:

Post a Comment