Arcade Attribute Rules to Create Sequential Number within Quads

Question

Hello,

I am using Attribute Rules and want to automate assigning numbers to newly created layers within a polygon. Eg. If I create a point in quad 267N, I want to look for the last number used for that point feature within that quad, and assign it the next sequential number.  The script that I am working on returned an error when verifying, "Invalid expression. Error on line 9. String type expected"

// Layers
var valves = FeatureSetByName($datastore, "dwSystemValve");
var quad = FeatureSetByName($datastore, "AtlasGrid_AtlasBook");

// Get the geometry of the current valve
var valveGeometry = Geometry($feature);

// Find the quad that contains the current valve
var containingQuad = First(Intersects(quad, $feature));

// If no quad is found, return an error or default value
if (IsEmpty(containingQuad)) {
return "No quad found";
}

// Get the quad sheet number of the current quad
var sheetID = containingQuad.SHEET;

// Query valves within the same quad
var valvesInQuad = Filter(valves, "SHEET = @sheetID");

// If no valves exist in the quad, start from 1
if (IsEmpty(valvesInQuad)) {
return 1;
}

// Find the highest valve number in the quad
var maxValve = Max(valvesInQuad, "NUM");

// Return the next available number
return maxValve +1;

GIS_geek · Answer

Valve layer does not contain sheetID.  I believe using the Contains function is what I am looking for.  I need this process to only look at valves within the quad the new valve is created.

kenbuja · Answer

The way you have the Filter written in this line, it's expecting the valve layer to have a SHEET field.

var valvesInQuad = Filter(valves, "SHEET = @sheetID");

Do you have a field in the valve layer that contains that related sheetID values from the quad layer? Or do you need to use the Contains function to select the valves within the quad?

GIS_geek · Answer

Encountered and error in line 28, "Field not found SHEET".

Is expression in line 28 looking for SHEET in the valve layer? That field does not exist in the valve layer. It is in the quad layer.