Automatic Updates in X Y data fields

[GideonDalrymple]

Is it possible to display X Y coordinates for a point shapefile in a geodatabase which will cause the values to automatically update whenever the point is moved? Just like how the "shape.len" field in a line featureclass in a geodatabase works. When the line is stretched, the length is also increased accordingly. 

Awaiting your discussion!

Thanks in advance!

Gideon

[DanPatterson_Retired]

shapefiles can't auto-update anything, nor do they have their coordinates in the table, unless actually calculated.  Even then, they would have to be manually updated upon change.

Could you clarify why this needs to be accomplished? Is this a convenience function?

[GideonDalrymple]

Actually I'm working with a point featureclass in an enterprise geodatabase not a shapefile. Sorry for missleading. So I have thounsands of points which I want their lat longs to be displayed in the attribute table. Every day a few of these points locations will be changed. I would like for their new coordinates to be updated automatically. 

[VinceAngelo]

If the points were in a database instance you could create a trigger to automatically update both lon and lat when the geometry was updated (and vice versa -- update the geometry when either lon or lat was changed).  Neither shapfiles nor file geodatabase support the concept of triggers, which means your application will need to enforce the desired behavior, but this can be defeated by not using the application.

- V

[GideonDalrymple]

Sounds very interesting Vince. What's the first step in creating that trigger?

[VinceAngelo]

That entirely depends on what RDBMS you are using.  Please be sure to specify the exact version of ArcGIS and the exact database product (with complete version, to patch level) with each initial post (it will generate answers faster, since there won't need to be multiple queries for additional information, or answers not applicable to your environment).  Note that "shapefile" is a specific format, and when its data is loaded in a database it is no longer in that format.

- V

[Anonymous User]

Hi all

Additionally, I suppose that you can create a view that "exposes" ST_X and ST_Y of the original geometry...

Regards

Jesús de Diego

[GideonDalrymple]

How do I create that viewJesús de Diego?

[Anonymous User]

Are you using an Enterprise Geodatabase? Which version? 

Is your base feature class registered as versioned? 

Which geometry type storage are you using for this layer? You should use ST_Geometry or your DMBS. specific geometry type.

Jesús de Diego

[LeonS]

Hello,

The attribute assistant add-in would do the trick, if you are doing the edits within ArcMap.

Attribute Assistant | ArcGIS Solutions