Latest Contributions by BlakeTerhune

Is it possible to include these custom output fields in the geocode results with the "Minimal" output fields option? I can only get them to come through with "All" output fields, which is way too much. Geocode Addresses (Geocoding)—ArcGIS Pro | Documentation ... View more

@ChaseSchieffer, using the methods outlined by Richard in this blog article, you would first need to read all the related data into a dictionary. I can't figure out how you would do it with max() on the date field using a SearchCursor so you could use ArcSDESQLExecute() if your data is in an rdbms. Otherwise, you can just manipulate the data with Python in a SearchCursor. That would look something like this.   # Build dictionary with only the most recent related records. latest_related_data = {} with arcpy.da.SearchCursor(related_table, ["rel_id", "rel_date", "other_rel_field", "etc"]) as s_cursor: for rel_id, rel_date, other_rel_field, etc in s_cursor: related_record = latest_related_data.get(rel_id) # Only update the entry if it's a new id or the date is newer than what's there. if not related_record or rel_date > related_record["rel_date"]: latest_related_data[rel_id] = { "rel_date": rel_date, "other_rel_field": other_rel_field, "etc": etc } # Update the hydrant feature class with something from the latest related record. with arcpy.da.UpdateCursor(hydrant_fc, ["id", "other_field"]) as u_cursor: for id, other_field in u_cursor: # Find the related record for this hydrant id. # This will error if the hydrant id doesn't have a related record. # Maybe use dict.get() instead? latest_related_record = latest_related_data[id] # Do something with the data. # You can get data with individual field names from the related table. print(f"The latest related data for Hydrant ID {id} ({other_field})is from {latest_related_record['task_date']}") print(f"\tother_rel_field{latest_related_record['other_rel_field']}") print(f"\tetc{latest_related_record['etc']}")   ... View more

Look into querying and filtering. ... View more

Change the equality statements (==) to assignment (=) for everything that's not part of an if statement. updateFields = ["BarrierTyp", "StructureCategory", "StructureClass", "Diversion"] with arcpy.da.UpdateCursor(schemaone, updateFields) as cursor: for row in cursor: if row[0] is None: continue if row[0] == "Water Diversion": row[1] = 3 row[2] = 31 row[3] = 1 elif row[0] == "Manmade Dam": row[1] = 9 row[2] = 0 row[3] = 0 else: row[1] = 0 row[2] = 0 row[3] = 0 cursor.updateRow(row) ... View more

I've seen some of the Esri GP tools do this. When you run the tool and then copy the Python snippet, it'll put "#" for the optional parameters that were left empty. I have never done this explicitly with my Python toolboxes and I don't see a need for it. ... View more

I would say you should find a way to use a default value if OptionalParameter is not defined and write your code logic in a way that can handle any valid value (including the default). ... View more

The function parameters in the code block should not have exclamation marks, that's only for the field names in the expression. Get rid of all ! characters in the code block. ... View more

You do you, dude 😉 ... View more

No, but I have not revisited it either. Do you have any suggestions? ... View more

Wouldn't it be more efficient to use count() instead of reading all the data? select COUNT(*) from owner.table_name   ... View more

What happens if you take out the semicolon at the end of the sql? ... View more

Here's another solution to consider. s = "West Wind Ruisseau" s = s.rsplit(" ", 1) last_word = s.pop() s = " ".join([last_word] + s)   ... View more

Work with date fields—ArcGIS Online Help | Documentation All dates in ArcGIS Online are assumed to be UTC. You might need to convert the time before you upload the data. ... View more