Latest Contributions by Bud

‎07-30-2024

Is your join one-to-many? If the answer is no, are you 100% sure? I ask because one-to-many joins in ArcGIS Pro are pretty buggy. Is ArcGIS Pro the right tool for tabular/join-based geodatabase analysis? Possibly related: Export join to FGDB: Join table ID field is null Esri Case: 03616469 BUG-000146098 Join with definition query: Export has more rows than input (definition query is ignored) Esri Case: 03619440 BUG-000167563, BUG-000135505

‎07-30-2024

@CM0001 Related: Symbology class unique values list — Select a symbol/row by clicking in the blank column

‎07-30-2024

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1. EGDB; line FC In the Symbology Pane > Primary symbology > Classes tab > list of symbols/unique values: I want to click a given symbol/row and delete it using the 'Delete' keyboard key. As mentioned in Remove specific symbol class from Unique Values list, we can click in the 'Value' or 'Label' columns to select a row. However, users often try to click in the blank column on the right-hand side to select a row; clicking in that column doesn't select the row. Could the blank column be enhanced so that it's clickable/selectable as well? I think that would be more intuitive. Otherwise, users get the impression that the rows aren't selectable at all since clicking the blank column has no effect. (Maybe users avoid clicking in the 'Value' or 'Label' columns because they think clicking will automatically go into text editing mode, which isn't what they want.) Edit: I suppose this idea applies to right-clicking as well. Right-clicking in the blank column has no effect, which is unintuitive.

‎07-30-2024

Edited. Regarding this article: Why is the field set to blank instead of null and vice versa in ArcGIS Pro? A field can have a null value when the data type is set to numeric or the Allow NULL check box is enabled. It is not possible to have a blank value as an integer such as the number zero ('0') is also a value. For example, in an attribute table, when the value in the No. of Siblings field is deleted, the field is set to <Null> instead of blank, demonstrating the value does not exist. I'm finding the wording in that article to be awkward and misleading. For example, should the blue "or" actually be an "and"? I've submitted feedback via the feedback button. But I often don't hear back about feedback.

‎07-26-2024

How to Toggle Constraint and Calculation Attribute Rules on and off A somewhat related ArcGIS Online question: Is there a way to do a Bulk Attribute Update and avoid updating the LastEdited Editor Tracking Information?

‎07-25-2024

I'm getting the "You don't have any notifications" error again.

‎07-25-2024

It sounds like your data has a one-to-many relationship. Arcmap only supported one-to-one joins. But ArcGIS Pro supports one-to-many joins in some cases. In Pro, it will display duplicate rows in the attribute table for each of the workorders on the "many" side. But one-to-many joins only happen under specific circumstances. The short way of describing it is: if all your data is in the same geodatabase, then Pro will likely create a one-to-many join. But if some of your data is in Excel, then that means all of your data isn't in a single geodatabase, so the join won't be one-to-many, it will be one-to-one (one-to-first). You might find it hard to decipher the documentation when it comes to why Pro chooses to create a one-to-many vs one-to-one join: Add Join (Data Management). Hint: search that page in your browser for the word "many". This post might help make sense of why Pro made a one-to-many vs one-to-one join: Indicate what caused type of join to be used (1:1 vs 1:M) But regardless, Pro will tell you what kind of join it used in the layer properties: Just a heads up: One-to-many joins in ArcGIS Pro are quite buggy. You might find you need to export to a static copy (such as a separate feature class within the same geodatabase) in order to use the joined data in Pro. Is ArcGIS Pro the right tool for tabular/join-based geodatabase analysis? Disallow 1:M join layers as GP inputs instead of producing unexpected results

‎07-25-2024

For what it's worth, your blurb where you say "I have a gdb that includes shapefiles" doesn't really make sense. Data is either in a geodatabase, or a shapefile, but not both. A geodatabase's layers are called feature classes, not shapefiles.

‎07-25-2024

Related idea: Warning 003571 is not needed when using field calculator to set value to None

‎07-25-2024

Related: Correlate open attribute tables with open map frame in Pro

‎07-25-2024

Related idea: Switch between saved/grouped attribute table arrangements It's almost as if I want to save attribute table arrangements to a given map. But I don't think that's how map views work in Pro projects.

‎07-25-2024

Would it be worth submitting an ArcGIS Pro idea for this? At the very least, an idea would get Esri to confirm the functionality doesn't already exist in Pro.

‎07-24-2024

For what it's worth, I noticed something about the "permanent symbology and labelling" bug in older versions of Pro that confuses users: If a FC has permanent labelling stored in the EGDB, including a labelling SQL definition (such as WHERE TYPE='B'), then that SQL definition gets applied to all subsequent labelling that the user might apply to the feature layer in the map. It’s confusing when that happens – not all features get labelled and the user doesn’t know why because they’re not aware that the labelling SQL definition exists. So that might be something to keep in mind regarding this idea.

‎07-24-2024

Related: Documentation about new workspace caching functionality in Pro 3.3.0

‎07-24-2024

ODBC can also be used to connect to enterprise geodatabases in MS Access and Excel. There might be a similar driver for connecting to mobile geodatabases, too.

My Ideas

Latest Contributions by Bud

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

Re: Remove specific symbol class from Unique Values list

Symbology class unique values list — Select a symbol by clicking in blank column

Clarification about article: "Why is the field set to blank instead of null and vice versa in ArcGIS Pro?"

Re: ApplyEdits without firing immediate attribute rules and editor tracking, is it possible?

Re: Getting fewer notifications than usual

Re: Join/Relate Work Order Data to Feature layer

Re: Join/Relate Work Order Data to Feature layer

Re: Can’t calculate field to <NULL> using None

Re: Switch between saved/grouped attribute table arrangements

Re: Correlate open attribute tables with open map frame in Pro

Re: Generate geometry by expression tool similar to QGIS

Re: Store default feature class symbology in geodatabase

Re: Reload table cache in ArcGIS Pro?

Re: Ability to Connect to Geodatabase Feature Class Tables in Excel/Access

Integrate ArcGIS Data Pipelines in ArcGIS Enterpri...

Send configurable email notifications from ArcGIS ...

Re: How reliable are ArcGIS Online webhooks?

How reliable are ArcGIS Online webhooks?

Sharepoint List Connector

GIS Jobs

Experience Builder Tips and Tricks

Roads and Highways User Group (RHUG)

Local Government Solutions Users

Mapping and Charting Enterprise Databases