nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Alternative to concatenate field values

PeterWilson

I'm creating a single feature class that will represent environmental areas within my study area. The environmental feature class is made up multiple feature classes that was merged, then union-ed . Each of the feature classes that were merged can contain a field "TYPE_RIV", "TYPE_WET", "TYPE_CBA", "TYPE_PROTECT".

What I'm trying to achieve is a better way of populating a new field "TYPE" that will concatenate the TYPE field (i.e. "TYPE_RIV", "TYPE_WET" etc.) values automatically based on the input environmental feature classes as this can differ from study area to study area. In other words in some cases there will be "TYPE_RIV", "TYPE_WET" and other cases there will be "TYPE_RIV", "TYPE_WET", "TYPE_CBA" lastly "TYPE_RIV", "TYPE_WET", "TYPE_CBA", "TYPE_PROTECT"

Once I've merged and union-ed the input feature classes, I'd like to identify the "TYPE_*" fields and concatenate the field fields into the new "TYPE" fields as per below:

End Result Required:

Current Code Block to Populate "TYPE" field

I can easily get the "TYPE_*" fields using s a list fields search, but how can an automatically populate the "TYPE" field concatenating the fields correctly based on the fields within the list as the if statements are hard coded and not sure how to get around the following.

Encontre mais publicações marcadas com

Accepted answers

All comments

DanPatterson_Retired

Joshua, yes, join is useful as well. I am just used to slicing since I work with arrays mostly for geometry and attributes. You could leave the strip out if you wanted to retain blank spaces should {} be used

On a simpler case, the mini-formatting language offers some nice options

>>> a
array([0, 1, 2, 3, 4, 5, 6, 7, 8, 9])
>>> b = ", ".join(str.strip(str(i)) for i in a)
>>> c = ("{}, "*len(a)).format(*a)[:-2]
>>> c1 = ("{!s:>03}, "*len(a)).format(*a)[:-2]
>>> c2 = ("{!r:>03}, "*len(a)).format(*a)[:-2]
>>> b
'0, 1, 2, 3, 4, 5, 6, 7, 8, 9'
>>> c
'0, 1, 2, 3, 4, 5, 6, 7, 8, 9'
>>> c1
'000, 001, 002, 003, 004, 005, 006, 007, 008, 009'

especially if you are replicating an input like a join string, the ("{...}"*len(...)) is an alternate.

JoshuaBixby

Just add a space after the comma with the join method:

>>> flds = ["hi  ", 2, None, "", "  bye"]  
>>> ", ".join(str.strip(str(x)) for x in flds if x not in ["",None])  
'hi, 2, bye'

PeterWilson

Hi Joshua

The "spaces" and "," are required between the strings i.e. "Rivers, Wetlands". The removal of the "spaces" and "," are those at the end of the concatenated string i.e. "Rivers, Wetlands,space"

JoshuaBixby

The str.join() method works well when concatenating like this, and one doesn't have to remove extra commas:

>>> flds = ["hi  ", 2, None, "", "  bye"]
>>> ",".join(str.strip(str(x)) for x in flds if x not in ["",None])
'hi,2,bye'

WesMiller

Use range and a field list see below.

field_list = ["field1","field2","field3"]
build = ""
for x in range(len(field_list)):
  build+=str(x)
print build
'012'

PeterWilson

Hi Dan

The problem is that I'm not sure how to get the field values without having to specify the field index and the last field row[2] = ""ENVIRO_TYPE", is the field I need to update. row[0] = "TYPE_RIV", row[1] = "TYPE_WET" this time but it won't always be the case. Any suggestions welcome

Print Statement:

# environmental features within each settlement
def environmental_features(enviro_input):
    enviro_intersect = []
    for fcs in enviro_input:
        orig_name = arcpy.Describe(fcs).name
        input_features = ["Settlements_Amended", orig_name]
        intersect_name = "{0}\\{1}_int".format("in_memory", orig_name)
        arcpy.Intersect_analysis(input_features, intersect_name)
        enviro_intersect.append(intersect_name)
    merge_name = "{0}\\{1}_merge".format("in_memory", "Environmental")
    arcpy.Merge_management(enviro_intersect, merge_name)
    diss_name = "{0}\\{1}_diss".format("in_memory", "Environmental")
    arcpy.Union_analysis(merge_name, diss_name, "ALL")
    field_name = "ENVIRO_TYPE"
    arcpy.AddField_management(diss_name, "ENVIRO_TYPE",
                              "TEXT",
                              field_length=100)
    field_names = [f.name for f in arcpy.ListFields(diss_name, "TYPE*", "TEXT")]
    cur_fields = list(field_names)
    cur_fields.append(field_name)
    print cur_fields
    with arcpy.da.UpdateCursor(diss_name, cur_fields)as ucur:  # @UndefinedVariable
        for row in ucur:
            print row[0], row[1], row[2]

Python Code:

DanPatterson_Retired

so are you needing to implement the good and frmt lines in my example? you have cur_fields which is the equivalent to my flds (assuming they are field names and not field objects), then you have the frmt line which removes any "" or None (which you now have because you must be working with a gdb). so did you try appending with mods the salient lines into your function? so row 23 is where you do the concatenation of those field values that have values. Cavaet...the order of the fields determines the order of the outputs, that is where the field calculator expression offers some flexibility

PeterWilson

Hi Dan

The following works great, just can't figure out how to use the following within an update cursor:

The following is how far I've gotten:

# environmental features within each settlement
def environmental_features(enviro_input):
    enviro_intersect = []
    for fcs in enviro_input:
        orig_name = arcpy.Describe(fcs).name
        input_features = ["Settlements_Amended", orig_name]
        intersect_name = "{0}\\{1}_int".format("in_memory", orig_name)
        arcpy.Intersect_analysis(input_features, intersect_name)
        enviro_intersect.append(intersect_name)
    merge_name = "{0}\\{1}_merge".format("in_memory", "Environmental")
    arcpy.Merge_management(enviro_intersect, merge_name)
    diss_name = "{0}\\{1}_diss".format(input_fgdb, "Environmental")
    arcpy.Union_analysis(merge_name, diss_name, "ALL")
    field_name = "ENVIRO_TYPE"
    arcpy.AddField_management(diss_name, "ENVIRO_TYPE",
                              "TEXT",
                              field_length=100)
    field_names = [f.name for f in arcpy.ListFields(diss_name, "TYPE*", "TEXT")]
    cur_fields = list(field_names)
    cur_fields.append(field_name)
    with arcpy.da.UpdateCursor(diss_name, cur_fields)as ucur:  # @UndefinedVariable
        for row in ucur:
            print row[0], row[1]

DanPatterson_Retired

Peter

You can construct a def from the example.

The key is to input your fields in the desired order of concatenation.

If a field is empty ("" or None, depending upont he database), then leave it out.

Format your concatenation string from a list of the good entries.

Pretend you have fields a,b,c,d,e with stuff inside...doesn't matter what, it will end up as a string, if unsure add {!s:} inside the curly braces. Play with this as a script, then 'def' it with

a = "A"
b = ""
c = "C"
d = None
e = "E"
flds = [a, b, c, d, e] # put in the ! marks
good = [ val for val in flds if val not in ["",None]] # LC omitting "", aka empty, can add None check
frmt = ("{},  "*len(good)).format(*good)
print(frmt[:-2])

play with this, if you want commas etc separating, you can play with string strip methods, but I prefer parsing the length.

so as a function, you only need to provide the field names in the correct order to the function, the names don't matter and the concatenation will proceed as expected, regardless of the number of fields or their content. Check my blog for List comprehension and formatting posts for more information

The ...py... links

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.