Latest Contributions by Bud

Another option for anyone who’s interested: Export the data to a mobile geodatabase. Create a database view using SQLite SQL to get the result that you want. SQLite is a fully functioning SQL dialect, unlike FGDB SQL. This Oracle SQL query could be adapted to SQLite SQL: --Oracle SQL select t2.a2, t1.a1, case when t1.b1 is not null then t1.b1 else 0 end as b1 from table_2 t2 left join (select a1, b1, row_number() over (partition by a1 order by b1 desc) as rn from table_1) t1 on t2.a2=t1.a1 where (t1.rn = 1 or t1.rn is null) Source:  Using a single tool: Sort within groupings, join, and fill gaps ... View more

I wonder why that's the default. It doesn't seem very useful. ... View more

1) "Are you still receiving email notifications for other content in Esri Community where you expect them?" Yes. 2) "...looks like you got multiple errors in few minutes. Were you trying to comment on something or creating new posts?" I don't recall doing anything other than reviewing my notifications. ... View more

Now I'm seeing a combined notification: But still no email about ModernElectric's reply. ... View more

Now I'm getting this classic error when I hit the bell:   ... View more

As @BlakeMorrison mentioned: For the purposes of this reply I'm using Chrome and I've cleared the cache and cookies. Unless I'm mistaken, I should be receiving a notification when a thread I'm subscribed to gets a reply. By notification, I mean the notification feed in the forum software (accessed via bell icon). I do not mean emails or any sort of proactive push notification - I am only referring to the forum software. Current forum behaviour from my point of view is that I will only be notified when I am tagged with the @ symbol. This leaves me having to manually visit threads I have participated in to check if there has been any activity.  Here is an example of that issue: @ModernElectric replied to my comment: https://community.esri.com/t5/arcgis-pro-questions/identify-feature-classes-with-64-bit-objectid/m-p/1527993/highlight/true#M87556 But I didn't get a notification in the Community website bell/notifications page: And I didn't get an email either. Windows 10; desktop PC; Chrome Version 127.0.6533.100 (Official Build) (64-bit). ... View more

Could you explain why you want to do this? Are there issues with 64-bit Object IDs we should watch out for when upgrading to the latest version of Pro, Enterprise/Portal, etc?   ... View more

I submitted a related idea: List of all columns in FGDB using SQL query ... View more

What version of Pro? What kind of geodatabase? For example, Oracle 18c 10.7.1 enterprise geodatabase. ... View more

I submitted this documentation feedback for the Spatial Join tool. When the Join Operation parameter is set to "Join one to one", yet the spatial relationship of the underlying data is one-to-many (i.e. one point intersects multiple overlapping polygons), then the tool will use the related polygon on the many side that has the lowest ObjectID. Please explain that behaviour in the docs so that other people know, and so they can use it to their advantage. https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/spatial-join.htm Related:  Consistent one-to-one/one-to-first wording in GP tools Techniques for 1:1 spatial join where underlying data is 1:M ... View more