Latest Contributions by JohannesLindner

Does this do what you want? #specify fields from target dataset to be updated oldFields = ("WAM_ID","LastServiceDate") #specify fields from source dataset newFields = ("wam_id","date") #use search cursor to collect values from source dataset newValues = arcpy.da.SearchCursor(gateInspections,newFields,"wam_id is not Null") inspections = [row for row in newValues] unique_wam_ids = set([i[0] for i in inspections]) valDict = {uid: [i[1] for i in inspections if i[0] == uid] for uid in unique_wam_ids} # valDict contains a list of datetime.datetime objects for each wam_id # valDict = {"wam_id_1": [datetime(), datetime(), datetime()], # "wam_id_2": [datetime(), datetime()], # "wam_id_5": [] # } fcRows = arcpy.da.UpdateCursor(inFC,oldFields, "WAM_ID is not Null") try: for row in fcRows: wam_id = row[0] try: # find the inspection dates for the given wam_id and sort them inspection_dates = sorted(valDict[wam_id]) except KeyError: # no inspection found -> skip rest of the for block logFile.write('No inspection for valve {0}.\n'.format(wam_id)) continue # somehow, there isn't a valid date -> skip the rest of the for block if len(inspection_dates) == 0 or inspection_dates[-1] is None: continue # write the most current inspection last_inspection = inspection_dates[-1] # we sorted above, [-1] is the most current date fcRows.updateRow([wam_id, last_inspection]) except: # your outer try-except block pass ... View more

If you only want to delete the attachments, but keep the features they are attached to: attach_table = 'CustodianInspection__ATTACH' ##Step 1 -Search the atttachment table and export as jpegs with REL_GUID in filename ## Use UpdateCursor instead of SearchCursor with da.UpdateCursor(attach_table, ['DATA', 'ATT_NAME', 'REL_GLOBALID']) as cursor: for item in cursor: attachment = item[0] file_GUID = "GUID_" + str(item[2]) filename = file_GUID + str(item[1]) open(temp_dir + os.sep + filename, 'wb').write(attachment.tobytes()) cursor.deleteRow() # Delete this attachment del item del attachment   If you don't need the features whose attachments you have exported, you can just delete the features and the attachments are deleted automatically. ... View more

Create another expression: // expression/display_reservation_link // returns 'none' if the feature is not reservable, else returns 'block' var reservable = $feature.Reservable // or however you determine if the feature is reservable return IIF(reservable, 'block', 'none')   Go into your popup, switch to HTML source. Find your link and put it into a div: <div style="display:{expression/display_reservation_link};"> <a href="{expression/reservation_link}">Click here to Learn How to Reserve!</a> </div> ... View more

Something like this? return closest_address.street_name + " " + closest_address.house_number + ", " + closest_address.zip_code + " " + closest_address.town_name   Or for better readability: var street = closest_address.street_name var house = closest_address.house_number var zip = closest_address.zip_code var town = closest_address.town_name return street + " " + house + ", " + zip + " " + town   I haven't figured out calling feature attributes by variables, yet: // These work: return $feature.Attribute return $feature["Attribute"] // This doesn't (in my experience): var att = "Attribute" return $feature[att] // When working with features that aren't $feature (e.g. your closest_address), only this seems to work: var f = First(Intersect(FeatureSetByName(...), $feature)) return f.Attribute ... View more

I could reproduce the different object types when manually running the commands in the python window (<Polygon object at ...>) vs running the function (<geoprocessing describe geometry object at ...>). I could not reproduce your problem (empty output). You also said one value in the output was an error, but that should be the expected outcome when merging all found features, right? I edited your code, as I couldn't use yours with my data structure and multiple features. Maybe it works better for you. # fcs_list: list of paths to the feature classes # where_clauses: list of where clauses used to select only certain entries from a feature class ("SELECT * FROM feature_class WHERE ...") # fname: path to the output feature class def extract_cursor(fcs_list, where_clauses, fname): # ensure correct input ## if len(fcs_list) != len(where_clauses): ## raise ValueError("fcs_list and where_clauses have to be the same length!") ## desc_list = [arcpy.da.Describe(fc) for fc in fcs_list] ## if not all([desc["dataType"] == "FeatureClass" for desc in desc_list]): ## raise ValueError("All elements of fcs_list have to be feature classes!") ## if len(set([desc["shapeType"] for desc in desc_list])) > 1: ## raise ValueError("All elements of fcs_list have to be of the same geometry type!") # extract all applicable shapes from all feature classes shapes = [] for fc, where in zip(fcs_list, where_clauses): shapes += [row[0] for row in arcpy.da.SearchCursor(fc, ["SHAPE@"], where)] # merge the shapes merged_shape = shapes[0] for s in shapes: ## print(s) # <-- this prints <geoprocessing describe geometry object at ...> merged_shape = merged_shape.union(s) # save the merged shape arcpy.management.CopyFeatures(merged_shape, fname)   You can call it like this: import sys sys.path.append('path/to/zachs_arc_scripts') from zachs_geo_script import extract_cursor fcs_in ['kentucky','missouri','kansas'] where_clauses = ["rivers = 'rural'", "streams = 'rural'", "rivers = 'seasonal'"] # you can also write more complex queries: # "rivers IN ('rural', 'seasonal')" # "TextField = 'text' OR IntField = 5" # "rivers = 'rural' AND river_length > 9000" fname = 'merged_rivers_ky_mo_ks' extract_cursor(fcs_in, where_clauses, fname)   ... View more

Ah, I think I misunderstood your original question... Does this do what you want? // Get all features of the LandUse layer that are intersected by the selected feature. // You apply a negative buffer here, so you don't get land use features that only intersect with the outer edges, is that correct? var intersect_layer = Intersects(FeatureSetByName($map, "LandUse - h Provision Overlay"), Buffer($feature, -10, 'feet')) // No intersecting features found -> "n/a" if(Count(intersect_layer) == 0) { return "n/a" } // Define and initialize the variable that stores your text var intersected_land_uses = "" // Loop through the intersecting land use features for (var f in intersect_layer ) { var land_use = IIF(IsEmpty(f.NAME), "n/a", f.NAME) if (intersected_land_uses == "") { // there is nothing in here yet intersected_land_uses = land_use } else { // there is something in here already, append with " And " intersected_land_uses += " And " + land_use } } return intersected_land_uses   ... View more