Problem: A field value is rounded to the nearest tenth after geocoding
In ArcMap, when geocoding a table exported from an Excel file, the values may be rounded to the nearest tenth. For example, a field value of '2008030257' becomes '2008030260' after geocoding.
This issue occurs when the precision and scale of a field from the imported table does not match the precision and scale of the output field after geocoding is performed.
When a table from an Excel file is imported into ArcMap, the 'long' field property changes to 'double' by default, causing an incorrect output when the table is geocoded.
When merging, importing, or exporting, input datasets into output datasets, all input dataset fields are mapped to the output dataset.
Solution or Workaround
The default field mapping setting must be modified to resolve this issue.
To do this, use the Table to Table tool as it allows to modify or set the Field Map parameters. Hence, users can increase the precision and scale values of the problematic field.
- Convert the Excel file to a CSV file in Microsoft Excel.
- In ArcMap, import the CSV file.
- In the Catalog window, navigate to Toolboxes > System Toolboxes > Conversion Tools > To Geodatabase > Table To Table tool.
- Select the CSV file for the Input Rows field.
- Select the Output Location and determine the Output Table name.
- In the Field Map window, right-click the desired field and click Properties.
- In the Output Field Properties, increase the precision and scale values. Click OK.
- Geocode the table. For more information, refer to the following ArcGIS Web Help topic: Geocoding a table of addresses in ArcMap.
- ArcGIS Help: ArcGIS field data types
- ArcGIS Help: Using the field mapping control
- ArcGIS Help: Data types in the DBMS
- ArcGIS Help: Add Field (Data Management)
- ArcGIS Help: Table to Table (Conversion)
- ArcGIS Help: What is geocoding?