Latest Contributions by JohannesLindner

The really easy way: Create a database sequence // Calculation Attribute Rule // trigger: Insert // field:CW_ID var seq = NextSequenceValue("SequenceName") return "SAN" + seq     If for some reason you can't create sequences, you'll have to do it the harder way: // Calculation Attribute Rule // trigger: Insert // field:CW_ID // get the latest feature with a CW_ID var last_feature = First(OrderBy(Filter($featureset, "CW_ID IS NOT NULL"), "OBJECTID DESC")) // get the last CW_ID and add 1 var seq = IIf(last_feature == null, 0, last_feature.CW_ID) + 1 return "SAN" + seq ... View more

You can do it with symbol property connections and Arcade, using the $view global. In your polygon symbology, add a marker layer Set it to this shape, deactivate proportional scaling   Set the placement and position parameters   Allow symbol property connections   Switch to the text element, set the angle to 0°, set the text properties to appropriate values (I'm using centered, 12 pt, some vertical offset)   Activate the attribute mapping for the  Text string parameter, enter a custom Arcade expression. Use this script, switch to your units       // If you don't have a distance attribute, calculate the radius yourself // This will be inexact! var a = Area($feature, "square-meters") var r = Sqrt(a / PI) // Else just use your distance field //var r = $feature.BUFF_DIST return Round(r, 1) + " m"​       Switch to the line element, activate the attribute mapping for the Size parameter, use this expression       // Like before //var a = Area($feature, "square-meters") //var r = Sqrt(a / PI) var r = $feature.BUFF_DIST return r / $view.scale * 2835 // I have no idea where the 2835 is coming from. I guess it has something to do with my map's / monitor's DPI. // It might be a different number for your units and setup.         Scale 1:20.000   Scale 1:50.000   Scale 1:10.000   Note that the displayed radius is not exact. I used 500, 750, and 1000 meters. But the Area() function densifies the COGO lines of the buffers to like 35 vertices, which shaves off some area around the rim. ... View more

Select the unwanted rows with Select Layer By Attribute or with a definition query   Use this with Calculate Field (This changes the data, make a backup!) # ID = next_sas_02_sequence() # Code Block sas_counter = 5700 def next_sas_02_sequence(): global sas_counter sas_02_sequence = f"SAS-02-{sas_counter:05}" sas_counter += 1 return sas_02_sequence     ... View more

I can't test on an SDE, but this code has worked before: import arcpy, pandas domains = arcpy.da.ListDomains("C:/bla/database.sde") # create an empty to-dimensional list to store the domain data rows = [] column_names = ["DomainName", "DomainType", "Index", "Code", "Description", "Min", "Max"] # fill the list for domain in domains: if domain.domainType == "Range": row = [domain.name, domain.domainType, 0, None, None, domain.range[0], domain.range[1]] rows.append(row) else: for i, (k, v) in enumerate(domain.codedValues.items()): row = [domain.name, domain.domainType, i, k, v, None, None] rows.append(row) # convert to DataFrame dataframe = pandas.DataFrame(rows, columns=column_names) # export dataframe.to_csv("C:/bla/domains.csv", index=False) dataframe.to_excel("C:/bla/domains.xlsx", index=False)   ... View more

Your first two examples don't return the data you expect because you take the first feature of the layer, not the feature you clicked on. To access the current feature, use the $feature global, like you did in your third example. I think your third example doesn't work because Arcade only loads fields if they are used in the expression.  This works great if you explicitly call your fields by using $feature["Field"] or $feature.Field . It doesn't work when you access fields by variable like $feature[fieldName]. In cases like this, you should tell Arcade to load all fields using Expects(). // define the requested field names var fieldsToInclude = ["objectid", "TextField1"] // Calling fields by variable instead of string literal can be icky, // so we should tell Arcade that we expect all fields to be loaded Expects($feature, "*") // create a dictionary of {fieldName: fieldAlias} var fieldData = Schema($feature).fields var aliases = {} for(var f in fieldData) { aliases[fieldData[f].name] = fieldData[f].alias } // define an empty array that stores the output lines var popupLines = [] // loop over the requested field names for(var f in fieldsToInclude) { // get the name, alias, and value of the field var fName = fieldsToInclude[f] var fAlias = aliases[fName] var fValue = $feature[fName] // if value is valid, append it to the array if(!Includes([null, 0, "", " "], fValue)) { Push(popupLines, `${fAlias}: ${fValue}`) } } // concatenate and return return Concatenate(popupLines, TextFormatting.NewLine)   ... View more

Yes. If it can't convert the string into a number, the conversion will fail. You need to strip out the character: # NewField = convert(!OldField!) # Code Block def convert(x): try: x = x.replace('"', '') return float(x) except: return None ... View more

Assuming your points are ordered: Run Points To Line Copy/Paste the script below into your Python Window (without lines 79 and after) and call divide_lines_into_straight_lines alternatively, turn the script into a script tool and run that (also enclosed at end of this post)   import arcpy import math from pathlib import Path # function to divide a list of vertices def divide_path_into_straight_paths(path, angle_tolerance): """ Divides an arcpy line path into straight parts. path: [arcpy.Point], the vertices of the path angle_tolerance: float, difference of consecutive angles (in degrees) between vertices smaller than this value are considered to be straight Returns the split paths as [[arcpy.Point]] """ segments = [ [path[i-1], path[i]] for i in range(1, len(path)) ] angles = [ math.degrees(math.atan2(s[0].Y - s[1].Y, s[0].X - s[1].X)) % 180 # % 180 to get the same angle regardless of vertex order for s in segments ] split_paths = [] split_path_angles = [] for i, (segment, angle) in enumerate(zip(segments, angles)): if i == 0: split_paths.append(segment) split_path_angles.append([angle]) continue angle_difference = abs(angle - angles[i-1]) if angle_difference > 90: angle_difference = abs(angle_difference - 180) # to make 179° comparable to 1° if angle_difference <= angle_tolerance: split_paths[-1].append(segment[-1]) split_path_angles[-1].append(angle) else: split_paths.append(segment) split_path_angles.append([angle]) return split_paths, split_path_angles # function to divide a line geometry def divide_line_into_straight_lines(line, angle_tolerance): """ Divides an arcpy line geometry into straight parts. line: arcpy.Polyline, the line geometry angle_tolerance: float, difference of consecutive angles (in degrees) between vertices smaller than this value are considered to be straight Returns the split lines as [arcpy.Polyline] """ split_lines = [] for part in line: split_paths, split_path_angles = divide_path_into_straight_paths(part, angle_tolerance) for path in split_paths: split_lines.append(arcpy.Polyline(arcpy.Array([path]), spatial_reference=line.spatialReference)) return split_lines, split_path_angles # function to divide all lines in a fc and write the output into a new fc def divide_lines_into_straight_lines(input_lines, output_lines, angle_tolerance): """ Divides all polylines in a featureclass or layer (honors selection) into straight parts. input_lines: str, path to the input featureclass / name of the layer output_lines: str, path of the output featureclass angle_tolerance: float, difference of consecutive angles (in degrees) between vertices smaller than this value are considered to be straight """ lines = [row for row in arcpy.da.SearchCursor(input_lines, ["OID@", "SHAPE@"])] out_path = Path(output_lines) out_fc = arcpy.management.CreateFeatureclass(str(out_path.parent), str(out_path.stem), "POLYLINE", spatial_reference=lines[0][1].spatialReference) arcpy.management.AddField(out_fc, "FID", "LONG") arcpy.management.AddField(out_fc, "LENGTH", "DOUBLE") arcpy.management.AddField(out_fc, "ANGLE_START", "DOUBLE") arcpy.management.AddField(out_fc, "ANGLE_MIN", "DOUBLE") arcpy.management.AddField(out_fc, "ANGLE_MAX", "DOUBLE") arcpy.management.AddField(out_fc, "ANGLE_RANGE", "DOUBLE") arcpy.management.AddField(out_fc, "VERTEX_COUNT", "LONG") with arcpy.da.InsertCursor(out_fc, ["FID", "SHAPE@", "LENGTH", "ANGLE_START", "ANGLE_MIN", "ANGLE_MAX", "ANGLE_RANGE", "VERTEX_COUNT"]) as cursor: for oid, shp in lines: split_shapes, split_angles = divide_line_into_straight_lines(shp, angle_tolerance) for shape, angles in zip(split_shapes, split_angles): a_start = angles[0] a_min = min(angles) a_max = max(angles) a_range = a_max - a_min if a_range > angle_tolerance: a_range = abs(a_range - 180) v_count = len(angles) + 1 cursor.insertRow([oid, shape, shape.length, a_start, a_min, a_max, a_range, v_count]) # you can use the script as tool, parameters: # Feature Layer, Required, Input, Filter for Polylines # Feature Layer, Required, Output, Filter for Polylines # Double, Required, Input if __name__ == "__main__": input_lines = arcpy.GetParameterAsText(0) output_lines = arcpy.GetParameterAsText(1) angle_tolerance = arcpy.GetParameter(2) divide_lines_into_straight_lines(input_lines, output_lines, angle_tolerance)     Points:   Points To Line:     Straight Lines:     ... View more