topic Re: Python Field Calculator - State Plane to Lat/Long project on the fly? in Python Questions

Python Field Calculator - State Plane to Lat/Long project on the fly?

RichardCitkowicz1 — Thu, 13 Jun 2019 18:54:30 GMT

Without creating a new feature class to define the projection, I am looking for a way to Field Calculate values to WGS84 Lat/Long from State Plane ft.

The field calculator expression works great but uses the projection of the feature class using this expression !shape.extent.XMax! and !shape.extent.YMax! and adds the state plane feet values into the field specified but I want it to be Lat/Long not feet nor do I not want to create new data nor new fields.

How can I add the cursor? expression to project on the fly and calculate Lat and Long Values instead of State Plane feet which is what the projection is of the feature class.

Re: Python Field Calculator - State Plane to Lat/Long project on the fly?

JakeSkinner — Sat, 11 Dec 2021 19:42:25 GMT

You can do this by specifying a Geographic Coordinate system. For example WGS 84 has a WKID of 4326. Here is an example of using an update cursor with this projection and updating the lat, long fields:

import arcpy
from arcpy import env
env.workspace = r"C:\temp\python\test.gdb"

fc = "vehicles"

sr = arcpy.SpatialReference(4326)

with arcpy.da.UpdateCursor(fc, ["LONG", "LAT", "SHAPE@X", "SHAPE@Y"], "", sr) as cursor:
    for row in cursor:
        row[0] = row[2]
        row[1] = row[3]
        cursor.updateRow(row)

del cursor‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Note, to find the WKID you can right-click on the Data Frame > Properties > select the coordinate system > Details:

Re: Python Field Calculator - State Plane to Lat/Long project on the fly?

RichardCitkowicz1 — Thu, 13 Jun 2019 19:56:19 GMT

Still not getting the results.

import arcpy
from arcpy import env
env.workspace = "C:\Users\rcitkowicz\OneDrive - SJ Industries\SJI Files\MaximoSample_WorkOrders.gdb"

fc = "WO_POINT"

sr = arcpy.SpatialReference(4326)

with arcpy.da.UpdateCursor(fc, ["LONG", "LAT", "SHAPE@X", "SHAPE@Y"], "", sr) as cursor:
for row in cursor:
row[0] = row[2]
row[1] = row[3]
cursor.updateRow(row)

del cursor

My LAT/LONG Fields are !POINT_X! !POINT_Y!

Where do I specify this? tried a few spots by no avail.

Re: Python Field Calculator - State Plane to Lat/Long project on the fly?

DanPatterson_Retired — Thu, 13 Jun 2019 19:59:20 GMT

Emulate...

Re: Python Field Calculator - State Plane to Lat/Long project on the fly?

JakeSkinner — Thu, 13 Jun 2019 20:00:34 GMT

Replace LONG and LAT in the following line with POINT_X and POINT_Y:

with arcpy.da.UpdateCursor(fc, ["LONG", "LAT", "SHAPE@X", "SHAPE@Y"], "", sr) as cursor:‍

Should be:

with arcpy.da.UpdateCursor(fc, ["POINT_X", "POINT_Y", "SHAPE@X", "SHAPE@Y"], "", sr) as cursor:‍