Latest Contributions by Bud

‎07-20-2022

In Catalog, in a EGDB connection, it would be helpful if there were a way to filter the object list by object type. For example, filter to only show one of the following: Database views Relationship classes Standalone tables Feature Classes Etc. Could that functionality be added to Catalog?

‎07-20-2022

In Catalog in Pro 2.6.8, I want to search an Oracle EGDB for objects with the word "sewer" in them: But Catalog just hangs indefinitely when I do that. Indexing is in progress. Please wait or search again later. Has anyone else noticed that issue? Thanks.

Re: Search bar obscures profile picklist · ‎07-20-2022

Yes, looks good to me too. Thanks.

‎07-20-2022

It would be helpful if we could kudo comments in ideas. For example, I want to acknowledge a helpful comment in this idea: https://community.esri.com/t5/arcgis-pro-ideas/improve-error-messaging-when-moving-fc-to-fd-fails/idc-p/1193724 The only way to do that is to add a new comment (with a tag). To me, commenting seems unnecessary; I don't need to spam everyone who subscribed to that idea with a new comment that says "@xyz Thanks!". Could ideas be enhanced so that we can kudo comments in ideas?

‎07-17-2022

Here's what I came up with: --create or replace view qc_lc_events_fields_vs_domains_vw as select objectid, event_id, field_domain_mismatch --Only displays the first problem field that's found for each row. Once the first problem is fixed, the next problem will be displayed. from ( select a.objectid, a.event_id, --Info about DECODE and nulls: https://blog.tuningsql.com/oracle-coding-around-null-values/#:~:text=NULL%20values%20to%20be%20equivalent case when decode(a.event_status, b.code, 'SAME', 'DIFF') = 'DIFF' then 'EVENT_STATUS' when decode(a.asset_class, c.code, 'SAME', 'DIFF') = 'DIFF' then 'ASSET_CLASS' when decode(a.strategy, d.code, 'SAME', 'DIFF') = 'DIFF' then 'STRATEGY' when decode(a.activity, e.domain_code, 'SAME', 'DIFF') = 'DIFF' then 'ACTIVITY' when decode(a.project_lead, f.code, 'SAME', 'DIFF') = 'DIFF' then 'PROJECT_LEAD' when decode(a.side, g.code, 'SAME', 'DIFF') = 'DIFF' then 'SIDE' end as field_domain_mismatch from infrastr.lc_events a left join infrastr.d_event_status_vw b on a.event_status = b.code left join infrastr.sub_lc_events_asset_class_vw c on a.asset_class = c.code left join infrastr.d_strategy_vw d on a.strategy = d.code left join infrastr.d_activity_lc_events_asset_class_subtype_vw e on a.asset_class = e.subtype_code and a.activity = e.domain_code left join infrastr.d_municipality_vw f on a.project_lead = f.code left join infrastr.d_direction_vw g on a.side = g.code ) where field_domain_mismatch is not null Source for the domain views (the views that start with "d_" such as d_event_status_vw): Select domain codes/descriptions using XMLTABLE instead of EXTRACTVALUE The query in that link selects all domains. Whereas, for my "d_" views, I have a WHERE clause that only selects the domain data (codes & descriptions) for a specific domain. Source for the domain view d_activity_lc_events_asset_class_subtype_vw (also has subtype columns): For each domain of a subtype field, select the domain data and subtype data (using SQL) Source for the subtype view sub_lc_events_asset_class_vw: Select subtype and a subtype field's domain names using SQL Related: Find problem rows in GDB_ITEMS_VW Join to XML query is only performant with redundant hardcoded WHERE clause Extract specific value from XML array (where FieldName = x) Update Oracle GDB docs: EXTRACTVALUE is deprecated, use XMLTABLE instead (faster)

‎07-17-2022

Scenario: I have a subtype on the ASSET_CLASS field in a table. When ASSET_CLASS = 3, then the ACTIVITY field uses an ACTIVITY_ROAD domain. If I were to change the ASSET_CLASS value from ROADS to WATERCOURSE: Then the ACTIVITY's value would stay the same (although it now shows the domain's code (RWID) instead of the domain description (ROAD WIDENING)...but I suppose that's to be expected). It seems like ArcGIS should do something to account for the fact that the ACTIVITY is no longer valid for the ASSET_CLASS subtype. In other words, RWID (ROAD WIDENING) isn't a valid ACTIVITY for WATERCOURSE. WATERCOURSE has it's own domain: ACTIVITY_WATERCOURSE. Note: I did get the message/option below. But choosing "Yes" had no effect on the ACTIVITY field, since the ACTIVITY field doesn't have a default value (and we don't want it to have a default value): Could Pro be enhanced to account for the invalid domain value in that scenario? To be honest, I'm not sure what the mechanism should be/how it should be handled. Maybe the ACTIVITY field should get automatically nulled-out? Or a warning message? Thoughts anyone?

‎07-17-2022

For a table that has a subtype: The subtype fields have domains. For example, when the ASSET_CLASS subtype value = 0 (ACTIVE_TRANSPORTATION), the ACTIVITY field uses the ACTIVITY_ATN domain. Problem: Just like with regular domains, subtype domains can be easily overridden via the Field Calculator and other mechanisms. For example, 'asdf' is not a valid ACTIVITY_ATN domain code, but I can still enter that value via the Field Calculator. Idea: In ArcGIS, hard-enforcing subtypes and domains isn't supported, and likely won't be supported any time soon. As a workaround, could Esri provide a sample attribute rule for enforcing subtype domains? (in the Esri Arcade GitHub) Thanks.

‎07-15-2022

I'm having a problem where an Oracle view is fast in SQL Developer, but the same view is 100x slower in ArcGIS Pro 2.6.8. https://gis.stackexchange.com/questions/436108/for-each-domain-of-a-subtype-field-select-the-domain-data-and-subtype-data-usi/436109#436109:~:text=view%20is%20slow%20in%20ArcGIS%20Pro I want to look at the SQL query that Pro is sending to the database, to see if Pro is doing something weird in its query. When I open ArcMon in Pro 2.6.8, this is what I see: I can't figure out where the SQL query might be. I can't seem to open any of those entries to get details. Whereas in Pro 2.9.2 (on a different computer using a fake FGDB), the UI is different, and I can easily get the SQL query in the Log tab: Does the equivalent functionality exist in ArcMon in Pro 2.6.8?

‎07-15-2022

(merged from a duplicate idea) In SQL clients like SQL Developer and Toad, we can filter on a column like this: It would be handy if we could do something similar in the Attribute Table in Pro. It wouldn't need to be a new/separate filtering mechanism. It could simply be a way of generating the Select by Attributes expression.

‎07-14-2022

Regarding the new Add Spatial Join geoprocessing tool in ArcGIS Pro 3.0: Joins attributes from one feature to another based on the spatial relationship. The target features and the joined attributes from the join features will be joined. The join is temporary. Out of curiosity, how is the temporary join data stored? Is it stored in RAM, the project file, or a temporary table in the db? If we wanted to refresh the spatial join, how would we do it?

‎07-13-2022

There are some good comments in this sister post: Oracle Groundbreakers Community - Tips about nulls in SQL

‎07-13-2022

When deleting objects from Catalog (tables, FC, and especially views) in an enterprise GDB, we never really know if deleting the object worked or not. We delete the object, and it certainly looks like it was deleted, but then when we refresh the connection, the object reappears (it wasn't actually deleted). Could deleting objects in Catalog be improved? I.e., could Catalog do a better job of deleting an object. And if it wasn't successfully deleted (either the underlying db object or the records in the system tables), make it clearer that the operation failed — so that we know that we need to go back and refresh the connection and troubleshoot the issue.

‎07-12-2022

Oracle 18c SDE.ST_GEOMETRY EGDB: Has anyone ever tried adding additional "attributes" to an ST_GEOMETRY object column? Such as adding an SDO_GEOMETRY attribute to the object column: ENTITY NUMBER(38) NUMPTS NUMBER(38) MINX FLOAT(64) MINY FLOAT(64) MAXX FLOAT(64) MAXY FLOAT(64) MINZ FLOAT(64) MAXZ FLOAT(64) MINM FLOAT(64) MAXM FLOAT(64) AREA FLOAT(64) LEN FLOAT(64) SRID NUMBER(38) POINTS BLOB SDO_GEOM SDO_GEOMETRY Source: ST_Geometry in Oracle Or, alternatively, add an additional "subtype" to the object supertype. Sure, it wouldn't be supported. But that's not what I'm asking about. I'm asking if anyone has tried it. Reason: I want to use Oracle Spatial linear referencing functionality, but can't switch my FCs from ST_GEOMETRY over to SDO_GOMETRY. We can't add additional geometry columns to a FC (causes errors). And I want to avoid creating dozens of helper SDO_GEOMETRY FCs if I can help it. Thanks.

‎07-12-2022

If I make a change to a feature class's properties in Catalog, such as renaming it or registering it as versioned, then Catalog refreshes the list of FCs in the connection, and navigates away from the FC (to the top of the list). That's fairly aggravating. We have to scroll through the list of hundreds of objects in the EGDB to find the FC to resume what we were doing. If the operation takes a couple of minutes, we might even forget what we were doing by the time it refreshes. Or when we go to navigate back to the object, we might accidently go to the wrong object. Little things like that could be avoided if Catalog didn't navigate away from the object in the first place. I understand why it would need to refresh after a change. But it would be better if Catalog could scroll back to the FC and re-select it. Or just refresh the affected object(s), instead of the entire list, avoiding the need to navigate away from the object. Could Catalog be enhanced so that it doesn't navigate away from an object after a change is made?

‎07-12-2022

Is there a way to set a default projection when creating new feature classes? (enterprise GDB) 100.0% of our feature classes are NAD83 UTM 17N. I never need to create a FC with a different projection. So it would be nice if I could set a default. I create projects/maps from scratch, without any default layers, so I don't think Pro could grab the projection from any existing info in the project/map.

My Ideas

Latest Contributions by Bud

Filter Catalog by object type

Searching for an object in Catalog hangs

Re: Search bar obscures profile picklist

Kudo comments in ideas

Re: Select rows that have invalid subtype/domain values using SQL

When editing subtype field, account for the fact that the field domain value is now invalid

Sample attribute rule to enforce subtype domains

View SQL log in ArcMon (Pro 2.6.8)

Select by Attributes by clicking/filtering a column right in the attribute table

The new Add Spatial Join GP tool: How is the temporary join data stored?

Re: Tips about nulls in SQL

More robust object deletions in Catalog (EGDB)

Add additional "attributes" to ST_GEOMETRY object column

Don't navigate away from FC after making a change in Catalog

Set default projection when creating feature classes

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

Local Government Solutions Users

Roads and Highways User Group (RHUG)

Mapping and Charting Enterprise Databases

ArcGIS Arcade