Python Calculate Latitude Longitude based on offsets

JamesCunningham1

Does anyone have a script that will take a latitude and longitude value in decimal degrees and calculate a new latitude and longitude value, based on moving from the given lat/long east 350 ft and south 750 feet for example?

jskinner

Here is an example on how to create an XY event layer from your SQL table and then reproject the coordinates from decimal degrees to feet:

import arcpy
from arcpy import env
env.workspace = r"Database Connections\PUBS.sde"

table = "pubs.dbo.XY"

arcpy.MakeXYEventLayer_management(table, "X", "Y", "XY_layer", r"C:\data\test.gdb\Airports_WGS84")


rows = arcpy.SearchCursor("XY_layer", "", r"C:\data\test.gdb\Airports_NAD83_feet")
for row in rows:
    print row.shape.centroid.X, row.shape.centroid.Y

del row, rows

The XY event layer is created with the same coordinate system as the Airports_WGS84 feature class.  In this case it is geographic.  Then, the XY coordinates are returned based off of a NAD83_feet coordinate system using the SearchCursor function and printed out.

If you are looking to update the SQL table with these values, SDE will need to be installed and the table will need to be registered with the geodatabse.  You can then use the 'UpdateCursor' to update new fields.