Problem:  Data type in a feature class converts to double when exported from a non-spatial database to an ArcSDE geodatabase

相关信息
Article ID: 43871
Bug Id: N/A
Software:
ArcSDE 10, 10.1, 10.2, 10.2.1, 10.2.2
Platforms: N/A

问题描述
When a feature class is moved from a non-spatial database to a geodatabase using ArcCatalog, the field data type of the feature class is not retained. The data type in the feature class is converted from 'float' data type to 'double' data type.



A feature class can be moved from one geodatabase to another in ArcCatalog by copying and pasting or exporting the feature class.


原因
This behavior occurs when the precision and data type of a field in a feature class are not set during creation of the field. This causes the float field in the feature class to be converted automatically to double data type.
已邀请:

EsriSupport

赞同来自:

解决方案
Specify the precision and scale of a new field on a feature class using the Add Field geoprocessing tool.
Open ArcMap and navigate to ArcCatalog > Toolboxes > System Toolboxes > Data Management Tools > Fields > Add Field. 

Fill the parameters in the Add Field dialog box to create a float data type field in the attribute table of the feature class, and specify the precision and scale of the field. The precision must be 64 or more. 

  1. For further explanation on the precision and scale of the fields, refer to the following documentation: • ArcGIS field data types • Oracle data types supported in ArcGIS • SQL Server data types supported in ArcGIS.
  2. Click OK.


其它相关参考
  1. FAQ: Should I be concerned about precision and scale settings when creating a new field in my attribute table
  2. Bug: ArcCatalog converts column type Double to Numeric when using SQL Server
  3. ArcGIS Help: DB2 data types supported in ArcGIS
  4. ArcGIS Help: Informix data types supported in ArcGIS
  5. ArcGIS Help: PostgreSQL data types supported in ArcGIS
  6. ArcGIS Help: How data converts when importing


创建及修改时间
Created: 1/11/2015

Last Modified: 2/23/2015
原文链接
http://support.esri.com/en/kno ... 43871

要回复问题请先登录注册