Latest Contributions by DavidPike

What type of AGOL account do you have?  All the right privileges/user types and role?  credit usage, Data Editor, Creator etc.? ... View more

Because the output feature classes from the split by attributes tool come from an iterator you can't just connect them to the merge tool (which I think you understand from your previous reply). I think the recommended way is described here https://community.esri.com/t5/arcgis-pro-questions/merge-outputs-of-an-iterator-modelbuilder/td-p/1180000 by using the Collect Values tool https://pro.arcgis.com/en/pro-app/latest/tool-reference/modelbuilder-toolbox/collect-values.htm to collect the paths of the output feature classes.  You would then use the collected values as input to the merge.  Obviously before you do the merge you'd want to Select By Attributes on the MAX(Date) as Richard demonstrated. ... View more

You say 'Fields differing from the new domains' - do you instead mean the values in the field? If so I'd just use Field Calculator https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/calculate-field.htm def replace_value(field): if field == 'apple': return 'fruit' elif field == 'potato': return 'vegetable' # Call the function to update the field values replace_value(!YourFieldName!)   ... View more

Is there a reason not to use the coordinate conversion tool in python?  You could probably do it using a dictionary to get the cartesian coords (for that UTM zone) of the GZD and 100km grid square in the MGRS string, then add on the X and Y.  If that dictionary doesn't exist somewhere on the internet, then seems like a fair amount of effort for no reason I can understand. ... View more

It's nothing anyone can or is going to describe in a reply.  You're also going to struggle if you only have ArcGIS Online.  https://www.esri.com/training/new-and-retired-training/  ... View more

Ah I tried a FGDB view and couldn't subqueries with GROUP BY working.  I'd really recommend what @RichardHowe suggested as the most practical way. ... View more

I won't pretend to know what the script is doing but instead of iterating over your list of numbers, can you just run the select by attributes based on the list?  Also are you sure the selection is being honoured as you just seem to reference the same table in the cursor rather than: selected_features = arcpy.SelectlayerByAttribute(pt_tbl, ...) with arcpy.da.UpdateCursor(selected_features, fields) as cursor: As an aside I'd recommend some code comments and more understandable variable names if someone ever has to read or edit your code in the future. arcpy.management.SelectLayerByAttribute(pt_tbl, "NEW_SELECTION", "NUM_SEC IN '%s'" %(traillistsortpt))   ... View more

Possibly not saved your edits.  Though could really be anything unless you have a screenshot or more details.   ... View more

Ah yes ignore me if this is VRP routes, barriers wouldn't make sense.  I thought that you may have been referring to a road/highway as a 'route'. ... View more

What type of analysis is it?  Can you just add point/polygon barriers? ... View more

Your math seems fine.  Might be a good initial check if you sum the Area values in the table that should give the count of all Zone pixels in your extent. that sum value * 25 should give the total extent area (in Hectares) If you don't have any NoData etc.  How far off are your calculations?  Also easy to confuse the value raster with the zone raster. Would you be able to share any screenshots etc. ? ... View more

Probably the best model builder way as I think subqueries (in ArcGIS select by tool) are limited to scalar. ... View more

I think the database view is a good idea, would be some subquery with a GROUP BY species and MAX (date) as @RichardHowe suggests ... View more