Latest Contributions by Bud

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

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.

What is the purpose of this Community setting? What is a "board subscription"? For my board subscriptions, notify me for: Use default (only the first post in each topic) https://community.esri.com/t5/user/myprofilepage/tab/user-subscriptions:notification-settings

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

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

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).

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?

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

It would be great if we could use an SQL query, such as a database view, to get a list of all fields in all tables in a file geodatabase, including the field properties. That would help with data management requirements like Identify Feature Classes with 64-bit ObjectID. For reference, this can be done in enterprise geodatabases by querying the geodatabase system tables. Or by querying a native database table/view such as Oracle's USER_TAB_COLUMNS.

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

Esri is a multi-billion dollar company and a large Oracle customer/partner. I am wondering if Esri could use your status to ask Oracle when they plan to release Oracle Database 23c (23ai) on-prem. Oracle-base.com post on LinkedIn: “…The regular on-prem version of 23ai is still not available.” Announcing Oracle Database 23ai: General Availability [not on-prem] Of course, after 23c is released, then ArcGIS Enterprise would need to support 23c. It's hard to imagine organizations upgrading their GIS database to Oracle 19c (21c not recommended) in the year 2024/early 2025 as part of upcoming upgrade projects. Especially when 23c is available for all other platforms/environments other than on-prem. But it seems like 19c on-prem will be the only option. It would be nice to know if Oracle 23c on-prem will be delivered in 2025, 2026, or never. Is this something Esri can help with by asking Oracle for release date info? Related: What Oracle database versions are supported by ArcGIS Enterprise and ArcGIS Pro?

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

ArcGIS Pro 3.3.1 The Add Spatial Join geoprocessing tool has a read-only parameter that indicates that the Join Operation is always one-to-one. However, a related tool, Join Field, doesn't have an equivalent read-only Join Operation parameter. Yet, the tool does seem to perform a one-to-one join. Could a read-only one-to-one Join Operation parameter be added to the Join Field tool to be consistent with other join-related fields? That would make it more obvious how the tool works. Really, it should be one-to-first, not one-to-one: Consistent one-to-one/one-to-first wording in GP tools.

ArcGIS Pro 3.3.1 It's my understanding that all one-to-one joins in ArcGIS Pro are actually one-to-first joins. The first related record (the record with the lowest objectid) gets used. Could all join-related geoprocessing tool parameters be standardized so that the wording is one-to-first, not one-to-one, to make it clearer what the join does? Yes, the docs explain the join behavior in some cases. But it would be best if the join behavior were clearly communicated in the actual tools as well. For example, the current wording in these GP tool parameters is: Add Join: one-to-first Join Field: there is no Join Operation parameter (but maybe there should be a read-only parameter, similar to Add Spatial Join below) Spatial Join: one-to-one Add Spatial Join: one-to-one (read-only) Any other GP tools? Edit: Also, in the Join Operation parameter hover-over tooltip, explain that the related record with the lowest OBJECTID gets used.

@SteveLynch Yes, good point. If I understand correctly, Find Identical and Delete Identical don't let me prioritize rows using rank fields.

My Ideas

Latest Contributions by Bud

Re: What does this Community setting do? "For my board subs, notify me for: Only the first post in each topic"

Re: Getting fewer notifications than usual

What does this Community setting do? "For my board subs, notify me for: Only the first post in each topic"

Re: Getting fewer notifications than usual

Re: Getting fewer notifications than usual

Re: Getting fewer notifications than usual

Re: Identify Feature Classes with 64-bit ObjectID

Re: Identify Feature Classes with 64-bit ObjectID

List of all columns in FGDB using SQL query

Re: ArcGIS Pro 3.3.1- Exporting Join Creates NULL values in New Feature's Table

Can Esri ask Oracle for a release date of Oracle Database 23c on-prem?

Re: Spatial Join — "One-to-one (ranked by field)" join operation

Join Field — Read-only one-to-one Join Operation parameter

Consistent one-to-one/one-to-first wording in GP tool parameters

Re: GP tool to select unique rows, break ties using rank fields

Re: Scheduling Geoprocessing fails with no error m...

Re: Hi! I don't like ArcGis Pro but I have to use ...

Modify query layer data source using Python

Feature Layer Properties > Source > Data Type — Di...

Set default graphics text font size

Roads and Highways User Group (RHUG)

Mapping and Charting Enterprise Databases

GIS Jobs