Latest Contributions by Bud

@DanLee Yes, that worked. "Identify and store polygon neighboring information" seems pretty cryptic. Could the name of that parameter be changed, such as a picklist with "one-to-one" and "one to many" options? Or something better? ... View more

I do the same. In Excel, in a worksheet, I use an ODBC connection to bring in data from a table/FC in the Oracle enterprise geodatabase, using Microsoft Query or Excel Power Query. I hit the refresh button in Excel to refresh the data or set up the connection so that the data refreshes when I open the Excel workbook.   ... View more

@CordulaGöke Feel free to upvote. Related: idea status concerning gpkg was to changed "needs clarification" in June 2024   ... View more

Related: ArcGIS Enterprise Capacity ... View more

Related: Capacity Planning - System Architecture for ArcGIS Enterprise 11.5 https://community.esri.com/t5/arcgis-enterprise-questions/capacity-planning-system-architecture-for/m-p/1564421/highlight/true#M41123 ... View more

You could consider asking similar SQL questions on the Data Management esri community. Regarding enterprise geodatabases and mobile geodatabases (not file geodatabases):  Many years ago, I remember @VinceAngelo saying something to the effect of, "If you're going to write SQL queries for ArcGIS, then you absolutely need a SQL client like Toad, SQL Developer (Oracle), or something similar. Not having SQL client software would be a severe limitation." Like Vince, I think it's important you get yourself a SQL Client. If your I.T. department won't let you, consider downloading a portable version of a SQL client. I think Beekeeper Studio has a portable version. Maybe DBeaver does too. Portable software doesn't require Windows admin rights, so it's a way for you to install software without involving your I.T. department. I'll say it one more time for emphasis - we definitely need a SQL Client when writing SQL queries for ArcGIS Pro, such as writing full-blown queries in query layers or database views. I have carved a SQL-centric GIS data anlysis career out of being the only person in the office who understands how tricky SQL can be. "SQL (and Python) are easy to pick up, but difficult to master" (source: SQL for Data Analysis by Cathy Tanimura). Nulls are an example of something that's surprisingly tricky/difficult to master. Tips about nulls in Oracle SQL I imagine the same applies to Python - get yourself a Python editor like PyScripter or similar? ... View more

Related:  File Geodatabase — Calculate field using SQL Mobile Geodatabase — Calculate field using SQL ... View more

Related:  Use SQL for field calculations on versioned data (option to move edits to base) File Geodatabase — Calculate field using SQL ... View more

Related: Use SQL for field calculations on versioned data (option to move edits to base) ... View more

Regarding SQL, what kind of geodatabase are you using? Oracle? SQL Server? File geodatabase? SQL by Ben Forta (generic SQL; 5th edition) Oracle PL/SQL by Ben Forta (1st edition) Microsoft SQL Server T-SQL (2nd edition) ArcGIS Enterprise Questions - SQL Data Analysis - Books & Resources @JoshuaBixby might find this interesting. ... View more

What version of Pro? ... View more

To clarify, this seems to only apply to the Scales tab, not the Symbology tab. The Symbology tab does show the domain descriptions in the Label column. ArcGIS Pro 2.9.5:     ... View more

Unable to Adjust Layer Order in ArcGIS Pro 3.4.2 ... View more

@RTPL_AU I forgot to reply to your comment. It cracked me up! 😂 ... View more

I imagine this question will be moved by a mod to the ArcGIS Pro Questions community. You could also consider creating an ArcGIS Pro Idea. Do you want to choose the layers by selecting them in the Contents pane? Or do you want a geoprocessing tool with a list of layers as checkboxes? If you want a geoprocessing tool, you might be able to set up a batch operation. I don't have any experience with using GP tools in batch mode, but someone else might be able to weigh in or you could look it up. Somewhat related: Export table to existing Excel file instead of creating new file ... View more