Field Calculate taking hours to run on less than 20000 feature?

amarcz_cc

Hello,

I am running an arcade script on my Building Footprint Layer that takes all the points (Addresses) within, and concatenates them into a string and puts the values into a field. (see below)

However, this particular script is taking hours to run?

Data is within the same sde, in a SQL database, working in ArcPro 3.3

 

 

 

// Retrieve the ADDRESS feature set
var address_fc = FeatureSetByName($datastore, "DBO.MasterAddress", ['Address_Full', 'AddressType'], true);

// Initialize a string to store the Address_Full values
var address_string = "";

// Loop through the addresses and check if they are within the current building polygon
for (var addr in address_fc) {
    // Check if the address is within the current building polygon and has AddressType = "Address"
    if (Within(addr, $feature) && addr.AddressType == "Address") {
        // If this is not the first address, add a comma separator
        if (address_string != "") {
            address_string += ", ";  // Add comma separator
        }
        // Concatenate the address to the address_string
        address_string += addr.Address_Full;
    }
}

// Return the collected addresses as a comma-separated string
return address_string;

 

 

 

kenbuja

That line should be

Push(address_list, addr.Address_Full)