Latest Contributions by JohannesLindner

Yes, you need to do both edits in the same dictionary. To do that, it's best to restructure the expression a little: // get all features belonging to the same basin and sewer extension var basin_id = $feature.Basin_ID var ba_query = "Basin_ID = @basin_id" var extension = $feature.Extension var se_query = "Extension = @extension" if($editcontext.editType == "DELETE") { // exclude this feature if we're deleting it var ba_gid = $feature.GlobalID ba_query += " AND GlobalID <> @ba_gid" var se_gid = $feature.GlobalID se_query += " AND GlobalID <> @SE_gid" } var wastewater_loads = Filter($featureset, ba_query) var sewer_loads = Filter($featureset, se_query) // get the total var ba_total_gallons = Sum(wastewater_loads, "gallons") var se_total_gallons = Sum(sewer_loads, "gallons") // construct the edit array var edit = [] var basin = First(FeaturesetByRelationshipName($feature, "Basins_CAF")) if(basin != null) { var basin_edit = { className: "Basins", updates: [{ globalID: basin.GlobalID, attributes: {TGallons: ba_total_gallons} }] } Push(edit, basin_edit) } var sewer = First(FeaturesetByRelationshipName($feature, "Sewer_by_CAF")) if(sewer != null) { var sewer_edit = { classname: "Sewer_Extensions", updates: [{ globalID: sewer.GlobalID, attributes: {CafCAP: se_total_gallons} }] } Push(edit, sewer_edit) } // return the dictionary to edit feature classes return {edit: edit}   Note: You're missing a space before AND in the query in line 12! ... View more

Glad to have helped. Please select an answer as solution so that this question is shown as answered. ... View more

You will have to write the code for loading the featuresets, but you can do the intersection in a loop. var test_featuresets = [ FeaturesetByName($datastore, "line_a", ["*"], false), FeaturesetByName($datastore, "polygon_b", ["*"], false), FeaturesetByName($datastore, "polygon_c", ["*"], false), ] for(var i in test_featuresets) { var inter = First(Intersects(test_featuresets[i], $feature)) if(inter != null) { return {"errorMessage": "polygon A features must not be intersected with others."} } } return true     Sidenote: Not too sure about that, but I think you have to return a boolean. errorMessage is for Calculation rules. So you probably want to change the return to false and input the error message in the Validation rule window. ... View more

This is easily achievable with Attribute Rules. If your point feature classes are in the same database as the line feature class, and the point id field has the same name in all point fcs, you can use this expression. Be sure to change the names of the point fcs in lines 14-16, the name of the point id field in lines 34 and 39, and the from and to field names in line 44. // Calculation Attribute Rule on the line fc // field: leave empty! // triggers: insert, update // if we're updateing and the geometry didn't change, abort if($editcontext.editType == "UPDATE") { var cur_geom = Geometry($feature) var prev_geom = Geometry($originalfeature) if(Equals(cur_geom, prev_geom)) { return } } // load the point fcs var point_fcs = [ FeaturesetByName($datastore, "PointFC1"), FeaturesetByName($datastore, "PointFC2"), FeaturesetByName($datastore, "PointFC3"), ] // get the line's start and end point var start_point = Geometry($feature).paths[0][0] var end_point = Geometry($feature).paths[-1][-1] // find the ids of the points intersecting the line's start and end point var start_id = null var end_id = null for(var p in point_fcs) { // get the points intersecting the line var intersecting_points = Intersects($feature, point_fcs[p]) // if start_id is still null, try to get the id of the first point intersecting the line's start point if(start_id == null) { var candidate = First(Intersects(start_point, intersecting_points)) if(candidate != null) { start_id = candidate.PointID } } // if end_id is still null, try to get the id of the first point intersecting the line's end point if(end_id == null) { var candidate = First(Intersects(end_point, intersecting_points)) if(candidate != null) { end_id = candidate.PointID } } } return { result: {attributes: {FromNode: start_id, ToNode: end_id}} } ... View more

I tried matching what you did for the date field.   What we did with the date field is not applicable here. For the date field, we have to decide which one of two fields to update based on the inspection reason. For this problem, you want to copy the value in MaintenanceReason over to parent.MaintenanceActivityStatus. If there is no such value, don't edit the parent field. You can do that with a simple if statement (and remove your update_field part): if($feature.MaintenanceReason != null) { update.attributes["MaintenanceActivityStatus"] = $feature.MaintenanceReason }   All together: // abort if there is no ParnetGUID var parent_id = $feature.ParentGUID if (IsEmpty(parent_id)) { return parent_id } // get the inspection status var inspection_status= When( $feature.InspectionReason == "Condition Rating" && $feature.OtherDrainageRatable == "Yes", "Inspection Completed", $feature.InspectionReason == "Condition Rating" && $feature.OtherDrainageRatable != "Yes", "Inspection attemted", null // default value, for example when InspectionReason is not "Condition Rating" ) // get the date field that should be updated var date_field = When( $feature.InspectionReason == "Condition Rating", "LastConditionRatingInspectDate", $feature.InspectionReason == "Maintenance Activity", "LastMaintenanceActivityDate", null // some other inspection reason ) // construct the update instructions var update = {"globalID": parent_id, "attributes": {}} update.attributes[date_field] = $feature.InspectionDate update.attributes["ConditionRatingInspectionStatus"] = inspection_status if($feature.MaintenanceReason != null) { update.attributes["MaintenanceActivityStatus"] = $feature.MaintenanceReason } return { 'edit': [{ 'className': 'CTDOT_Planning_OtherDrainage', 'updates': [update] }] } ... View more

To post formatted code:     You can massively simplify your rule. It should work with a regular coordinate system. I didn't test it with a custom system, but maybe it works there, too. var geom = Geometry($feature) var z = IIf($feature.LIFECYCLESTATUS == 1, 1, 0) return Point({"x": geom.x, "y": geom.y, "z": z, "spatialReference": geom.spatialReference}) ... View more

So the things you need to know for this are the logical operators in Arcade. ==    equal !=     not equal, <, <=, >, >=    less than, less than or equal, greater than, greater than or equal &&   and ||       or You can write your logic like this: var rating_status = When( $feature.InspectionReason == "Condition Rating" && $feature.OtherDrainageRatable == "Yes", "Inspection Completed", $feature.InspectionReason == "Condition Rating" && $feature.OtherDrainageRatable != "Yes", "Inspection attemted", null // default value, for example when InspectionReason is not "Condition Rating" )     And if we combine that with the rule from your previous question: // abort if there is no ParnetGUID var parent_id = $feature.ParentGUID if (IsEmpty(parent_id)) { return parent_id } // get the inspection status var inspection_status= When( $feature.InspectionReason == "Condition Rating" && $feature.OtherDrainageRatable == "Yes", "Inspection Completed", $feature.InspectionReason == "Condition Rating" && $feature.OtherDrainageRatable != "Yes", "Inspection attemted", null // default value, for example when InspectionReason is not "Condition Rating" ) // get the date field that should be updated var date_field = When( $feature.InspectionReason == "Condition Rating", "LastConditionRatingInspectDate", $feature.InspectionReason == "Maintenance Activity", "LastMaintenanceActivityDate", null // some other inspection reason ) // construct the update instructions var update = {"globalID": parent_id, "attributes": {}} update.attributes[date_field] = $feature.InspectionDate update.attributes["ConditionRatingInspectionStatus"] = inspection_status return { 'edit': [{ 'className': 'CTDOT_Planning_OtherDrainage', 'updates': [update] }] } ... View more