I have a point FC in a file geodatabase.
I want to create a feature layer on the FC that has columns that show the X & Y coordinates of the geometry.
The values in the query would be dynamic; they would change if the underlying data in the FC was edited.
The result would be similar to what can be done with a query layer on an enterprise/st_geometry geodatabase table—but for a file geodatabase:
select p.*, sde.st_x(p.shape) as x, sde.st_y(p.shape) as y from points p
Yes, I'm aware that we can't use SQL to access the geometry of a FGDB FC. I'm just using this as an example to demonstrate the functionality that I'm looking for.
Is it possible to do this for FGDB FCs in ArcGIS Desktop 10.7.1 or ArcGIS Pro (any version)?