topic Re: Calculate field questions in Data Management Questions

Calculate field questions

BrettGonslaves — Fri, 18 Mar 2016 16:17:08 GMT

I have a field with street names, there are duplicate names in this collum. I want to add a number to the end of the name with a dash and have the multiple names count up incrementally (i.e MAIN ST-01, MAIN ST-02, MAIN ST-03, B ST-01)

there are several segments that have the same street name and would like to have a incremental number associated with it and then start back to -01 for a different street name.

what do i need to do in the field calculator to accomplish this?

Re: Calculate field questions

DarrenWiens2 — Fri, 18 Mar 2016 16:24:47 GMT

See this thread for how you can create a dictionary to work with incremental numbers by class, in the field calculator: https://community.esri.com/message/595324#comment-595324

In that case, the dictionary would look like {1:x, 2:y, 3:z, ...} ...where x,y,z are incrementing.

In your case, the dictionary would look like {'MAIN ST-':x, 'B ST-: y, ...} where x,y are incrementing.

Re: Calculate field questions

BrettGonslaves — Fri, 18 Mar 2016 16:33:33 GMT

Being new to coding, what would the VB script or Pything script look like to accomplish this task?

Re: Calculate field questions

DarrenWiens2 — Sat, 11 Dec 2021 15:53:32 GMT

Codeblock (Python):

dict = {}
def myFunc(myClass):
  global dict
  dict[myClass] = dict.get(myClass, 0) + 1
  return myClass + "-" + str(dict[myClass])

Expression (change to your field name):

myFunc( !ST_NAME! )