nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Trouver plus de publications taguées avec

Accepted answers

All comments

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

LeonS

Hello,

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

Attribute Assistant | ArcGIS Solutions

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

GideonDalrymple

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

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.

GideonDalrymple

How do I create that viewJesús de Diego?

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

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

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?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.