Latest Contributions by XanderBakker

Hi @PaulSweeney3 ,   Let me validate if I can perform the field calculation in ArcGIS Online. Can you confirm the output field name that should be filled with the result? If it does not work on ArcGIS Online, I can give it a shot and try to connect with ArcGIS Pro and perform the field calculation in Pro. Not sure if you have tried this already? ... View more

Hi @NoahLeimgruber , To include the min and max values in the range and also include the area of the polygon itself, you just need to change this line: if oid != oidcurr and lst[0] > h1 and lst[1] < h2: into this: if lst[0] >= h1 and lst[1] <= h2:   This will assign a catchment area value to all polygons:   ... View more

Hi @NoahLeimgruber ,   Looking a bit closer to the results I notice that in the Northern part there are some polygons with a huge catchment area. I also notice that they are summing the same polygon areas. If this is about catchments I don't think that this is hydrologically correct, but maybe the calculation has a different purpose.  ... View more

Hi @NoahLeimgruber , It seems to be working:    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

Hi @NoahLeimgruber ,   Thanks for sharing. I will have a look and post back any results or questions that may arrise.  ... View more

Hi @PaulSweeney3 , Thanks for sharing the data. I noticed that you didn't include the web map so I don't have access to any other Arcade expression configured in the pop-up. I used the code I posted earlier and just changed to way to access the poles and chambers and this is returned in the pop-up: Can you indicate what should be changed?   ... View more

Hi @NoahLeimgruber , I could write some code to do this, but it would be easier to have some (dummy) data with the same schema to test with. Any chance that you could share some (dummy) data for this? ... View more

Hi @NoahLeimgruber ,   I probably would advise you to use Python for this one and use a dictionary to store the values and easy access, although I wouldn't do this using a Field Calculation (preferably, I would use a standalone script). With Arcade you would probably end up using multiple requests on the data which would result in longer processing times.  However, is this "static" data or is this data dynamic and requires an update of this logic when data is edited? In that case I would probably go for an attribute rule using Arcade.   Just to be clear... when you calculate the catchment area for ID 1 you don't include the area of ID 1 in the result, right? ... View more