Latest Contributions by Bud

‎03-08-2023

Esri Canada Case 03262451 - Validate Join message has incorrect information (join to table with definition query) BUG-000156405 - Validate Join message is incorrect in ArcGIS Pro when Add Join to table or feature with Definition Query within the same workspace

‎03-07-2023

Related: Support correlated subqueries in file geodatabase SQL expressions

‎03-07-2023

ArcGIS Pro 3.0.3 I have a point feature class. And I have a standalone table with X & Y columns. I want to load the rows from the XY table into the point FC as point features/geometries using the Append tool. Currently, the Append tool's Field Matching functionality doesn't allow mapping XYs to a shape column. Could that functionality be added? I'm aware there are other ways to do it. I'm hoping for functionality that lets me do it directly in the Append tool without needing additional pre-processing steps. Thanks. Bud_0-1678219697257.png

‎03-06-2023

ArcGIS Pro 3.1; Excel 365 .XLS I've added an Excel worksheet to a map. And I've made a subsequent edit to the spreadsheet in Excel. I want to refresh the data in the attribute table to reflect the edit. As far as I can tell, the only way to refresh the attribute table of the worksheet is to refresh the file in the Catalog pane. Hitting refresh in the attribute table has no effect. That behavior is unintuitive to me. I would expect the refresh button in the attribute table to refresh the data, similar to how a Catalog refresh works. Similarly, removing the data from the map and re-adding it from Catalog should refresh the data as well, but it currently doesn't. Could that behavior be changed? Video:

‎03-06-2023

The Mobile geodatabases docs say: Mobile geodatabases are the foundation for interoperable workflows between ArcGIS Pro and ArcGIS Runtime. In the future, mobile geodatabases will enable enhanced workflows and applications in ArcGIS Runtime and the Esri suite of mobile apps. What does that mean? What kinds of enhancements can we expect? Thanks.

‎03-06-2023

I wonder if it would be possible to view the ST_GEOMETRY function definition in a SQLite database where ST_GEOMETRY has been enabled? Load the SQLite ST_Geometry library Edit: It looks like the functions are stored in a .dll. So the answer is likely no. --Load the ST_Geometry library on Windows. SELECT load_extension( 'c:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\SQLite\Windows32 \stgeometry_sqlite.dll', 'SDE_SQL_funcs_init' );

‎03-06-2023

What's the difference between a mobile geodatabase vs. a SQLite ST_Geometry database? (other than the file extension? Mobile Geodatabases Load the SQLite ST_Geometry library Load ST_Geometry to a mobile geodatabase for SQL access I had assumed that ST_Geometry would be installed in mobile geodatabases by default. But it sounds like that's not the case...so that's another similarity between mobile geodatabases and SQLite databases.

‎03-06-2023

Benefits - Mobile geodatabases are stored in an SQLite database, giving them the following advantages: SQLite is a widely available, stable, and trusted database. SQLite is open source in the public domain, so no licensing is required. SQLite databases are supported cross-platform and are stored in a single file on disk, making them portable and an efficient data exchange format. SQLite is a full-featured relational database allowing for querying and reporting workflows and supports operations such as views and indexes. SQLite is interoperable and is ubiquitous in mobile app development.

‎03-06-2023

PostgreSQL: DBA Stack Exchange: PostgreSQL equivalent to Oracle's MAX(...) KEEP (DENSE_RANK FIRST/LAST ORDER BY ...) Edit: @TanuHoque, I submitted a post to the "General" PostgreSQL mailing list -- requesting that the functionality be added to PostgreSQL. The post/email was called "Idea: PostgreSQL equivalent to Oracle's KEEP clause". The content of the request was the same as the SQL Server one I mentioned previously, except it was for PostgreSQL. Related: DBA Stack Exchange - How to request an enhancement to PostgreSQL PostgreSQL Mailing Lists

‎03-04-2023

