topic Re: Automatic Updates in X Y data fields in Geodatabase Questions

Automatic Updates in X Y data fields

GideonDalrymple — Thu, 01 Sep 2016 21:50:32 GMT

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

Re: Automatic Updates in X Y data fields

DanPatterson_Retired — Fri, 02 Sep 2016 00:22:46 GMT

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?

Re: Automatic Updates in X Y data fields

VinceAngelo — Fri, 02 Sep 2016 02:05:43 GMT

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

Re: Automatic Updates in X Y data fields

Anonymous User — Fri, 02 Sep 2016 08:10:58 GMT

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

Re: Automatic Updates in X Y data fields

GideonDalrymple — Fri, 02 Sep 2016 10:37:16 GMT

How do I create that viewJesús de Diego?

Re: Automatic Updates in X Y data fields

GideonDalrymple — Fri, 02 Sep 2016 10:56:08 GMT

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.

Re: Automatic Updates in X Y data fields

GideonDalrymple — Fri, 02 Sep 2016 11:06:47 GMT

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

Re: Automatic Updates in X Y data fields

Anonymous User — Fri, 02 Sep 2016 11:12:37 GMT

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

Re: Automatic Updates in X Y data fields

LeonS — Fri, 02 Sep 2016 12:32:49 GMT

Hello,

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

Attribute Assistant | ArcGIS Solutions

Re: Automatic Updates in X Y data fields

VinceAngelo — Fri, 02 Sep 2016 14:45:11 GMT

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