Latest Contributions by Bud

‎03-10-2023

In ArcGIS Pro 2.9, the following functionality was added: What's new in ArcGIS Pro 2.9 You can now save a stand-alone table as a layer file (*.lyrx). Idea: Could the layer file documentation be updated to reflect that change? Right now, the docs don't seem to mention that .LYRX files support standalone tables: ArcGIS Pro - Save a layer file A layer can exist outside of your map or project as a layer file (.lyrx). This allows others to access the layers you've built. You can share layers over the network or by email. That would help avoid confusion for users. Related: Idea - Layer/table definition files (readable in a text editor)

‎03-10-2023

@KoryKramer If I understand correctly, somewhere between ArcGIS Pro 2.6.8 and 3.1, functionality was added so that .LYRX files can be created for standalone tables, not just layers. If that's the case, then I think this idea can be closed. Thanks. ArcGIS Pro 2.6.8: Bud_1-1678461055944.png ArcGIS Pro 3.1: Bud_0-1678460935894.png

‎03-10-2023

@TomKirkpatrick On further investigation, it seems like .lyrx files might already do what we want. If I open a .lyrx file in a text editor, the source code is in JSON format and is human-readable. The definition query SQL expression is human-readable in the file too. An EGDB query layer can be saved as a .lyrx file. The full query (SELECT/FROM/WHERE/ETC.) is human-readable in a text editor. In Pro 3.1 (not 2.6.8), .lyrx files seem to support standalone tables too, not just layers, which is good. Bud_0-1678459987698.png Do you agree that .LYRX files do everything we need (at least in Pro 3.1)? Or is there other functionality that is needed? Are you able to batch-update .LYRX files using Python? Or does ArcPy not let you do that?

‎03-09-2023

I’m trying to extract a specific coded value domain using SQL to use the domain data in a SQL query/report. So in this case, the GP tool isn’t quite what I’m looking for. Thanks.

‎03-09-2023

In the Esri Dev Summit – Plenary session recording (time: 1:01:00), the presenter mentioned that the next version of Enterprise is planned to be released “[between] March and April” of this year. When is the next ArcGIS Enterprise version planned for release?

‎03-09-2023

Is there a way to use an SQL query to get coded value domain values from a mobile geodatabase? Thanks.

‎03-09-2023

It would be extremely helpful if there were a way to determine when a domain was last edited. For example, I need to determine what domains have been recently edited so that I can update various dependencies and integration mechanisms that are based on the domain codes/descriptions. But currently, there's no way to determine when a domain was last edited. I'm suggesting that the edit date of the entire domain be tracked, not the edit date of individual domain values. Thanks.

‎03-09-2023

SQLite @TanuHoque You'll find this SQLite answer interesting: SQLite equivalent to Oracle's MAX(...) KEEP (DENSE_RANK FIRST/LAST ORDER BY ...) See: 2.5. Bare columns in an aggregate query

‎03-09-2023

Just a heads up to Esri: I've been getting this error a LOT in the last couple of days. Whereas in previous months, I was hardly ever getting the error.

‎03-09-2023

Another possible idea: Esri staff could hold a session at the next Dev Summit or User Conference about using SQL in ArcGIS Pro.

‎03-08-2023

ArcGIS Pro 3.1 As far as I can tell, it's not possible to edit a CSV from the attribute table. Bud_0-1678379425572.png It would be helpful if CSVs were editable. I'm aware that geodatabases are Esri's preferred file format when it comes to editing. But there are other non-GDB formats like shapefiles and enterprise DBs that are editable in ArcGIS Pro. It would be nice if CSVs were editable too.

‎03-08-2023

@JMutunga Good question. I did some testing, and the issue is not reproducible when the file is a CSV. Video of the attribute table refresh button working for CSV:

‎03-08-2023

In the Esri Dev Summit – Plenary session recording (time: 1:01:00), the presenter mentioned that the next version of Enterprise is planned to be released “[between] March and April” of this year. That's in line with what you suggested.

‎03-08-2023

Here are my current thoughts: In the Esri Dev Summit – Plenary session recording (time: 1:01:00), the presenter mentioned that the next version of Enterprise is planned to be released “[between] March and April” of this year. That’s basically now, with Oracle 23c not being yet released, meaning the upcoming version of Enterprise won’t support Oracle 23c. As @MarceloMarques suggested: When I look at the “Multiple Version Table” section in Enterprise Product Life Cycle, it looks like there can be anywhere from 1-3 Enterprise releases per year. But two releases per year seems to be the most common, at least in recent years. Bud_0-1678294386690.png So I suppose it’s possible that there would be an additional Enterprise release this year. And such a version might even support Oracle 23c. However, my organization plans to upgrade our GIS "sometime this year". So I imagine the additional version of Enterprise would be released too late in the year for it to be used in our GIS Upgrade. So I’ll likely be out of luck when it comes to Oracle 23c being used in our GIS Upgrade. And will need to wait until the following GIS Upgrade, 4-5 years from now, to use Oracle 23c functionality (or whatever subsequent version of Oracle applies). Related: When is the next ArcGIS Enterprise version planned for release?

‎03-08-2023

Esri Canada Case 03282682 - When creating a new field: Single-clicking away from Field Name should change focus ENH-000156385 ArcGIS Pro 3.1 - When adding a new field, allow users to move to a different property (Alias, Data Type, etc.) by single-clicking

My Ideas

Latest Contributions by Bud

Update the docs: .LYRX layer files support standalone tables, not just layers

Re: Layer/table definition files (readable in a text editor)

Re: Layer/table definition files (readable in a text editor)

Re: Get mobile geodatabase domain values using SQL

Re: ArcGIS Enterprise 11.1 vesion

Get mobile geodatabase domain values using SQL

Domains — Property indicating domain edit date

Re: Simplify Oracle aggregation queries (using KEEP and FIRST/LAST)

Re: Error: "community.esri.com redirected you too many times. Try clearing your cookies."

Re: Training course on SQL in ArcGIS Pro

Edit CSV using attribute table

Re: Refresh Excel data using attribute table refresh button

Re: When is the next ArcGIS Enterprise version planned for release?

Re: How long does it take Esri to support a new Oracle version?

Re: When creating a new field: Single-clicking away from Field Name should change focus

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