The code snippet appears to be from the ESRI Address Data Management Solution and specifically the Centerline ID and Copy Road Aliases rule, shown in it's entirety below. Xander Bakker, lines 16 & 17 above taken out of context are meaningless on their own; line 15 above is line 24 below.
I think that Hussein Nasser has hit the nail on the head. Courtney Dunn have you created the sequence first in you data base? The fgdb that comes with the solution should have it already. You can use the arcpy.da.ListDatabaseSequences() like this to see what is there. In a python window or the python ide of your choice:
import arcpy
gdb = r'C:\path\to\your\geodatabase'
for s in arcpy.da.ListDatabaseSequences(gdb):
print(f'Name = {s.name} StartValue = {s.startValue} IncrementValue = {s.incrementValue} CurrentValue = {s.currentValue})
If you are using an EGDB for your data, the da.ListDatabaseSequences() function isn't available. See arcpy.ListDatabaseSequences() for EGDB to vote for it or you can try to use what ESRI Tech Support provided me as a SQL work around which I haven't got to work yet.
Arcade rule below: (looping in Chris Fox too...)
// This rule will create a new unique id when a road centerline is created
// This will also copy related road alias names for any roads that were added as a result of a split
// Define the leading text and the delimiter for the ID
var prefix = "RD"
var join_char = "-"
// Define any fields to be copied from the road name aliases table (lower case)
var alias_field_names = ["roadpremod", "roadpredir", "roadpretype", "roadpretypesep", "roadname", "roadtype", "roadpostdir", "roadpostmod", "fullname", "municipality"]
// If the road was created from a split its oirginal id will have a prefix of '::'
// We will use this to find the original road and its related alias road names
if (Left($feature.centerlineid, 2) == "::" || IsEmpty($feature.centerlineid)) {
var id = Concatenate([prefix, NextSequenceValue("CenterlineID")], join_char)
// If the centerlineid is not set return the new id
if (IsEmpty($feature.centerlineid)) return id;
// Find the original ID of the road that was split
var original_id = Mid($feature.centerlineid, 2, Count($feature.centerlineid) - 2);
if (IsEmpty(original_id)) return id;
// Find all the related road alias names for the split road
// Store an add for every road alias and related it to the new road that was added after the cut
var adds = []
var roadNameAliases = Filter(FeatureSetByName($datastore, "AliasRoadName"), "centerlineid = '" + original_id + "'");
for (var roadNameAlias in roadNameAliases) {
var featureAttributes = Dictionary(Text(roadNameAlias))['attributes'];
var newAttributes = {};
for (var k in featureAttributes) {
if (IndexOf(alias_field_names, Lower(k)) > -1 && featureAttributes != null) {
newAttributes = featureAttributes;
} else {
continue;
}
}
newAttributes['centerlineid'] = id
adds[Count(adds)] = {
'attributes': newAttributes
}
}
// Using the edit parameter return the list of updates and adds for the intersecting roads and a list of adds for related road alias names
return {
'result': id,
'edit': [{'className': 'AliasRoadName', 'adds': adds}]
};
}
else {
return $feature.centerlineid
}
That should just about do it....
