تعريف الحقول حسب موقع الملف في قاعدة يوجد

[بهجت يوسف الجعافرة]

بسم الله
السلام عليكم
تحية طيبة
يعتمد انشاء الملف الرقمي هل هو داخل قاعدة بيانات ام لا
فأذا كان داحل قاعدة بيانات فأنه يخضع لتعريفات وتحديدات تلك القاعدة مثل Acces Oracle SQL Server ....etc
ويمكن عمل Relation ,typs , subtypes ..etc
اذا لم يكن في قاعدة بيانات فتخزن معلوماتة ضمن DB4
ولا يمكن عمل Relation ,typs , subtypes ..etc


Access data types
When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to Access data types in the following table.

ArcGIS data type Access data type Notes

SHORT INTEGER Integer

LONG INTEGER Long Integer

FLOAT Single

DOUBLE Double

TEXT Text

DATE Date/Time

RASTER Memo Memo fields can store up to 65,536 characters.




DB2 data types
When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to DB2 types in the following table.
ArcGIS data type DB2 data type Notes
OBJECTID INTEGER(4) NOT NULL
SHORT INTEGER SMALLINT(2)
LONG INTEGER INTEGER(4)
FLOAT DECIMAL(31,8)
DOUBLE DECIMAL(31,8)
TEXT VARCHAR(n)
DATE TIMESTAMP


Informix data types
When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to Informix types in the following table.
ArcGIS data type Informix data type Notes

SHORT INTEGER SMALLINT(2)

LONG INTEGER INT(4)

FLOAT DECIMAL(32)

DOUBLE DECIMAL(32)

TEXT VARCHAR(n)

DATE DATETIME


Oracle data types
When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to Oracle types in the following table.

ArcGIS data type Oracle data type Notes
OBJECTID NUMBER(38) NOT NULL
SHORT INTEGER NUMBER(4)
LONG INTEGER NUMBER(38)
FLOAT NUMBER(38,8)
DOUBLE NUMBER(38,8)
TEXT VARCHAR2(50)
DATE DATE
SDO_GEOMETRY Oracle data type depends on the geometry storage specified for the layer.
RASTER BLOB


ArcGIS data type PostgreSQL data type Notes
OBJECTID INTEGER
SHORT INTEGER SMALLINT
LONG INTEGER INTEGER
FLOAT NUMERIC(38,8)
DOUBLE NUMERIC(38,8)
TEXT CHARACTER VARYING
DATE TIME WITHOUT TIME ZONE
GUID CHARACTER VARYING(38)

GEOMETRY
Data type depends on the geometry storage specified for the layer.
RASTER INTEGER





SQL Server data types
When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to SQL Server types in the following table.
ArcGIS data type SQL Server data type
OBJECTID INT(4)*
SHORT INTEGER SMALLINT(2)
LONG INTEGER INT(4)
FLOAT REAL
DOUBLE DOUBLE**
TEXT VARCHAR(n)
DATE DATETIME
BLOB IMAGE
GUID UNIQUEIDENTIFIER(16)
GEOMETRY IMAGE
RASTER IMAGE