ArcGIS Field Type /esriFieldTypeDate(转)
2024-09-04 10:58:31
ArcGIS Field Type
The following table outlines the equivalent field data types in ArcCatalog, ArcObjects, Visual Basic and a selection of DBMSs:
| ArcCatalog |
esriFieldType (IField::Type) |
VB Variable Type (IField::VarType) |
Access | SQL Server | Oracle |
|---|---|---|---|---|---|
| Short Integer | esriFieldTypeSmallInteger | vbInteger | Number (Integer) | smallint | NUMBER |
| Long Integer | esriFieldTypeInteger | vbLong | Number (Long Integer) | int | NUMBER |
| Float | esriFieldTypeSingle | vbSingle | Number (Single) | float | NUMBER |
| Double | esriFieldTypeDouble | vbDouble | Number (Double) | float | NUMBER |
| Text | esriFieldTypeString | vbString | Text | varchar | VARCHAR2 |
| Date | esriFieldTypeDate | vbDate | Date/Time | datetime | DATE |
| Object ID | esriFieldTypeOID | vbLong | AutoNumber (Long Integer) | int | NUMBER(38) |
| Geometry | esriFieldTypeGeometry | vbDataObject | OLE Object | int | NUMBER(38) or SDO_GEOMETRY |
| Blob | esriFieldTypeBlob | vbObject | OLE Object | image | NUMBER(38) or SDO_GEOMETRY |
| Raster | esriFieldTypeRaster | vbDataObject | Number (Long Integer) | int | NUMBER |
| GUID | esriFieldTypeGUID | vbString | Number (Replication ID) | uniqueidentifier | CHAR |
| GlobalID | esriFieldTypeGlobalID | vbString | Number (Replication ID) | uniqueidentifier | CHAR |
The following table outlines the Coverage, INFO Item to Geodatabase field mapping:
| Item type | Item width | Geodatabase field type (esriFieldType) |
|---|---|---|
| B | 4 | esriFieldTypeInteger |
| C | 1-320 | esriFieldTypeString |
| D | 8 | esriFieldTypeDate |
| F | 4 | esriFieldTypeSingle |
| F | 8 | esriFieldTypeDouble |
| I | 1-4 | esriFieldTypeSmallInteger |
| I | 5-9 | esriFieldTypeInteger |
| I | 10-16 | esriFieldTypeDouble |
| N | 1-9 | esriFieldTypeSingle |
| N | 10-16 | esriFieldTypeDouble |
The following table outlines the Shapefile, dBASE field to Geodatabase field mapping:
| Field type | Field width | Geodatabase field type (esriFieldType) |
|---|---|---|
| Date | - | esriFieldTypeDate |
| String | 1-255 | esriFieldTypeString |
| Boolean | - | esriFieldTypeString |
| Number | 1-16 (decimals = 0) | esriFieldTypeInteger |
| Number | 1-16 (decimals > 0) | esriFieldTypeDouble |
Note: Shapefiles only support date fields. Time is not supported. Geodatabases support date\time fields. If a shapefiles date field is queried for the time a default value of "12:00:00 AM" will be returned.
最新文章
- 深入浅出WPF开发下载
- 【5_283】Move Zeroes
- new XMLHttpRequest()和页面关系
- redis基本数据类型及方法
- c#部分--- 一维数组放到集合中，在从集合中提取输出
- 转：java日志组件介绍（common-logging，log4j，slf4j，logback ）
- poj-1469-COURSES-二分图匹配-匈牙利算法（模板）
- 已知w是一个大于10但不大于1000000的无符号整数，若w是n(n≥2)位的整数，则求出w的后n-1位的数。
- 指定字符串加密（对称加密DES）
- 大数据系列修炼-Scala课程04
- Python 列表浅拷贝与深拷贝
- [DP]P2890 [USACO07OPEN]便宜的回文Cheapest Palindrome
- Dora.Interception, 一个为.NET Core度身打造的AOP框架：不一样的Interceptor定义方式
- 使用layui在规定的期限内选择日期
- 经典CSS坑：如何完美实现垂直水平居中？
- 查看 Secret - 每天5分钟玩转 Docker 容器技术（156）
- 移动端，input、textarea滚动至可视区域
- BZOJ4817[Sdoi2017]树点涂色——LCT+线段树
- navicat连接不上Linux服务器上的MySQL
- springMVC入门(一)