topic Re: Updating Shape Field from Lat/Long Fields in Python Questions

Updating Shape Field from Lat/Long Fields

JoelThomas — Wed, 20 Dec 2017 03:31:02 GMT

I'm trying to update the SHAPE field of some points by using field calculator to update the SHAPE field based on X, Y fields in the attribute table. Can this be done? I'm trying the below calculation, and the points are changing location, but not to a location that is near either the X, Y fields I'm asking it to. I'm not sure where I'm going wrong here.

Re: Updating Shape Field from Lat/Long Fields

DanPatterson_Retired — Wed, 20 Dec 2017 03:36:22 GMT

some sample values might help... if they are supposed to be in longitude and latitude, make sure longitude is the X and latitude is the Y (a common error) and in the western hemisphere, longitude is negative..

Re: Updating Shape Field from Lat/Long Fields

JoelThomas — Wed, 20 Dec 2017 03:53:09 GMT

Dan,

Here are my values I'm trying to put in the shape field.

But after I run the calc, and then pull the values out of the shape field, they resemble nothing of the X, Y fields. It changes it to the following. I don't get it.

Re: Updating Shape Field from Lat/Long Fields

DanPatterson_Retired — Wed, 20 Dec 2017 04:08:53 GMT

I would suggest adding the table to arcmap as an event layer then save/export it as a shapefile or featureclass in a geodatabase... there is no point messing with the shapefile since something is amiss. You will have all your attributes and the file will be clean. As shown the top field does have the correct X and Y values with Longitude in the -121 and lat at 42.

Re: Updating Shape Field from Lat/Long Fields

JoelThomas — Wed, 20 Dec 2017 04:26:40 GMT

Shoot, I had the script wrong. I needed the Shape as a parameter. This works. Thanks Dan.

Re: Updating Shape Field from Lat/Long Fields

JayantaPoddar — Wed, 20 Dec 2017 09:23:14 GMT

In ArcGIS, Shape* is a system-managed field that is used to store the Geometry-type of the Features. It is Read-only, and you cannot edit it.

Re: Updating Shape Field from Lat/Long Fields

XanderBakker — Wed, 20 Dec 2017 12:33:25 GMT

The actual reason why the calculation wasn't working is since you return a Point object when the geometry is in fact a PointGeometry.object. See the field calculator expression below:

So you create a point object with the new X and Y and then use the point object to create the point geometry.. What you did in your second example is providing the point geometry to the function and modify the point X and Y properties using the first part, and returning the point geometry object again

CC Jayanta Poddar , it is possible to modify the geometry using the field calculator as the result below shows. The red dots were moved with coordinates from my X and Y fields:

Re: Updating Shape Field from Lat/Long Fields

XanderBakker — Wed, 20 Dec 2017 12:38:03 GMT

Rethinking it I realize that you don't have to specify the spatial reference, since the featureclass already has this defined. You could use this to make thing more simple:

Re: Updating Shape Field from Lat/Long Fields

MichelleWilliamsERM — Tue, 26 Oct 2021 15:49:32 GMT

I'm using ArcPro, and the Python might be different. Can you tell me why my code isn't working, please?

Re: Updating Shape Field from Lat/Long Fields

BlakeTerhune — Tue, 26 Oct 2021 16:41:03 GMT

The function parameters in the code block should not have exclamation marks, that's only for the field names in the expression. Get rid of all ! characters in the code block.

Re: Updating Shape Field from Lat/Long Fields

RyanBohan — Wed, 26 Jul 2023 16:06:37 GMT

Got it working! This will be a huge time saver for shifting assets. Thank you everyone.

Adding a screenshot of my code updated for ArcGIS Pro 2.9.5

Re: Updating Shape Field from Lat/Long Fields

TomReyes — Wed, 08 Nov 2023 22:14:32 GMT

Thanks for the help, I got this to work for me!

This does not seem to work if you have "Enable Undo" enabled. It worked great once I turned that off.

Re: Updating Shape Field from Lat/Long Fields

Krocha — Fri, 09 Feb 2024 19:44:45 GMT

This code made my feature disappear from the map. It succeeded to run but don't know why it disappeared.

Re: Updating Shape Field from Lat/Long Fields

Alex_Zhuk — Mon, 10 Jun 2024 04:28:26 GMT

Thanks a lot! This was exactly what I needed to adjust my 2,600 points.