topic Re: Adding XY Fields to an Attribute Table in Data Management Questions

Adding XY Fields to an Attribute Table

KONPETROV — Fri, 16 Jan 2015 13:57:23 GMT

Hello i have a point.shapefile with fields: FID:0123..., Shape:Points, CONTOUR:400, 401 etc, X, Y. I want to add x,y coordinates to attribute table from a mosaic, how can i do that?

I tried from field calculator the following script for X and Y fields at 'show codeblock':

Dim dblX As Double

Dim pPoint As IPoint

Set pPoint = [Shape]

dblX = pPoint.X

dblX

but i have always an error 999999. I am using ArcGis 10.2.2. any suggestion?

Re: Adding XY Fields to an Attribute Table

JakeSkinner — Fri, 16 Jan 2015 14:10:26 GMT

Hi Konstantinos,

There is a Geoprocessing tool that will do this for you:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Re: Adding XY Fields to an Attribute Table

TedKowal — Fri, 16 Jan 2015 15:17:15 GMT

As Jake mentioned there are numerous different Geoprocessing tools that will do this depending on your own unique conditions....

Have you tried the most simple direct way? Right click on the field you want to populate on your attribute table and choose calculate geometry?

Re: Adding XY Fields to an Attribute Table

JoshuaBixby — Fri, 16 Jan 2015 17:46:50 GMT

The code you provide above is from the Making Field Calculations help from ArcGIS 9.3/9.3.1, and therein lies your problem. The code Esri provided was VB/VBA and involved accessing ArcObjects. Starting with ArcGIS 10.0, Esri moved to a VBScript parser instead of a fuller-featured VB/VBA. Although some VB code still works in the code block for the field calculator, the specific code you used doesn't because you can't acess ArcObjects through VBScript.

Even if the code you posted worked, VB support has been on life support for a long time, and you should really consider moving to Python. If you simply change the parser to Python, the following code will work in the expression box (you don't need a code block): !shape.extent.XMax! . Since it seems you are working with points, and single points at that, the extent of the geometry will be the geometry itself. You could also use !shape.firstPoint.X! as well.

Re: Adding XY Fields to an Attribute Table

KONPETROV — Fri, 16 Jan 2015 18:08:51 GMT

thank you very much sir, it helped me a lot

Re: Adding XY Fields to an Attribute Table

XanderBakker — Fri, 16 Jan 2015 18:32:24 GMT

You can also do it automatically with Python as I showed in this post: Automatic X and Y in Attribute Table

Re: Adding XY Fields to an Attribute Table

KONPETROV — Sat, 17 Jan 2015 02:48:21 GMT

can i also use compute geometry for that? for each field (x,y )separate?

Re: Adding XY Fields to an Attribute Table

XanderBakker — Sat, 17 Jan 2015 03:04:27 GMT

Not sure to which answer you are replying:

Jake showed you a tool that in a single run will add the fields POINT_X and POINT_Y to you featureclass
Ted showed that you can calculate the fields using Calculate Geometry (use X coordinate of Point for X and Y Coordinate of Point for Y)
Joshua offered a method to use a python syntax to fill the fields using the field calculator (!shape.firstPoint.X! for X and !shape.firstPoint.Y! for the Y field).
My suggestion has the ability to loop through all the featureclasses in a workspace and add the fields to each of them

You will have to decide which method suits your specific needs best.