Latest Contributions by JohannesLindner

OK, so you want an Attribute Rule. These can only be written in Arcade, that's why you can't choose Python. Your formula would be z_start = geodetic_height_start - invert_elevation_start You have the invert_elevation from your feature and I assume you have the geodetic height as a DEM raster. Sadly, Arcade doesn't work with rasters (yet?), so you can't do this as an Attribute Rule. You can do it with a Python script / tool, but you would have to run that manually. ... View more

@JoeBorgione& @DanPatterson : They are using the normal ArcGIS Pro Python window, just opening it in a slightly more cumbersome way. @zhongying_gan: You are using a custom Python environment (see where it says "arcgispro-py3-clone" in your error message) and the numpy package in this environment  seems to be broken. Because arcpy needs numpy, it isn't imported on startup (so that you don't explicitly need to import it), that's why you get the "name not defined" error. Ways to fix this: reinstall the numpy package in your cloned environment (talk to your admin) go back to the default environment (see this link) as a last resort, reinstall ArcGIS Pro ... View more

Code Block:   def get_projected_extent(shape, wkid): in_sr = shape.spatialReference out_sr = arcpy.SpatialReference(wkid) # get the extent e = shape.extent # convert the extent into a geometry # either as polygon of all 4 points or as a diagonal polyline e_points = [ arcpy.Point(e.XMin, e.YMin), arcpy.Point(e.XMax, e.YMax), ] e_geometry = arcpy.Polyline(arcpy.Array(e_points), in_sr) # project the geometry and get the projected extent e_proj = e_geometry.projectAs(out_sr).extent return e_proj   Field =   get_projected_extent(!SHAPE!, 4326).XMax   ... View more

# your input table and fields in_fc = "..." in_fields = ["OBJECTID", "RELID", "DATE", "AUTHORS"] # your output table and fields # this can be in_fc and in_fields, but for testing I suggest you create a new table... # if you really need to copy ObjectID, you have to create a new field, FID in my example out_fc = "..." out_fields = ["FID", "RELID", "DATE", "AUTHORS"] # index of the field that has to be split # !python uses zero-based indexing! split_field_index = 3 split_pattern = ", " # read data data = [list(row) for row in arcpy.da.SearchCursor(in_fc, in_fields)] # optional: delete all rows from out_fc # !!! if out_fc is the origin table of a relationship class, the foreign key in the related table will be set to Null !!! arcpy.management.TruncateTable(out_fc) with arcpy.da.InsertCursor(out_fc, out_fields) as cursor: # loop through original data for row in data: split_field = row[split_field_index] # split_field is empty? just copy the row if split_field is None: cursor.insertRow(row) continue # split split_field split_values = split_field.split(split_pattern) # loop through split_values and insert rows for value in split_values: row[split_field_index] = value cursor.insertRow(row) ... View more

Probably you missed the curly brackets when copying the code, but still: if ($feature.street_status==1 && $feature.street_id==null) { return true; } return false; The problem with this code is the following: If you are inserting a street with street_status 2, it will return false, because you only check for street_status 1 and return false otherwise. This should work in those cases: if ($feature.street_status==1 && $feature.street_id!=null) { return false; } return true; This defaults to returning true and only blocks the insert/edit on the combination you don't want.   Other things to check: As Chris said: Is street_status numeric? Instead of the null check, you could try IsEmpty($feature.street_id) ... View more

OK, so instead of filtering all documents at once, you need to cycle through the parcels and filter all documents for each parcel. I can't test this code, but it should be close:   // load the tables var table_a = FeatureSetByName($datastore, "Document_List") var table_b = FeatureSetByName($datastore, "Relationship_table") var table_c = FeatureSetByName($datastore, "Parcels_full_list") // create output array var output_lines = [] // filter parcels var plot_id = $feature.ObjectID var filtered_c =Filter(table_c, "Shape_ID_No = @plot_id") // loop through parcels for(var c in filtered_c) { parcel_id = c.Parcel_ID_No parcel_name = c.Parcel_Name // get document ids for this parcel var filtered_b = Filter(table_b, "Parcel_ID_No = @parcel_id") if(filtered_b == null || Count(filtered_b) == 0) { Push(output_lines, parcel_name + ": No documents") continue } var doc_ids = [] for(var b in filtered_b) { Push(doc_ids, b.BOOK_ID_No) } // get the document paths var filtered_a = Filter(table_a, "OBJECTID IN @parcel_ids") if(filtered_a == null || Count(filtered_a) == 0) { Push(output_lines, parcel_name + ": No documents") continue } var docs = [] for(var a in filtered_a) { Push(docs, a.Hyperlink) } // format the output line for this parcel Push(output_lines, parcel_name + ": " + Concatenate(docs, " | ") } // concatenate output_lines return Concatenate(output_lines, TextFormatting.NewLine)       As a side note: In my experience, it's very bad to rely on ObjectID as primary key. If for any reason you need to copy a feature or the whole feature class, the new ObjectIDs will be different, destroying your relationships. I've had this happen to me, recreating the relations was painful. I recommend: add manual primary key fields to your tables create database sequences for each primary key (Create Database Sequence) add this calculation rule to the primary key field of each of your tables:   // field empty: return next sequence value // else: return field value return IIF(IsEmpty($feature["KeyField"]), NextSequenceValue("KeySequence"), $feature["KeyField"])​   ... View more