Latest Contributions by JohannesLindner

You're actually never using the feature set. You use $feature["B03..."] instead. Do your features have these fields?   It seems as if you're trying to do something like this: // load feature set from Living Atlas var portal = Portal("https://www.arcgis.com") var popu_all = FeatureSetByPortalItem(Portal, "23ab8028f1784de4b0810104cd5d1c8f",2, ['B03002_003E','B03002_004E','B03002_005E','B03002_006E' ,'B03002_007E','B03002_008E','B03002_009E','B03002_012E'] , true); // intersect with the feature you clicked on var popu = Intersects(popu_all, $feature) // get sum of categories of all intersected population polygons var fields = [ { value: Sum(popu, "B03002_003E"), alias: "White Alone, not Hispanic" }, { value: Sum(popu, "B03002_004E"), alias: "Black or African American Alone, not Hispanic" }, { value: Sum(popu, "B03002_005E"), alias: "American Indian and Alaska Native Alone, not Hispanic" }, { value: Sum(popu, "B03002_006E"), alias: "Asian Alone, not Hispanic" }, { value: Sum(popu, "B03002_007E"), alias: "Native Hawaiian and Other Pacific Islander Alone, not Hispanic" }, { value: Sum(popu, "B03002_008E"), alias: "Some Other Race Alone, not Hispanic" }, { value: Sum(popu, "B03002_009E"), alias: "Two or More Races, not Hispanic" }, { value: Sum(popu, "B03002_012E"), alias: "Hispanic or Latino" } ]; // get the predominant category function getPredominantCategory(fieldsArray){ var maxValue = -Infinity; var maxCategory = ""; for(var k in fieldsArray){ if(fieldsArray[k].value > maxValue){ maxValue = fieldsArray[k].value; maxCategory = fieldsArray[k].alias; } else if (fieldsArray[k].value == maxValue){ maxCategory = maxCategory + "/" + fieldsArray[k].alias; } } return IIF(maxValue <= 0, null, maxCategory); } getPredominantCategory(fields); ... View more

So you have some sort of chainage going on, where entities are connected to each other, but they don't form one big network but multiple small ones. You want to assign IDs to these small networks. Does this come close to what you want? # output dict groups = dict() group_id = 100000000 # keys that already are in a group visited_keys = set() for key in sample_dict: if key not in visited_keys: # to prevent processing the same group multiple times # create the group this key belongs to group = set() # use a heap/stack to process all keys belonging to that group heap = {key} while heap: # while there are keys to be processed k = heap.pop() # take the last key from the heap group.add(k) # add it to the group visited_keys.add(k) # mark it as visited # add all the keys connected to k to the heap (empty list if there are no other keys) heap.update(sample_dict.get(k, [])) # add all the keys that k is connected to to the heap heap.update([a for a, b in sample_dict.items() if k in b]) # remove all visited keys from the heap to prevent infinite loop heap -= visited_keys # assign ID to the group and add it to output dict # PLEASE DON'T ASSIGN YOUR ID WITH random.randint! # it's ugly, it's not guaranteed to be unique, you will hate yourself # when you have to add a group manually. # Either use a Universally Unique ID [python: uuid.uuid4()] # or increment a counter like I do here groups[group_id] = group group_id += 1 for group_id, group in groups.items(): print(group_id, group)   print(list(UIDs.values())[0]) #[1, 3, 2, 115247, 23] print(list(groups.values())[0]) #{1, 2, 3, 37, 115241, 115247, 23} ... View more

To insert code:   You are trying to input a tuple of (FeatureSet, Text) into the Left function, which is not a valid argument. According to the docs, the first argument can be Text, Array, Number, or Boolean. You have to fill your feature set sequencially: var fs = FeatureSetByPortalItem(Portal('https://arcgis.com'),'e7ad315d17a742fda44fb63cd311152a', 0, ['ZONE'], false) var novy = { 'fields': [{'name':'Zona', 'type':'esriFieldTypeString'}], 'geometryType': '', 'features': [] } for(var f in fs) { var new_f = {'attributes': {'Zona': Left(f.ZONE, 2)}} Push(novy.features, new_f) } return FeatureSet(Text(novy))   ... View more

var fs = FeatureSetByRelationshipName(...) // if you clicked on a feature where pkida == 1, then only the first 3 entries // of your example table will be in fs. // you can do various things with that feature set: // return the number of saving accounts var fs_savings = Filter(fs, "Service = 'Savings'") return Count(fs_savings) // just return "Yes" if there is at least one "Savings" entry, "No" otherwise if(Count(fs_savings) > 0) { return "Yes" } return "No" // return the sum of all savings accounts return Sum(fs_savings, "Balance") // return a total balance fs_loans = Filter(fs, "Service = 'Loan'") fs_shares = Filter(fs, "Service = 'Shares'") return Sum(fs_savings, "Balance") + Sum(fs_shares, "Balance") - Sum(fs_loans, "Balance") ... View more