idea Geo coding | DO NOT change the Field Names in conversion in ArcGIS Pro Ideas

Geo coding | DO NOT change the Field Names in conversion

MichelleWilliamsERM — Thu, 30 Dec 2021 18:04:14 GMT

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!

Re: Geo coding | DO NOT change the Field Names in conversion - Status changed to: Needs Clarification

KoryKramer — Tue, 11 Jan 2022 16:42:18 GMT

Hi @MichelleWilliamsERM isn't this a duplicate request of the idea you posted earlier? https://community.esri.com/t5/arcgis-pro-ideas/geocoding-table-esri-renames-my-fields-would-you/idi-p/1104158

@ShanaBritt responded with helpful information about how to avoid what you're seeing. Please let us know if that works for you, or if not, what specifically isn't working. Thank you!

Re: Geo coding | DO NOT change the Field Names in conversion

MichelleWilliamsERM — Tue, 11 Jan 2022 17:04:49 GMT

@KoryKramer yes it is, thank you for finding them both.

BUT this answer doesn't work for me, because I'm pulling data from a CSV file (with the the same names in the geodatabase). I designed it that way for ease of use.

Then I convert the lat longs,

and then I convert any addresses that didn't include lat longs,

then I need to APPEND to the geodatabase.

Please let me know if this idea will be re-visited. I do this task a few times a month, and I can't be the only one.

Re: Geo coding | DO NOT change the Field Names in conversion

ShanaBritt — Wed, 19 Jan 2022 17:24:00 GMT

@MichelleWilliamsERM If you geocode with csv table with the Minimal output field option, where in your workflow of appending data do you lose your original fields or have to delete fields?

Re: Geo coding | DO NOT change the Field Names in conversion

AZendel — Fri, 28 Jan 2022 14:24:29 GMT

ESRI, please provide an option to exclude the very annoying USER_ prefix to all of the input fields!

Keep original field names in geocoding results

CMV_Erik — Fri, 11 Feb 2022 22:04:44 GMT

This issue was raised in the comments of https://community.esri.com/t5/arcgis-pro-ideas/add-possibility-to-remove-all-quot-match-quot/idi-p/972123 , but the post is marked Implemented, so I thought it might need its own post.

During geocoding, ArcGIS Pro adds a USER_" prefix to certain fields inherited from the original table/feature class. This behavior did not exist in ArcMap, and does not appear to be optional in Pro. I'm assuming this was added because it is necessary in some cases (maybe to proactively prevent field name conflicts?), but also causes new problems that did not exist before.

Example: I was using a fairly complex ModelBuilder model in ArcMap that involved geocoding a text address in a point feature class and comparing it with the geometry to decide which one was better. A lot of steps in that comparison assumed the field names would be the same (including Merge and custom Python). I tried to migrate that model to Pro (2.9.1) and haven't been able to get it to work yet because I'm no longer working with two nearly identical sets of data.

The ArcMap results already worked great, so rather than spend time redesigning or working around, I'd rather ArcGIS Pro perform the same as ArcMap. Even making adding the prefixes a default option would be fine; I don't mind unchecking a box when I need to.

EDIT: https://community.esri.com/t5/arcgis-pro-ideas/geo-coding-do-not-change-the-field-names-in/idi-p/1129680 seems like the same issue

Re: Geo coding | DO NOT change the Field Names in conversion

CMV_Erik — Fri, 11 Feb 2022 22:29:36 GMT

I opened https://community.esri.com/t5/arcgis-pro-ideas/keep-original-field-names-in-geocoding-results/idi-p/1141711 before I found this.

The same .loc locator produces different results in ArcMap and Pro. If I'm reading these threads correctly, the Minimal option might preserve the original attributes as desired, but it's only available in a narrow set of circumstances.

Like @MichelleWilliamsERM I have a workflow that depends on preserving the original schema so I can recombine them (I use Merge instead of Append, but still fairly similar). There seems to be a lot of new requirements to retain the same proven functionality. Since it's a supported option in Pro, and the logic was working fine in ArcMap, it seems like it wouldn't be too hard to change the tool. Restoring the original functionality would save a lot of time and effort spent to work around it.

Re: Geo coding | DO NOT change the Field Names in conversion - Status changed to: Open

KoryKramer — Fri, 11 Feb 2022 23:46:28 GMT

Re: Geo coding | DO NOT change the Field Names in conversion

ShanaBritt — Fri, 11 Feb 2022 23:51:07 GMT

@CMV_Erik If you have created the locator in ArcMap you will not be able to use the output field options when using geocoding tools in ArcGIS Pro. You must create the locator in ArcGIS Pro with the Create Locator or Create Feature Locator tool , then you will have the option to maintain the original input table fields using the Minimal option when geocoding the table. Essentially, you will only get the option to maintain your original table fields in ArcGIS Pro 2.7 and later if you geocode with a locator created with the Create Locator or Create Feature Locator tool.

Re: Geo coding | DO NOT change the Field Names in conversion

CMV_Erik — Tue, 15 Feb 2022 18:55:42 GMT

Hello @ShanaBritt,

I have read your responses related to this, and noted the server requirement you mentioned. To get the same results in Pro that I have now with the legacy locator in ArcMap, I would have to upgrade to Server 10.9, resolve the internal issues that have delayed me creating the updated locator, and allocate resources to create, test and publish the locator. If I create a file locator that is only used within Pro, I would have to maintain both and could not expect same results, so I would have a new quality control problem. I could try add complexity to my model to try to rename the fields, but the new issues this created led me to post on this website rather than finish them.

To summarize, the extra work described for ArcGIS Pro just restores the status quo in ArcMap, so right now there's no value in moving my model to Pro. My idea is for Pro to somehow preserve the status quo instead.

Re: Geo coding | DO NOT change the Field Names in conversion

jzcgis — Wed, 12 Apr 2023 19:27:27 GMT

Very frustrating that this has not been fixed yet. This creates a huge hurdle which results from esri not allowing for the unmatched from a local locator to be geocoded with the esri geocoder. The "USER_" creates a very annoying issue when trying to append the locally matched and the esri geocoded rows. Please fix this!

https://community.esri.com/t5/arcgis-pro-ideas/geocoding-table-esri-renames-my-fields-would-you/idi-p/1104158

https://community.esri.com/t5/arcgis-pro-ideas/add-possibility-to-remove-all-quot-match-quot/idi-p/972123/page/3#comments

Re: Geo coding | DO NOT change the Field Names in conversion

ShanaBritt — Fri, 14 Apr 2023 15:46:36 GMT

@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-results-.htm

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-table.htm#ESRI_SECTION1_092AD2A116A84598A29BD5639C87AC33

What version of ArcGIS Pro are you using?

-Shana

Re: Geo coding | DO NOT change the Field Names in conversion

jlchamber — Fri, 08 Sep 2023 18:24:48 GMT

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!

Re: Geo coding | DO NOT change the Field Names in conversion

ShanaBritt — Wed, 20 Sep 2023 14:41:00 GMT

@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

Re: Geo coding | DO NOT change the Field Names in conversion

AZendel — Tue, 17 Sep 2024 19:54:18 GMT

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")

Re: Geo coding | DO NOT change the Field Names in conversion

ShanaBritt — Tue, 17 Sep 2024 20:38:46 GMT

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