Latest Contributions by Bud

‎07-20-2022

For what it's worth, I noticed just now that SQL Developer has a tool for entering Spatial Metadata for a given table: Bud_0-1658347008046.png Bud_1-1658347007932.png That could be useful.

‎07-20-2022

@JakeSkinner FYI - I noticed just now that SQL Developer has a tool for entering Spatial Metadata for a given table: Bud_0-1658346696161.png Bud_1-1658346710289.png That could be handy.

‎07-20-2022

When creating a database view in an Oracle EGDB using the Create Database View GP tool: I can successfully create a view if there isn't a comment at the beginning of the SQL query: select 1 as unique_id from dual --a comment But I can't create a view if there is a comment at the beginning of the SQL query, like this: --a comment select 1 as unique_id from dual When I move the cursor out of the View Definition textbox, then the SQL is automatically changed to be single-line: --a comment select 1 as unique_id from dual Which makes the SQL invalid (Oracle probably thinks the SQL is one big comment). ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. [ORA-00928: missing SELECT keyword] DBMS table not found [ORA-04043: object A_TEST_VW does not exist] [a_test_vw] Failed to execute (CreateDatabaseView). Could Pro be enhanced so that we can put SQL comments at the beginning of database views? Or put differently, could Pro be enhanced so that it doesn't automatically convert the SQL to be a single line (don't remove line breaks).

‎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: Bud_3-1675351674634.png But Catalog just hangs indefinitely when I do that. Bud_2-1675351664860.png 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 Bud_0-1658114012361.png 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. Bud_0-1658092277588.png 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: Bud_2-1658092382670.png 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): Bud_1-1658092360985.png 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: Bud_3-1658085291411.png 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. Bud_5-1658085692976.png Bud_6-1658086098018.png 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: Bud_0-1657919282372.png 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: Bud_2-1657919702892.png 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: Bud_1-1657899750008.png 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.

My Ideas

Latest Contributions by Bud

Re: GP tool for managing user_sdo_geom_metadata

Re: Convert a Oracle table to a feature class?

SQL comment at beginning of database view

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)

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

Roads and Highways User Group (RHUG)

Local Government Solutions Users

Mapping and Charting Enterprise Databases

ArcGIS Arcade