Latest Contributions by XanderBakker

Hi @AmyRoust ,   Some time ago I read that it is more performant to have multiple functions on the same line since this would reduce the number of requests to the server. This is something Paul Barker mentioned in his blog: https://www.esri.com/arcgis-blog/products/mapping/mapping/whats-new-with-arcade-taking-a-stroll-through-featuresets-part-2/    On the other hand, I have never been able to confirm this.    CC: @HusseinNasser2  ... View more

Hi @DianaWilson1 ,   I would probably do something like this: var ratio = $feature["YR1_RATIO"]; // replace by field name in your data if (IsEmpty(ratio)) { return "no data"; } else if (ratio <= 0.65) { return "less than or equal to 65%"; } else if (ratio <= 0.7) { return "from 66% to 70%"; } else if (ratio <= 0.75) { return "from 71% to 75%"; } else if (ratio <= 0.8) { return "from 76% to 80%"; } else if (ratio <= 0.85) { return "from 81% to 85%"; } else if (ratio <= 0.9) { return "from 86% to 90%"; } else if (ratio <= 0.95) { return "from 91% to 96%"; } else { return "96% and higher"; } ... View more

Hi @DianaWilson1 ,   You can use something like this: var ratio = $feature.Ratio; // replace by field name in your data if (ratio <= 0.65) { return "less than or equal to 65%"; } else if (ratio <= 0.7) { return "from 66% to 70%"; } else if (ratio <= 0.75) { return "from 71% to 75%"; } else if (ratio <= 0.8) { return "from 76% to 80%"; } else if (ratio <= 0.85) { return "from 81% to 85%"; } else if (ratio <= 0.9) { return "from 86% to 90%"; } else if (ratio <= 0.95) { return "from 91% to 96%"; } else { return "96% and higher"; }     ... View more

Hi @NoahLeimgruber , It seems to be working: XanderBakker_0-1606402284990.png    I did notice that there are some polygons that have -1 for the H1 and H2 values and many have an H2 values that is equal to H1 +1. When selecting only those polygons that are larger than H1 and smaller than H2, you will not get any resulting polygon and a catchment area of 0. Is that correct?   The code I used is: def main(): # load arcpy import arcpy # set reference to the featureclass fc = r'D:\GeoNet\CatchmentArea\Data.shp' # change this # create dictionary with H values and areas flds1 = ("OID@", "H1", "H2", "SHAPE@AREA") dct = {r[0]: [r[1], r[2], r[3]] for r in arcpy.da.SearchCursor(fc, flds1)} # start update cursor to write the catchment areas flds2 = ("OID@", "Einzugsgeb") with arcpy.da.UpdateCursor(fc, flds2) as curs: for row in curs: # read values oidcurr = row[0] # determine catchment area catchment = SumAreaInRangeH(oidcurr, dct) row[1] = catchment curs.updateRow(row) def SumAreaInRangeH(oidcurr, dct): # function to determine catchment area sumarea = -1 if oidcurr in dct: # set reference values h1 = dct[oidcurr][0] h2 = dct[oidcurr][1] sumarea = 0 for oid, lst in dct.items(): if oid != oidcurr and lst[0] > h1 and lst[1] < h2: sumarea += lst[2] return sumarea if __name__ == '__main__': main() ... View more