Latest Contributions by Bud

‎12-07-2022

Is there documentation that outlines what functionality was released at each FGDB version, and when? Fake examples: Version 1.4 (2010) - API released Version 1.x (2020) - FGDB database views added Etc. Thanks.

‎12-07-2022

Did you end up finding any info on the cause or a solution? Were the time stamps exactly the same? Or were they roughly 30 +/- seconds different?

‎12-07-2022

Maybe posting the recording as a true video in My Videos is a better option than a GIF.

‎12-07-2022

@LanceShipman Regarding: "File Geodatabase does not support correlated subqueries" Does that still apply to ArcGIS Pro 3.0.3? There seems to be a lot of stuff supported in FGDBs these days, including INNER JOIN (SQL for reporting and analysis on file geodatabases) and database views. I'd like to think correlated subqueries would be supported in this modern age. I ask because of a related post I wrote here: File Geodatabase SQL expression to get greatest n per group

‎12-07-2022

For my notes, Esri Canada support said this (case 03209739): "Based on your workflow, the diagram does appear to be presenting correctly and I will try to break it down below: In the diagram, each join performed has the Join information with the Source and Destination table. The source table would be your input table (Test_FC) and the destination table would be your join table (Test_Table) . In the case of your first join, the diagram would look similar to this: When the second join is added, the source table is the previously joined table above (Test_FC/Test_Table) and the destination table is Test_Table_2: Expanding the source table here would display the first join details (first image above)

‎12-07-2022

Related: User-defined SQL join clause GP tool to select greatest n per group File Geodatabase SQL expression to get greatest n per group [ERROR 000358: Invalid expression] Support correlated subqueries in file geodatabase SQL expressions Select greatest n per group using EXISTS What SQL standard to use when writing geodatabase-agnostic SQL expressions?

‎12-07-2022

This is how it’s done in other enterprise platforms. You define an SQL WHERE clause for the join. You can join on multiple fields if you need to. And include complex expressions, case statements, subqueries, etc. If you want to pare down a 1:M join to a 1:1 join, you can do that in the SQL clause too, using ORDER BY, FETCH FIRST ROW ONLY, etc. or just use a subquery. Source: Field based on relationship: What if relationship is 1:M? and https://www.bpdzenith.com/the-bpd-blog/maximo-relationships It’s similar to the idea of having a user-defined ORDER BY clause in a join: One-to-first joins: Control what related record is used

‎12-07-2022

I have cases where a layer has information in the symbology class label, but not as an attribute. (The layer isn't mine; I wouldn't have set it up like that.) For example, someone has manually typed UNIT information into the symbology label; there isn't a UNIT field in the layer. When using the Explore/Identify tool on features, it would help if the feature's symbology information could be displayed in the Explore/Identify window (including the symbol label). That would give me an easy way to know what UNIT the polygon pertains to. Otherwise, each time I Explore/Identify on a feature, I need to look at the attribute (i.e. COLOR), then manually look up the corresponding value/label in the symbology (i.e. the UNIT). That technically works, but is a nuisance and error prone if done often. Idea: Could ArcGIS Pro be enhanced so that the Identify/Explore tool displays the feature's symbology in the popup window? (including the symbol label) It could be an optional setting. Thanks. ArcGIS 3.0.3

‎12-06-2022

I'm working with a FGDB FC that has data, of sorts, stored in the symbology. What I mean is: there is UNIT information in the symbology as labels, yet that UNIT information doesn't exist in a field in the attribute table of the FC anywhere. Using ArcPy, is there a way to print a list of the layer’s symbology class values and symbol labels? I have 20+ layers, all with different symbology, so it would be ideal if I could do it programmatically. If I could get a list, then I could manually: Copy/paste that list into a lookup table, either in Excel or right in the attribute table. Join from the layer to the lookup table via the common COLOR field. Use the field calculator to update a new UNIT field in the layer. Use the layer’s new UNIT field for analysis as required. I’m new to ArcPy. I’ve tried to modify a couple of sample scripts online. But I don’t really know what I’m doing yet. Any tips would be appreciated. ArcGIS Pro 3.0.3. Related: Export symbology classes to a table

‎12-06-2022

Could FGDB SQL be enhanced to support correlated subqueries? Example: Using an SQL expression in the Select by Attributes tool, I want to select the greatest 1 per group. NOT EXISTS ( SELECT * FROM road_insp r2 WHERE r2.asset_id = road_insp.asset_id AND r2.date_ > road_insp.date_ ) --Demo: https://dbfiddle.uk/gSGjLTCW The above SQL expression would work as expected in mobile GDBs and enterprise GDBs. But in file GDBs, it would select all rows in the table, which would be incorrect. It’s important to note that the query fails silently, producing incorrect results, rather than throwing an useful error. Related: Clarify the docs: Correlated subqueries not supported in FGDB SQL expressions Could FGDB SQL be enhanced to support correlated subqueries? Thanks.

‎12-06-2022

Is there an OOTB geoprocessing tool that can be used to select the greatest 1 per group in a FGDB table? For example, for a given ASSET_ID, select the road inspection that has the latest date. Related: File Geodatabase SQL expression to get greatest 1 per group [ERROR 000358: Invalid expression] Idea: Geoprocessing tool to select greatest 1 per group (without creating a new FC) Selecting the most recent records based on unique values in another field

‎12-06-2022

In an SQL expression, when typing something like b.asset_id : When typing the letter b , then typing a period . , the period triggers it to autocomplete the b to BETWEEN . That's not what I wanted. I wanted to type b.asset_id , not BETWEEN. Could that behavior be changed? Thanks. Related: Optionally disable SQL expression autocomplete

‎12-06-2022

When writing complex SQL expressions, the SQL autocomplete becomes more of a hindrance than a help. It tries to autocomplete every word of SQL, which is more than most SQL clients do, and it ends up getting in the way. It would help if we had the option to disable it.

‎12-06-2022

For what it's worth, the docs say this about the SQL syntax used by FGDBs: SQL reference for query expressions used in ArcGIS All SQL used by the file geodatabase is based on the SQL-92 standard. That doesn't address the original question, but it does help clarify what kind of SQL the FGDB uses. Related: SQL for reporting and analysis on file geodatabases

‎12-06-2022

Is there documentation that outlines what functionality was released at each FGDB version, and when? Fake examples: Version 1.4 (2010) - API released Version 1.x (2020) - FGDB database views added Etc. Thanks.

My Ideas

Latest Contributions by Bud

File geodatabase release history

Re: Duplicate points being created in Arc Collector when copying feature

Re: Single-click selection: Only one of many overlapping features selected; what logic is used?

Re: When EXISTS Doesn't: File Geodatabases and Correlated Subqueries

Re: Making sense of Layer Properties >> Joins diagram

Re: One-to-first joins: Control what related record is used

Re: Manually specify join clause using SQL

Identify/Explore tool: Display feature's symbology & symbol label in the popup window

Get list of layer’s symbology classes and symbol labels using ArcPy?

Support correlated subqueries in file geodatabase SQL expressions

GP tool to select greatest 1 per group

SQL Expression: Typing a period shouldn't autocomplete a word

Disable autocomplete in SQL expression builder

Re: Are FGDBs an extension of a different database engine under the hood?

File geodatabase release history

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

Experience Builder Tips and Tricks

Roads and Highways User Group (RHUG)

Local Government Solutions Users

Mapping and Charting Enterprise Databases