Latest Contributions by JohannesLindner

Just checked, this error occurs when you try to do an Intersects() with null geometries. Check your feature classes for empty geometries, for example with this Arcade expression in Calculate Field: return IIf(Geometry($feature) == null, "NULL GEOMETRY", null) ... View more

Sadly, I have no idea of field maps 😞 ... View more

Sorry to say that I have no clue. Try deleting the rule and creating it in 2.9. ... View more

The Intersects() function takes a Featureset and a Feature/Geometry and returns a Featureset of Features that intersect the input Feature. You're trying to intersect 2 Featuresets One of those (combinedDict) is actually a Dictionary, and even if it was a FS, it would have no features yet   You have to do the intersect before the GroupBy, because grouped Featuresets don't have geometries.   This is untested:   // define your input layers and their output status var p = Portal('https://mass-eoeea.maps.arcgis.com') var layers = [ { id: '12345x', subid: 1, query: "Point_Status = 'Stable'", file_number: 'SV_CGP_File_Number', out_status: 'Stable', }, { id: '12345x', subid: 1, query: "Point_Status = 'Unstable'", file_number: 'SV_CGP_File_Number', out_status: 'Unstable', }, { id: '12345x', subid: 1, query: "Point_Status = 'General Obs.'", file_number: 'SV_CGP_File_Number', out_status: 'General Observation', }, { id: '12345x', subid: 3, query: "R_Point_Status = 'Stable'", file_number: 'R_CGP_File_Number', out_status: 'Stable Revisit', }, { id: '12345x', subid: 3, query: "R_Point_Status = 'Unstable'", file_number: 'R_CGP_File_Number', out_status: 'Unstable Revisit', }, ] // load the watersheds var watersheds = FeatureSetByPortalItem(p, '4a7abb05f6eb42d78e31587b05e3ebec', 0, ['Label_Field'], false) // create an empty feature array var features = [] // iterate over the input layers for(var i in layers) { var layer = layers[i] // load and filter var fs = FeaturesetByPortalItem(p, layer.id, layer.subid, [layer.file_number], true) var filtered_fs = Filter(fs, layer.query) // iterate over the features for(var f in filtered_fs) { // get the intersecting watershed var i_ws = First(Intersects(f, watersheds)) var i_ws_name = IIf(i_ws == null, "No watershed", i_ws.Label_Field) // add the feature to the array var new_f = {attributes: { File_Number: f[layer.file_number], Pt_Status: layer.out_status, Watershed: i_ws_name, }} Push(features, new_f) } } // create a Featureset with all these features var combined_dict = { fields: [ {name: "File_Number", type: "esriFieldTypeString"}, {name: "Pt_Status", type: "esriFieldTypeString"}, {name: "Num_Inspections", type: "esriFieldTypeInteger"}, {name: "Watershed", type: "esriFieldTypeString"}, ], geometryType: "", features: features, } var combined_fs = Featureset(Text(combined_dict)) // GroupBy to get the counts var grouped = GroupBy( combined_fs, ["File_Number", "Pt_Status", "Watershed"], [{name: "Num_Inspections", expression: "1", statistic: "COUNT"}] ) return grouped     ... View more

Do you actually use this expression in 2.9? The expression should work for ArcGIS Pro 2.7+ ... View more

To post code:     However, the syntax is different when doing the code for pop-ups versus in the Dashboard List The main difference is that you have to return a Featureset for Dashboard elements.   Let me start by saying this: If all you're doing is removing the underscores, you're making it much too complicated. Your popup expression could look like this: // replace underscore with space return Replace($feature["WORKERS_ASSIGNED"], "_", " ")     Now, a data expression that goes through your Survey layer and replaces the underscores in the WORKERS_ASSIGNED field could look like this: // this is my test data //var fs = {geometryType:"",fields:[{name:"WORKERS_ASSIGNED",type:"esriFieldTypeString"}, {name:"X",type:"esriFieldTypeInteger"}],features:[{attributes:{WORKERS_ASSIGNED:"Joe_Biden", X:46}},{attributes:{WORKERS_ASSIGNED:"Donald_Trump", X:45}},{attributes:{WORKERS_ASSIGNED:"Barack_Obama", X:44}},{attributes:{WORKERS_ASSIGNED:"George_W_Bush", X:43}},{attributes:{WORKERS_ASSIGNED:"Bill_Clinton", X:42}},{attributes:{WORKERS_ASSIGNED:"George_H_W_Bush", X:41}},{attributes:{WORKERS_ASSIGNED:"Ronald_Reagan", X:40}}]} //fs = Featureset(Text(fs)) // load your Layer var fs = FeaturesetByPortalItem(...) // Copy the schema of your layer into a new emppty Featureset var fs_schema = Schema(fs) var out_fs = { geometryType: fs_schema.geometryType, fields: fs_schema.fields, features: [] } // loop over your Layer's features for(var f in fs) { // get the attributes var att = Dictionary(Text(f)).attributes // replace underscores att.WORKERS_ASSIGNED = Replace(att.WORKERS_ASSIGNED, "_", " ") // append the edited feature to the output featureset Push(out_fs.features, {geometry: Geometry(f), attributes: att}) } // return the output featureset return Featureset(Text(out_fs))   Be sure that you actually load your Layer in line 6. Using the FeaturesetByPortalItem function, you also can limit the fields you want to import. This is my test input   And the output it created   ... View more

I just tried it for my city. The given coordinates were way off. I then tried to get coordinates for specific addresses (basically using ChatGPT to geocode), and they also were completely wrong. Like, 15 kilometers away from the actual point. And when I regenerated answers, it gave me slightly different coordinates (ca. 50 meters difference). When I asked it to return a GeoJson with multiple geocoded addresses, it had this to say at the end: Somehow I doubt it really uses a geocoding API, or at least a very bad one.     ... View more

Yes, the geometry has to be included in this case. But Stefan's code didn't even get to that point, because the Includes function doesn't work for inner array:   ... View more