Latest Contributions by JohannesLindner

A general form could look like this: // define which attributes to return var return_attributes = ["lastinspdate", "nextinspdate"] // load the featureset var fs = FeatureSetByName($map, "InspInspectionDates", ['central_asset_id', 'lastinspdate', 'nextinspdate'], false) // filter for id and dates in future var ref_id = $feature["CENTRAL_AS"] var dt = Now() var filt = "central_asset_id = @ref_id AND nextinspdate > @DT" // get the next future inspection date var filtered_fs = OrderBy(Filter(fs, filt), "nextinspdate") var cou = First(filtered_fs) if(cou == null) { return "No future inspection found" } var all_attributes = Dictionary(Text(cou))["attributes"] var popup_lines = [] for(var a in return_attributes) { var att = return_attributes[a] var val = all_attributes[att] var line = `${att}: ${val}` Push(popup_lines, line) } return Concatenate(popup_lines, TextFormatting.NewLine) This is useful if you want to keep the expression expandable to include more/less fields later. If you don't need that, you can just hardcode it: // define which attributes to return var return_attributes = ["lastinspdate", "nextinspdate"] // load the featureset var fs = FeatureSetByName($map, "InspInspectionDates", ['central_asset_id', 'lastinspdate', 'nextinspdate'], false) // filter for id and dates in future var ref_id = $feature["CENTRAL_AS"] var dt = Now() var filt = "central_asset_id = @ref_id AND nextinspdate > @DT" // get the next future inspection date var filtered_fs = OrderBy(Filter(fs, filt), "nextinspdate") var cou = First(filtered_fs) if(cou == null) { return "No future inspection found" } var popup_lines = [ `Last inspection: ${cou["lastinspdate"]}`, `Next inspection: ${cou["nextinspdate"]}`, ] return Concatenate(popup_lines, TextFormatting.NewLine) ... View more

Untested, supply your table and field names in lines 13 & 17. import arcpy def mean(values): values = [v for v in values if v is not None] try: return sum(values) / len(values) except ZeroDivisionError: raise ValueError("No non-null values in input list!") # get the morning and evening readings from the update table (dict with id as key) update_rows = { i: [m, e] for i, m, e in arcpy.da.SearchCursor("UpdateTable", ["GaugeID", "Morning", "Evening"]) } # update the gauge layer with arcpy.da.UpdateCursor("Gauges", ["GaugeID", "AverageReading"]) as cursor: for i, avg in cursor: try: avg = mean(update_rows[i]) except KeyError: print("GaugeID not found in update table: " + str(i)) continue except ValueError: print("Could not calculate average for GaugeID " + str(i)) continue cursor.updateRow([i, avg]) ... View more

This is expected behavior, current is different to a file path. When you use current, ArcGIS knows that you want to work with the currently opened project. When you use a file path, ArcGIS loads that project into RAM, without actually opening it in the application. IT does all its operations on that copy in RAM, regardless of whether you currently have opened that project or not. Your code works perfectly fine. Just add that piece at the end of it and then take a look at the copy: aprx.saveACopy(r"project_folder\ProjectCopy") You can also use the save() method, but for that to work, you need to call the script from outside the current project. ... View more

Maybe use the complete name in line 11? Database.DataOwner.PipelineJunction ... View more

Something like this? // split the field into single districts var districts = Split($feature.districts, ", ") // get a count for each district var counts = Dictionary() for(var i in districts) { var d = districts[i] counts[d] = IIf(HasKey(counts, d), counts[d], 0) + 1 } // combine districts and counts var output = [] for(var d in counts) { Push(output, counts[d] + " * " + d) } // return return Concatenate(output, ", ") ... View more

表达式返回“块”或“没有”。这些圣rings are used to show (block) or hide (none) the element in the popup's HTML code. To get what you want, you'll have to create a new expression that returns the inverse of the expression you have (just switch the return values in the IIf function). You can then create a new HTML element before Survey A: This solution is for Map Viewer Classic. If you're working with the current Map Viewer, you can also use an Arcade element, do all your decisions in there and return the HTML code. ... View more

Good catch, but this site would be riddled with semi-correct answers if I did this on purpose It was probably a copy/paste issue, I fixed it. Glad you got it to work! ... View more

Yes, it is because of null values. To fix it, you can insert this after line 7 to ignore features with null values in either field: fs = Filter(fs, "LGA IS NOT NULL AND Activity IS NOT NULL") ... View more

Export your table to a gdb and run either the Field Calculator or the script on that exported table. If the errors persist, I'm absolutely out of ideas. ... View more

I have no idea why this is happening... Try doing it with a Python script instead (not in the Field Calculator, in the Python Window): table = "TestPolygons" # the table path or layer name sort_field = "DateField1" # the sort field number_field = "IntegerField1" # the field that will be calculated i = 1 with arcpy.da.UpdateCursor(table, [number_field], sql_clause=[None, "ORDER BY {}".format(sort_field)]) as cursor: for row in cursor: row[0] = i cursor.updateRow(row) i += 1 ... View more

But this is for ArcGIS Pro, and I didn't realize that you posted this question in the ArcMap group. If you're working with ArcMap, it's much easier to do this task with a little Python script. Open your Python Window Paste in this script, edit the first three lines and execute (hit Enter). table = "TestPolygons" # the table path or layer name text_field = "TextField1" # the sort field number_field = "IntegerField1" # the field that will be calculated i = 1 with arcpy.da.UpdateCursor(table, [text_field, number_field], sql_clause=[None, "ORDER BY {}".format(text_field)]) as cursor: for row in cursor: row[1] = i cursor.updateRow(row) i += 1 ... View more

Switch language to Arcade, use this expression (change "TextField1" to the name of your field): var oid = $feature.OBJECTID var txt = $feature.TextField1 var previous = Filter($featureset, "TextField1 < @txt") var same_lower = Filter($featureset, "TextField1 = @txt AND OBJECTID < @oid") return Count(previous) + Count(same_lower) + 1 ... View more