Latest Contributions by Bud

ArcGIS Pro 3.1 If I understand correctly, it's not possible to edit domain values using keyboard navigation. If we navigate to a different domain cell using the keyboard, there isn't a way to get the cursor to show up and start editing the value. That makes for a frustrating domain editing experience. If I want to create or modify multiple domains, I need to use the mouse to double-click on a cell in order to edit a value. Video: I think it should be as easy as entering multiple values/rows in Excel using the keyboard. Could that behavior be changed? ... View more

What would it take to do the following in a Python script? (script to be run weekly on a server as a Windows scheduled task) For each .LYRX layer file in a network folder The layer file is based on an Oracle EGDB query layer that has a WHERE clause. If the query layer returns any rows in the attribute table Then send an email to me with the details. For example: Subject: Issues found in OutOfDateConstructionProjects.LYRX Body: Records were found in the OutOfDateConstructionProjects.LYRX query. Please investigate. The assumption being my IT department will be able to set up SMTP. ArcGIS Pro 3.1. ArcGIS Notebook Server is not an option. I’m inexperienced with Python. So any help would be appreciated. ... View more

Is CREATE EXTENSION FIRST_LAST_AGG enabled in PostgreSQL geodatabases by default? Or do DBAs need to manually enable it? GitHub: FIRST_LAST_AGG PostgreSQL extension providing first and last aggregate functions. Related: PostgreSQL equivalent to Oracle's MAX(...) KEEP (DENSE_RANK FIRST/LAST ORDER BY ...) ... View more

What's the difference between the Make Query Table vs. Make Table View GP tools? I can see that they have slightly different parameters. But generally speaking, they look like they do the same thing. Are there different use cases for those two tools? Bud_0-1678485930572.png Bud_1-1678485952089.png Thanks. ... View more

I have multiple .LYRX layer files (created from Oracle EGDB query layers) that are stored in a network folder. I want to store information in each file such as: DESCRIPTION: Check for out-of-date construction projects (STATUS=FORECAST, but DATE is in the past). MESSAGE: There are rows in the "Check for out-of-date construction projects" query. Please investigate. DISTRIBUTION_LIST: [email protected], [email protected], [email protected] EMAIL_SCHEDULE: Weekly COMMENTS: TBD Use Case: I want to build a mechanism that sends scheduled emailed notifications/reports. For example, a Python script on a server that loops through layer files in the network folder. If the layer file's definition query returns >0 rows, then email the list of recipients via SMTP, using the specified schedule. In other words, I need to store DESCRIPTION, MESSAGE, DISTRIBUTION_LIST, EMAIL_SCHEDULE , AND COMMENTS information somewhere. While I could store that information in a separate table (Excel, CSV, etc.), I'd like to have the option of storing information like that in the layer file if needed.   Currently, I don't think there's a way to store extra information in layer files. Could that functionality be added? Possibly in the General tab? Thanks. ... View more

ArcGIS Pro 3.1 I'm creating a .LYRX layer file by right-clicking the Contents layer >> Sharing >> Save as Layer File: Bud_1-1678469504586.png When using a computer with two screens, the Save Layer File dialog pops up on a different screen than ArcGIS Pro. When using big screens, I don't always notice that the window has popped up on a different screen.  Screen1: ArcGIS Pro Screen2: Save Layer File dialog Bud_0-1678469441161.png Idea: Is there anything Esri can do to make dialogs pop up in the same screen as ArcGIS Pro?  ... View more

As far as I can tell, the docs don't cover system tables when it comes to mobile geodatabases: Mobile geodatabases. Whereas other geodatabase types have detailed documentation about how to use the system tables: Geodatabase system tables in Oracle. Idea: Could a section be added to the docs that explains how geodatabase mechanisms are stored in mobile GDBs? For example, in what table are domains stored? How can we query domain values (codes and descriptions) using SQL?  I'm aware that there are GP tools, ArcPy functions, etc. that can be used to get information from GDB system tables. But that's not what I'm looking for. I want to query mobile GDB data (such as domains) using SQL so that I can include domain descriptions in SQL queries/reports, etc. Related:  Get mobile geodatabase domain values using SQL ... View more