Latest Contributions by VincentLaunstorfer

Hi, Finally, I am trying to use the $layer global variable to loop through all features in order to sum acreage per cities. The Arcade expression makes an initial distinct list of cities in the $layer and then calculates acreage acreage accordingly for each $feature, as follow: var myArray = []; var i = 0; for(var z in $layer) { Insert(myArray, i, z.City); i = i + 1; } var myArrayDistinct = Distinct(myArray); var myArrayDistinctSort = Sort(myArrayDistinct); var acreage = 0; for(var a in myArrayDistinctSort) { for(var z in $layer) { if (z.City == myArrayDistinctSort[a]) { acreage = acreage + z.AreaGeodetic(z, 'acres'); } } } return acreage; but I still get an: Invalid expression. Error on line 3. Object not found $layer For info, I am using this Arcade expression in Calculate field tool. Any guess?   ... View more

Fantastic! I will try that. I knew there was something easy. Appreciated ... View more

You think setting up a dialog box properties for the Python script with a parameter (sys.arg[1]) defined as Layer multiple value, is read as a String? Should I read this parameter in a loop and assign the values to the List? I though it may come from the script expecting a layer name only, and not the entire layer name with path... I will try to 'hard-code' the layer name making a list with a single entry... ... View more

Hi Johannes, I found your python script really interesting as there is no easy solution to export symbology labels to table or field. However, I still get an error when trying to run your script. I simply changed the first line in order to drag & drop layers from the current/active projects, using: layer_names = sys.argv[1] And I get the following error: layer = aprx.activeMap.listLayers(name)[0] IndexError: list index out of range It should be obvious to fix but I do not have much experience with the arcpy mp module and I am stuck. Any help would be appreciated. Thanks layer_names = sys.argv[1] aprx = arcpy.mp.ArcGISProject("current") for name in layer_names: # get the layer layer = aprx.activeMap.listLayers(name)[0] # get the symbology fields and items renderer = layer.symbology.renderer fields = renderer.fields items = renderer.groups[0].items # create a dict {values: label} item_dict = {tuple(i.values[0]): i.label for i in items} # add a new field arcpy.management.AddField(layer, "Unit", "TEXT") # insert the label values with arcpy.da.UpdateCursor(layer, ["Unit"] + fields) as cursor: for row in cursor: key = tuple([str(x) for x in row[1:]]) # item.values stores values as string try: row[0] = item_dict[key] cursor.updateRow(row) except KeyError: # no symbology found pass   ... View more

Are you looking at .dbf in particular? .dbf are old-fashioned and have perhaps some limitations... Using the Export Table Geoprocessing tool, you can explicitly specify the output file format with an extension. I would recommend trying simple .txt or .csv outputs and look if you problem is still here. https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/export-table.htm   ... View more

Fantastic! Good to know array values has to be casted to text for 'if' statments... Very useful. ... View more

Instead of fiddling with cumbersome IIf arcade statment, I just ticked 'show values out of range' and it works. All features are displayed on the map, whether or not having 'null' values. ... View more

Classes are set to 1 because only 1 value '0' is computed (or bugged). I cannot change classes to anything else because only '0' exists. Feature having 'null' values do display correctly on the map with the '0' graduated color... I just discovered that the Arcade IIf statement works correctly with 'Single Symbol' symbology. It looks like IIf custom statment in Symbology using Graduated Colors is not supported in ArcGIS Pro! ... View more

Interestingly, if I reverse the logic, if the 'sector' attribute is 'null', keep the existing value, otherwise output 99. I get the same 0 value for the graduated symbology!   IIf (IsEmpty($feature.Sector), $feature.Sector, 99);   ... View more

Hi, Really nice, it works and I like the 'inverted' logic to avoid the else statment. Moreover, I have a similar Arcade code and it never go to the else statment!   if($feature.Date != '2019'){ var census = ($feature.census); var startDate = 2019; var features = Filter($featureSet, "date = " + startDate + " AND census = " + census); var featureFirst = First(features); if(features != null){ var growth = (($feature.Totals_by_Tract_by_Sector/featureFirst.Totals_by_Tract_by_Sector)-1)*100; } return growth; } else { return '99'; } Strange ... View more

Thanks. I already tried the proper 'SQL' like AND, but still no luck! I included your 'null' logic to safeguard my Arcade code   if($feature.Date != '2019'){ var census = Text($feature.census); var startDate = '2019'; var features = Filter($featureSet, "date = @startDate AND census = @census"); var featureFirst = First(features); if(dic == null){ return '0'} else { var growth = (($feature.Totals_by_Tract_by_Sector/featureFirst.Totals_by_Tract_by_Sector)-1)*100; } } else { return '0' }   ... View more