Latest Contributions by JohannesLindner

Multipart To Singlepart (Data Management)—ArcGIS Pro | Documentation ... View more

Something like this could do what you want: create a point feature class, add GlobalID create a field in that fc that will work as a foreign key to the table you wish to edit edit and add this attribute rule // Calculation Attribute Rule on your point FC // Field: empty // Triggers: Insert // Exclude from application evaluation // get the rows that will be updated var key = $feature.KeyField var table = FeatureSetByName($datastore, "Database.Dataowner.TableYouWantToEdit", ["GlobalID", "KeyField"], false) var rows = Filter(table, "KeyField = @key") // create and fill the update array var lat_long_attributes = {"LAT": Geometry($feature).y, "LONG": Geometry($feature).x} var updates = [] for(var row in rows) { Push(updates, {"globalID": row.GlobalID, "attributes": lat_long_attributes} } // tell ArcGIS to edit the table return { "edit" [{ "className": "Database.Dataowner.TableYouWantToEdit", "updates": updates }] }   The workflow for this would be copy the key of the feature you want to edit create point feature --> paste key into the feature template, create the point in the correct location the attribute rule will trigger and write the coordinates of the  new point into the lat/long fields of the row(s) you specified with the key ... View more

I am not sure why I am unable to see such granularity in terms of properties under Legend Hmm, no idea, but you can also do it with Python (see line 22).   I would also like to know how I can specify which layers I would like to export, instead of all the layers on the map. listLayers() has an optional string argument which lets you search for layer name patterns. You could mabe rig something up with listLayers("*Stats"), but the far easier and more expandable way is to add a second step that only keeps the layers with the names you specify. See lines 32 and 39.   from pathlib import Path def export_layout_for_each_layer(layer_list, layout, save_folder): save_folder = Path(save_folder) # turn all layers off for layer in layer_list: layer.visible = False # while there are still layers in the list while layer_list: # remove the first layer from the list and make it visible layer = layer_list.pop(0) layer.visible = True # special treatment for group layers if layer.isGroupLayer: # recursively call this function on its sub layers (this exports all the sub layers on their own export_layout_for_each_layer(layer.listLayers(), layout, save_folder) # make the sub layers visible (so we can export the group layer) and remove the sub layers from the master layer list (because we already exported them) for sub_layer in layer.listLayers(): layer_list.remove(sub_layer) sub_layer.visible = True # make sure the legend only shows active layers layout.listElements("LEGEND_ELEMENT")[0].syncLayerVisibility = True # set title and export, then make layer invisible print(f"Exporting layout for {layer.name}") layout.listElements("TEXT_ELEMENT")[0].text = layer.name layout.exportToPDF(save_folder/f"{layer.name}.pdf") layer.visible = False # define your save location and export layerrs save_folder = Path(arcpy.env.workspace).parent export_layer_names = ["Money Stats" , "House Stats", "Car Stats", "Travel Stats"] # get the elements you need aprx = arcpy.mp.ArcGISProject("current") layout = aprx.listLayouts("Layout")[0] map_frame = layout.listElements('MAPFRAME_ELEMENT')[0] all_layers = map_frame.map.listLayers() export_layers = [layer for layer in all_layers if layer.name in export_layer_names] # run it export_layout_for_each_layer(export_layers, layout, save_folder)   ... View more

According to your working query, 2022 should be provided as string, but it's an integer. Try these approaches: // convert this_year to string var CB_gid = $feature.GlobalID; var this_year= Text(Year(Now())); var filter_statement = 'guid = @CB_gid AND last_cleaned IS NOT Null AND YEAR(last_cleaned) = @this_year)' // take care of the types yourself var filter_statement = `guid = '${$feature.GlobalID}' AND last_cleaned IS NOT Null AND YEAR(last_cleaned) = '${Year(Now())}')`   ... View more