@DrewFlater In scenarios where the user only wants to update existing rows, not insert new ones, how does Esri recommend we do that? For example, how to only select rows in FC-B that already exist in FC-A when upserting? Use an SQL subquery in the expression parameter to only select rows from FC-B that already exist in FC-A? Or something else? Also, what happens if there are duplicates in FC-B, but no duplicates in FC-A? What row from FC-B will be used to update the row in FC-A?

‎03-03-2023

SQL Server: Stack Overflow: SQL Server equivalent to Oracle's MAX(...) KEEP (DENSE_RANK FIRST/LAST ORDER BY ...) Answer: SQL Server does not implement this. Edit: @TanuHoque, I submitted an idea asking Microsoft to add that functionality to T-SQL: Idea - SQL Server equivalent to Oracle's MAX(...) KEEP (DENSE_RANK FIRST/LAST ORDER BY ...) Feel free to vote for that idea. Related: SQL Server Ideas

‎03-03-2023

I thought I'd share an SQL technique I came across recently — for anyone writing aggregation queries for Oracle: YouTube video: The KEEP clause will KEEP your SQL queries SIMPLE Paraphrased: When doing aggregation, one of the most common requirements is: once we've aggregated on a particular column, we actually want to know information from a different column. Example: For a given country, what city has the highest population? (where the country has more than one city) Include the city name as a column. Bud_1-1677860737930.png I recommend watching that video. Then, for an explanation of the logic of the various SQL keywords, I'd suggest reading the answer in this post: Stack Overflow - Explanation of KEEP in Oracle FIRST/LAST One of the biggest challenges I have when writing SQL queries is keeping them short enough so that they're readable. I think the above technique will help. While this technique doesn't pertain specifically to spatial data, I often write non-spatial queries like the above query on spatial data. I imagine others do too. Related: Oracle Groundbreakers Community - Idea: FIRST() and LAST() aggregate functions

‎03-03-2023

In ArcGIS Pro, add the option for administrators to disable indexing (ArcGISIndexingServer) for all ArcGIS Pro users in an organization. Reason: Reduce load on individual PCs and corporate file systems. Related: Improve ArcGISIndexingServer FAQ: Why does the ArcGISIndexingServer.exe use a high amount of computer memory?

‎03-03-2023

BONUS POINTS: It would also be really great if ArcGIS Pro could allow users to roll back individual edits within a non-versioned SDE edit session. This is not currently planned. We need to first provide parity for ArcMap user workflows and then we can evaluate Undo vs. full discard. To be clear, if this is needed in the future, it would be to Undo edits in reverse order, not pick an edit out of the middle of a stack and undo it. @KoryKramer When the discard edits functionality gets released, will this idea be changed to "Implemented"? If so, will the idea for rollback/undo get lost in the shuffle? In other words, do we need a separate idea for rollback/undo?

‎03-02-2023

Somewhat related: ArcMap: Field Calculator to get JSON text This is basically the inverse of what you're asking for, but it might be of interest: Idea - Event layers for lines, polygons, and multi-part points (via WKT)

My Ideas

Latest Contributions by Bud

Re: Bug: Validate Join message has incorrect information (join to table with definition query)

Re: Expand Summary operations to include Min or Max Dates and fgdb Subqueries

Append — Load XY table into point FC as point features

Refresh Excel data using attribute table refresh button

"In the future, mobile geodatabases will enable enhanced workflows and applications in ArcGIS Runtime and the Esri suite of mobile apps."

Re: Release ST_GEOMETRY functions code?

Difference between mobile geodatabase vs. SQLite ST_Geometry database

Re: Benefits of mobile vs. file geodatabases

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

Re: GP tool to batch-replace geometries from one FC to another (via related IDs)

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

Simplify Oracle aggregation queries (using the KEEP clause)

Option to disable indexing for all ArcGIS Pro users in an organization (ArcGISIndexingServer)

Re: In ArcGIS PRO allow formal edit sessions for unversioned data in an enterprise GDB

Re: Add Geometry as Text Options to 'Calculate Geometry Attributes' (WKT, WKB, GeoJSON)

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