Latest Contributions by Bud

I don't have experience with publishing layers or AGOL. But with query layers and database views, 9 times out of 10, my problem is that the values in the unique ID field aren't actually unique (unbeknownst to me) or the unique ID field has nulls. ArcGIS seems to automatically exclude rows in those cases. I talked about it recently here: https://community.esri.com/t5/arcgis-pro-questions/edit-query-layer-sql-select-statement-question/m-p/1410729/highlight/true#M81931 Also, query layers seem to automatically exclude rows where the SHAPE is null or the geometry is empty: Query Layers — Include features with null shape in attribute table Maybe you could check for scenarios like those and omit problem rows from your query via SQL or editing the data. Registering a database view with the geodatabase often solves issues with record counts, selections, etc. Register a table or view with the geodatabase My environment is Oracle 18c, not SQL Server. Does SQL Server have some sort of ROWNUM column that you could use as a unique ID field? If it were Oracle, I'd do it like this, using Oracle's ROWNUM pseudocolumn functionality: SELECT     CAST(ROWNUM AS INT) AS UNIQUE_ID, ... View more

Related: Pull data from sewer line feature to manhole point feature ... View more

Related: Adding data from two different layers into another layer, stormwater pipes feature IDs ... View more

@SSWoodward Thanks for providing this info: The specific issue you've brought up was introduced in Pro 2.9.6 and 3.1 and has been addressed in the coming release of ArcGIS Pro 3.3 That certainly helps. We will try upgrading to 2.9.5 instead of 2.9.12. I like @RTPL_AU's comment: ...if you already have internal testing processes that detect regressions, these regressions should be public and part of the release notes... @SSWoodward, if I were to create a new post as described below, would you close it? Idea: Documentation — Provide GP tool execution time benchmarks, including comparison against previous Pro versions Label: Documentation & Help I'm open to input on the title/content of such an idea.   ... View more

Related: When releasing a new version of Pro, benchmark GP tool execution times against previous version ... View more

I think this would be better as an idea, not a question: https://community.esri.com/t5/arcgis-pro-ideas/idb-p/arcgis-pro-ideas You can either create a new idea. Or ask a moderator to convert this question to an idea: Bud_0-1713455881854.png Bud_1-1713455899779.png     ... View more

@SSWoodward  In a separate post, you mentioned, "The specific issue you've brought up was introduced in Pro 2.9.6 and 3.1 and has been addressed in the coming release of ArcGIS Pro 3.3". Do you happen to know what the bug number was for that issue? ... View more

Idea: Attribute Table — Show annotation SHAPE as Annotation, not Polygon ... View more

Thanks @marksm_macomb and @CharlesGrant. @dolson_farmington and @MErikReedAugusta might find this interesting. ... View more

When releasing a new version of Pro, benchmark GP tool execution times against previous version "The specific issue you've brought up was introduced in Pro 2.9.6 and 3.1 and has been addressed in the coming release of ArcGIS Pro 3.3" ... View more

@JesseWickizer  In your screenshot, if the annotation FC is feature-linked, then why is the Related feature class name field blank? Bud_0-1713372448485.png   ... View more

Thanks @JesseWickizer. I don't see the Annotation section in the Properties > Source of an annotation feature class in 2.9.12: Bud_0-1713372098761.png So maybe that's new functionality that's been added in a later version. ... View more

Another idea could be to grey-out the non-editable area (the area that's outside of the projection). ... View more