Latest Contributions by JohannesLindner

#arcpy.CalculateField_management("UT_CROSSING","DISCREPTION","!COMPANY!" + " " + "!LOCATION!" + " " + "!TYPE!" + " " + "!SIZE!" ,"PYTHON") # this gives the following string, which isn't a valid python expression, into CalculateField: #expr = "!COMPANY! !LOCATION! !TYPE! !SIZE!" # What you want to do is something like this: # Notice that the expression is wrapped in single quotes expr = '!COMPANY! + " " + !LOCATION! + " " + !TYPE! + " " + !SIZE!' # even better expr = '" ".join([!COMPANY!, !LOCATION!, !TYPE!, !SIZE!])' arcpy.CalculateField_management("UT_CROSSING","DISCREPTION",expr ,"PYTHON")   Or use Arcade: expr = 'Concatenate([$feature.COMPANY, $feature.LOCATION, $feature.TYPE, $feature.SIZE], " ")' arcpy.CalculateField_management("UT_CROSSING","DISCREPTION",expr ,"ARCADE")     ... View more

Yeah, filtering by date can be iffy, as different DBMSs handle it differently. Try converting your date to a string: var inspectionDate = Text($feature.DATE, "Y-M-D") ... View more

A simple if/else is not going to work here, because any number of purpose fields can have values. If you do a simple if/else chain like below, only the first purpose will be returned, completely ignoring possible other purposes. // THIS IS WRONG, DON'T DO THIS if(!IsEmpty($feature.PurposeA)) { // if PurposeA is filled ("Butterfly Garden" in the example), the expression will end here. // Other purpose fields (PurposeD - "Dog Garden") will be ignored! return $feature.PurposeA } if(!IsEmpty($feature.PurposeB)) { return $feature.PurposeB } if(!IsEmpty($feature.PurposeC)) { return $feature.PurposeC } if(!IsEmpty($feature.PurposeD)) { return $feature.PurposeD } ... View more

// build an array of the purpose field values var purposes = [ $feature.PurposeA, $feature.PurposeB, $feature.PurposeC, $feature.PurposeD, $feature.PurposeE ] // use that to build an array of non-empty purpose values var non_empty_purposes = [] // empty array for(var p in purposes) { // loop through purposes if(!IsEmpty(purposes[p])) { // if purpose is not empty (null or "") Push(non_empty_purposes, purposes[p]) // append to array } } // return the concatenated array as string return Concatenate(non_empty_purposes, ", ") ... View more

Ah. Then the script gets easier. Select the feature you want to update in the master layer. If the input layer has more than one record, select the corresponding feature there, too. Run the script in the python window. You just have to edit lines 1 and 2. input_layer_name = "name_of_the_input_layer" master_layer_name = "name_of_the_master_layer" active_map = arcpy.mp.ArcGISProject("current").activeMap input_layer = active_map.listLayers(input_layer_name)[0] master_layer = active_map.listLayers(master_layer_name)[0] new_shape = [r[0] for r in arcpy.da.SearchCursor(input_layer, ["SHAPE@"])][0] with arcpy.da.UpdateCursor(master_layer, ["SHAPE@"]) as cursor: for row in cursor: cursor.updateRow([new_shape])   ... View more

Glad to have helped. Please accept the answer so that the question is marked as solved. ... View more

Yeah, no wonder it goes crazy. Your HTML is pure chaos. It doesn't close the style declaration of the td, it doesn't close the td or the tr, it tries to close a div (???) but uses the wrong sign. Also, you have the tr outside of the table... It's a good idea to write each tag on its own line, with indentation, and to close a tag before you work on its content. That way, you catch things like that more easily and the HTML becomes more readable. You can always shorten the code after making sure it works. <table style="width:100%;"> <tbody> <tr style="display:{expression/expr8};"> <td style="padding:5px;background-color:{expression/expr12};"> <b>The following equipment is stored in the warehouse</b> </td> </tr> <!-- other tr's --> </tbody> </table>   Also, make sure that you actually have a default value in the When function in expr12. https://developers.arcgis.com/arcade/function-reference/logical_functions/#when  ... View more

If the input and master layers have a common field: geometry_layer_name = "name_of_the_layer_with_the_right_geometry" attribute_layer_name = "name_of_the_layer_with_attributes_and_wrong_geometry" common_field = "name_of_the_common_field" # this will change the geometry of the second layer's underlying data, so back it up! active_map = arcpy.mp.ArcGISProject("current").activeMap geometry_layer = active_map.listLayers(geometry_layer_name)[0] attribute_layer = active_map.listLayers(attribute_layer_name)[0] # read the correct geometries and save them in a dictionary # {common_field_value: shape} cursor = arcpy.da.SearchCursor(geometry_layer, [common_field, "SHAPE@"]) shapes = dict([row for row in cursor]) # loop through the second layer and update the geometries updated_features = [] with arcpy.da.UpdateCursor(attribute_layer, [common_field, "SHAPE@"]) as cursor: for row in cursor: try: new_shape = shapes[row[0]] # only update if the geometry is different, fill the updated_features list if not new_shape.equals(row[1]): cursor.updateRow([row[0], new_shape]) updated_features.append(row[0]) except KeyError: print("No new geometry found for feature with {} = {}".format(common_field, row[0])) # build an SQL query of the updated_features, depending on whether common_field is a text field or not if updated_features and isinstance(updated_features[0], str): sql = "{} IN ('{}')".format(common_field, "', '".join(updated_features)) else: sql = "{} IN ({})".format(common_field, ", ".join([str(uf) for uf in updated_features])) # print the SQL query print("Updated the geometry of {} features:\n{}".format(len(updated_features), sql))   ... View more

Ah, so your field formatting isn't consistent. It isn't a bug, it's exactly what you told the computer to do. Take a look at your expressions: Split($feature.Equipment, ",") // "Car,Boat" -> ["Car", "Boat"] // "Car, Boat" -> ["Car", " Boat"] // -> Test for "Boat" will fail in the second case Yeah, removing the spaces in the table would be good. Alternatively (or additionally), you can also remove the spaces in the expression: Split(Replace($feature.Equipment, " ", ""), ",")   ... View more