AnsweredAssumed Answered

Convert Coordinate Notation tool creates OID field, need OBJECTID

Question asked by sarahclark on Jul 21, 2016
Latest reply on Jul 21, 2016 by sarahclark

In Python I am running a script as a tool that takes a CSV file of coordinates and creates a feature class of points from the coordinates. I use the Convert Coordinate Notation tool. Script below for context but I am mainly taking issue with lines 43-45.

import arcpy
import os
import re
arcpy.env.overwriteOutput=True

# Get the datasets and folder locations
oldFC = arcpy.GetParameterAsText(0)
fallout = arcpy.GetParameterAsText(1)
newFC = arcpy.GetParameterAsText(2)
# set columns where longitude and latitude are, and the format (two columns assumed)
lonAtt=arcpy.GetParameterAsText(3)
latAtt=arcpy.GetParameterAsText(4)

# Get layer spatial reference
coo = arcpy.Describe(oldFC)
coo = coo.spatialReference
inCoo = arcpy.SpatialReference(4269)

# Sanity check
arcpy.AddMessage("Old met file: " + oldFC)
arcpy.AddMessage("Backup location: " + fallout)
arcpy.AddMessage("CSV data file: " + newFC)

# This splits out the FC name from the Database Connection path
sdeFC = os.path.split(oldFC)[1]
arcpy.AddMessage("SDE file name: " + sdeFC)

# This splits out the Database Connection path
sde = os.path.split(oldFC)[0]
arcpy.AddMessage("SDE: " + sde)

# Also escape out the parentheses ...I don't remember why I did this
sdeI = re.sub('\(.*\)', '', sde)
sdeFCI = re.sub('\(.*\)', '', sdeFC)

# replace special period character with underscores in FC name
backItUp = re.sub('\.', '_', sdeFCI )
arcpy.AddMessage("backup name: " + backItUp)

arcpy.CopyFeatures_management(oldFC, os.path.join(fallout, backItUp + ".shp"))

# set output name the same as the original, so it will get overwritten with updated table
arcpy.ConvertCoordinateNotation_management(in_table=newFC, out_featureclass=oldFC,x_field=lonAtt, 
    y_field=latAtt, input_coordinate_format="DD_2", output_coordinate_format="DD_2",
    in_coor_system=inCoo, spatial_reference=coo)

 

Why does this tool create an OID field instead of an OBJECTID field? I assume it has something to do with the input being a table...but it doesn't make sense because it creates a feature class. Per this FAQ: What are the differences in the behavior of the OBJECTID, FID, and OID fields?  "In a standalone dBase table, the 'OID' field contains the ObjectID, and the values start at zero".

 

The script overwrites an old feature class which has an OBJECTID field since it is in a geodatabase. This tool outputs the OID field and then my map services break because of the change in field name.

 

How can I get back an OBJECTID field and get rid of the OID? Right now my workaround is to not use this tool, and instead make an XY event layer from the table and then copy that into the GDB.

Outcomes