DBMS |
Geometry Storage |
Column Type |
Notes |
DB2 |
Spatial Extender—Geometry Object |
ST_Geometry* |
- Utilizes extended spatial type for managing vector data
- Based on the ISO SQL MM specification for spatial; built in concert with ESRI
|
Informix |
Spatial DataBlade—Geometry Object |
ST_Geometry* |
- Utilizes extended spatial type for managing vector data
- Based on the ISO SQL MM specification for spatial; built in concert with ESRI
|
Oracle |
Spatial Type for Oracle—Geometry type |
ST_Geometry* |
- Utilizes extended spatial type for managing vector data
- Based on the ISO SQL MM specification for spatial
- Default geometry storage for ArcSDE for Oracle
|
|
Well-Known Binary (OGCWKB) |
BLOB |
OGC simple features type |
|
ArcSDE Compressed Binary |
LONG RAW or BLOB |
Provides high performance, scalability, and reliability |
|
Oracle Spatial—Geometry Type |
SDO_Geometry |
Oracle Spatial users can optionally use the SDO_Geometry column type. You can make this decision on a table by table basis, so you can choose the best option for each individual dataset. |
PostgreSQL |
Spatial type for PostgreSQL |
ST_Geometry* |
- Utilizes extended spatial type for managing vector data
- Based on the ISO SQL MM specification for spatial
- Default geometry storage for ArcSDE for PostgreSQL
|
|
PostGIS |
Geometry |
PostGIS users can choose to use the PostGIS geometry column type. This type follows the OpenGIS Simple Features Specification for SQL. |
SQL Server** |
ArcSDE Compressed Binary |
Image |
- The binary type fully manages complex binary streams required for complex line and polygon features found in typical and advanced GIS applications.
- The default geometry storage for ArcSDE geodatabases for SQL Server.
|
|
Well-Known Binary (OGCWKB) |
Image |
OGC simple features type |
|
Microsoft SQL Server Geometry type |
Geometry |
- One of the Microsoft SQL Server spatial storage types
- Provides a spatial type for managing vector data that is defined by coordinates on an arbitrary plane and for which the curvature of the Earth does not need to be taken into account
|
|
Microsoft SQL Server Geography type |
Geography |
- One of the Microsoft SQL Server spatial storage types
- Provides a spatial type for spatial data that is defined by latitude and longitude coordinates and for which the curvature of the Earth does need to be taken into account
|
NOTE: ESRI recommends you do not use SQL commands to alter the geometry storage type of a dataset after it has been created.