Problem: A field value is rounded to the nearest tenth after geocoding
【相关信息】
Article ID: 43356
Bug Id: N/A
Software:
ArcGIS for Desktop Advanced 10.1, 10.2
ArcGIS for Desktop Standard 10.1, 10.2
ArcGIS for Desktop Basic 10.1, 10.2
Platforms: N/A
【问题描述】
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.
Article ID: 43356
Bug Id: N/A
Software:
ArcGIS for Desktop Advanced 10.1, 10.2
ArcGIS for Desktop Standard 10.1, 10.2
ArcGIS for Desktop Basic 10.1, 10.2
Platforms: N/A
【问题描述】
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.
1 个回复
易智瑞技术支持
赞同来自:
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.
【其它相关参考】
【创建及修改时间】
Created: 10/30/2014
Last Modified: 2/6/2015
【原文链接】
http://support.esri.com/en/kno ... 43356
要回复问题请先登录或注册