Using Intersect Attribute Rule on Overlapping Polygons?

amarcz_cc

Hello,

My Problem: I wanted to use an Attribute Rule on my Address layer (APN field) to intersect the Parcel layer and return the APN field with the proper feature.. The problem I am running into, is that the Parcel layer has overlapping polygons in some area and my logic can only figure out how to return the 1st intersect.

My Goal: To use a attribute rule that intersects the Parcel & does something similar to the logic below:

for Parcel.APN

if Parcel.Unit is not null

if Address.Unit == Parcel.Unit 

    return Parcel.APN

else return First on Parcel.APN intersect.

I am not sure add this functionality into my script.

I am able to get the return first using:

 

 

 

 

var fsParcel = FeatureSetByName($datastore, "Parcel", ["APN"])
var fsParcelIntersect = Intersects(fsParcel, $feature)
var Parcel = First(fsParcelIntersect)

return Iif(IsEmpty(Parcel), Null, Parcel.APN);

 

 

 

 

 But am lacking the logic and understanding to include an if statement that works.

Any help would be appreciated.

JohannesLindner

Your syntax is OK.

You don't need the elses here, because when you return, the rest of the code gets skipped and isn't executed. But that's a small, optional thing.

Back() only works on arrays, not on feature sets, I just added an idea to change that.

So to return the last feature, you need to sort the featureset. Assuming you have some key field (I use OBJECTID here), you could do it like that:

var fsParcel = FeatureSetByName($datastore, "Parcel", ["OBJECTID", "APN", "SitusUnitNumber", "SitusStreetNumber"])
var fsParcelIntersect = OrderBy(Intersects(fsParcel, $feature), "OBJECTID")

// loop through parcel features
for (var Parcel in fsParcelIntersect) {
    // unit number is not empty and matches -> return APN
    if (Parcel.SitusUnitNumber != null && Parcel.SitusUnitNumber ==$feature.Unit){
        return Parcel.APN
    }
    // unit number is empty, but street number matches -> return APN
    if (Parcel.SitusUnitNumber == null && Parcel.SitusStreetNumber == $feature.Add_Number){
       return Parcel.APN
    }
    // both unit number and street number are empty/0 -> return last parcel's APN
    if (Parcel.SitusUnitNumber == null && Parcel.SitusStreetNumber == "0"){
        // to get the last feature, reverse the featureset and call First()
        var LastParcel = First(OrderBy(fsParcelIntersect, "OBJECTID DESC"))
        return Iif(IsEmpty(LastParcel), Null, LastParcel.APN)
    }
}
// if we land here, none of the intersected parcels has the address's Unit
// returns first intersect
var Parcel = First(fsParcelIntersect)
return Iif(IsEmpty(Parcel), Null, Parcel.APN)

 

I don't really understand your last check. If both SitusUnitNumber and SitusStreetNumber are empty (I guess that what "0" represents), why do you want to get the last parcel instead of just letting the loop get to the next parcel?