Latest Contributions by JohannesLindner

var id = $feature.ParcelID; var relatedtable = FeatureSetById($datastore, "1"); var filtereddata = Filter(relatedtable, "ParcelID = @id"); var permits = [] var url_pre = "https://asbuilts.ci.missoula.mt.us/scards/" var url_post = ".pdf" for (var permit in filtereddata) { permits[Count(permits)] = url_pre + permit["PermitNumber"] + url_post // in ArcGIS Pro 2.8 or later you can do // Push(permits, url_pre + permit["PermitNumber"] + url_post) } // if you show the popup's normal attribute table, one of these should work return Concatenate(permits, TextFormatting.NewLine) return Concatenate(permits, "\n") // if you show custom HTML code, this should work return Concatenate(permits, "<br/>")   Note that there is currently no easy way for the popup to actually format those urls as links. Your users will have to copy/paste them. ... View more

If the rule returns an empty string, it means it didn't find a school in teh specified search radius. If it worked before adding the filter, then the problem is probably in the filter. make sure that ELEMENTARY_SCHOOL.DISTRICT_1 and PROPERTIES.School_District are of the same data type make sure that School_District is a value that can actually be found in DISTRICT_1 include better log messages (at least temporarily) var log = "" var CURRENTSCHOOLS = FeatureSetByName($datastore, "ELEMENTARY_SCHOOL", ["School_Nam", "DISTRICT_1"]); log += Count(CURRENTSCHOOLS) + " schools loaded; " var district = $feature.School_District if(!IsEmpty(district)) { log += "filtering schools by '" + district + "'; " CURRENTSCHOOLS = Filter(CURRENTSCHOOLS, "DISTRICT_1 = @district") log += Count(CURRENTSCHOOLS) + " schools found; " } else { log += "School_District is empty; " } VAR SEARCHDISTANCE = 30; VAR SCHOOLINTERSECT = INTERSECTS(CURRENTSCHOOLS, BUFFER($FEATURE, SEARCHDISTANCE, "MILES")) log += Count(SCHOOLINTERSECT) + " schools found in the search radius; " IF(SCHOOLINTERSECT == null || COUNT(SCHOOLINTERSECT) == 0) { return log } VAR MINDISTANCE = INFINITY VAR NEARESTSCHOOL = "" FOR(VAR SCHOOL IN SCHOOLINTERSECT) { VAR DIST = DISTANCE(SCHOOL, $FEATURE) IF(DIST < MINDISTANCE) { MINDISTANCE = DIST NEARESTSCHOOL = SCHOOL.SCHOOL_NAM } } RETURN NEARESTSCHOOL   ... View more

I'm pretty late to the party, but maybe it still helps... You have to return a string. return "rgb(255, 255, 0)" return "rgba(255, 255, 0, 0.5)" return "red"   The documentation is here: https://pro.arcgis.com/de/pro-app/latest/help/mapping/layer-properties/attribute-driven-color-in-symbology.htm   ... View more

Also, I'm on 2.6.3, Enterprise GDB, so no big differences there. ... View more

Line 1: Try changing the boolean parameter (includeGeometry) to true. https://developers.arcgis.com/arcade/function-reference/data_functions/#featuresetbyname   ... View more

"in_memory" is the legacy workspace from ArcMap. ArcGIS Pro uses "memory", try using that. ... View more

Sorry if you already know this, but your post doesn't seem like it: There is a difference between a "feature class" and a "feature layer". The class ist the physical object stored in the database. The layer is (very roughly speaking) a representation of that class, which allows you to do certain things that you can't do directly with the class (e.g. selection, symbology). So when you make a feature layer of Brighton_Zoning, this is NOT a copy. If you succeed deleting a field from the layer, it will be deleted from the underlying feature class, too!   As to your problem: I find fiddling with the field mapping for the Append tool too cumbersome, so I'd do it with the Cursors: https://pro.arcgis.com/de/pro-app/latest/arcpy/get-started/data-access-using-cursors.htm   # create the output feature class # creating it in memory makes everthing faster, you just have to copy it to a gdb afterwards out_fc = arcpy.management.CreateFeatureclass("memory", "out_fc", "POLYGON") # add the output fields arcpy.management.AddField(out_fc, "TextField", "TEXT") arcpy.management.AddField(out_fc, "IntegerField", "LONG") # create a list of feature classes to append, their fields, and sql queries determining the entries that are to be copied # fields have to be in the same order for each fc # geometry type has to be the same for each fc append_fcs = [ {"path": "path/of/fc1", "fields": ["SHAPE@", "TEXT", "INTEGER"], "sql": None}, {"path": "path/of/fc2", "fields": ["SHAPE@", "Text_Field", "Integer_Field"], "sql": "Text_Field LIKE '%abc%'"}, ] # start the insert cursor with arcpy.da.InsertCursor(out_fc, ["SHAPE@", "TextField", "IntegerField"]) as i_cursor: # loop though append_fcs and copy each row to out_fc for fc in append_fcs: with arcpy.da.SearchCursor(fc["path"], fc["fields"], fc["sql"]) as s_cursor: for row in s_cursor: i_cursor.insertRow(row) ... View more

When you say "clip", do you mean "copy"? If so, the relationship classes and related tables /feature classes should get copied automatically. ... View more

import arcpy table = "DBF_ExRainfall" date_field = "Dates" # extract the dates from the table and format them: # list of datetime.datetime objects # [datetime.datetime(2018, 9, 25, 8, 36, 54), datetime.datetime(2018, 9, 25, 8, 58, 24)] dates = [row[0] for row in arcpy.da.SearchCursor(table, [date_field], "{} IS NOT NULL".format(date_field))] # convert to str # ['2018-09-25', '2018-09-25'] date_strings = [d.strftime("%Y-%m-%d") for d in dates] # make it distinct # ['2018-09-25'] distinct_date_strings = list(set(date_strings )) # create feature layers for each date for d in distinct_date_strings: where_clause = "DATEDIFF(DAY, {}, '{}') = 0".format(date_field, d) lyr = arcpy.management.MakeFeatureLayer(table, d, where_clause) # if you want it as feature class (saved in database): #out_fc = os.path.join(gdb_path, d) #arcpy.management.CopyFeatures(lyr, out_fc) ... View more

Building on what David suggested:   IIf(Replace($feature.FaxPhone, ' ', '') == '()-', '', $feature.FaxPhone)   Also, make sure you're actually showing the expression in the popup, not the field. ... View more