Geo coding | DO NOT change the Field Names in conversion

[MichelleWilliamsERM]

This task takes much longer than it should, and I'm asking that Esri change the conversion code so that MY Field Names stay the same. Right now, all the Field Names change to USER_[My Field Name], which means that I must reconnect every field when I append.

Thank you in advance for making this a reality!

[ShanaBritt]

@jzcgis ,

Is the Minimal Output Fields option in the Geocode Addresses or Geocode Table tools not working for your workflow? You need to have ArcGIS Pro 2.7 or later, a locator created with the Create Locator tool or Create Feature locator tool and if its a service it needs to be on Enterprise 10.9.

The note at the top of the following topic describes what is added to the geocode result and the fields that are returned with the various Output Fields parameter option. https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/what-is-included-in-the-geocoded-result...

If you are wanting to rematch your unmatched results with a different locator, that option is available in the Rematch Addresses pane, where you can change the locator as well as some geocoding options like score and categories. See the 'Match with new locator' section in https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/rematch-locations-converted-from-a-tabl...

What version of ArcGIS Pro are you using?

-Shana

[jlchamber]

This is still an issue even when "minimal" is selected for outputs. Is this still being looked into to change? Another person doing a merge of multiple geocoded tables and this would make the merge much much smoother.

Thank you!

[ShanaBritt]

@jlchamber Based on the following description, what about the fields that are returned presents a problem for you? Does 'Location Only' work for your workflow?

"Minimal returns following fields that describe the location and how well it matches information in the locator in the geocode results: Shape, Status, Score, Match_type, Match_addr, and Addr_type. The original field names from the input address table are maintained."

Location Only returns the Shape field plus the original field names from the input address table.

-Shana

[AZendel]

I think I'm still having this issue because our county's ArcGIS Server is still at 10.81 and my Pro version is still 3.03 due to a different compatibility issue with the server. 

For anyone who still runs into this, try this ArcPy script to remove "USER_" from each field name. You can add it to a toolbox and use it like any other geoprocessing tool. 

# Import arcpy module
import arcpy

# Script arguments
inLayer = arcpy.GetParameterAsText(0)
if inLayer == '#' or not inLayer:
    inLayer = "C:\\TEMP\\ArcGISUpload.gdb\\Test" # provide a default value if unspecified

fld_list = arcpy.ListFields(inLayer,"")
for fld in fld_list:
    thisField = fld.name
    if "USER_" in thisField:
        newFieldName = thisField[5:]
        arcpy.AddMessage("Removing USER_ from " + newFieldName)

        try:
            # Process: Alter Field
            arcpy.AlterField_management(inLayer, thisField, newFieldName, newFieldName)
        except arcpy.ExecuteError:
            arcpy.AddWarning("An error occurred when trying to remove USER_ from " + newFieldName + ". It probably exists elsewhere in the table. SKIPPING")

[ShanaBritt]

@AZendel , correct you need Enterprise 10.9 or later to use the Minimal option in the optional Output Fields parameter.