Working with Oracle Spatial Data
MapInfo Pro uses Oracle Spatial for Oracle tables (XY is supported via OCI). MapInfo Pro does not support HH_CODE (and the old version of SDO index types).
Supported Oracle Data Types
The following lists non-spatial data types from Oracle Spatial and what they are treated as in MapInfo Pro:
| From Oracle | to MapInfo Pro |
|---|---|
|
RAW, LONG RAW |
BinaryString up to 127 bytes shown as Hex characters |
|
Named type |
MIObject |
|
Named Object type (SDO_GEOM) |
MIObject |
|
BLOB, CLOB |
Not Supported |
|
CHAR, VARCHAR, LONG, LONG VARCHAR |
Character |
|
Number, Decimal |
if no scale or precision: Float else Decimal |
|
INTEGER |
Integer |
|
FLOAT |
Float |
|
DATE |
Date |
MapInfo Pro captures many Oracle data types and translates them into MapInfo native types. When the column is updated, Oracle data makes sure that the data being bound is translated into the column format (for example, MapInfo Pro can bind a character as a long and send it through to Oracle and on the other end it will be translated into a long number in the table).
Spatial Object Types from Oracle Spatial to MapInfo Pro
| From Oracle: GTYPES | to MapInfo Pro |
|---|---|
|
0 UNKNOWN_GEOMETRY (Spatial ignores this geometry.) |
NULL |
|
1 POINT Geometry contains one point. |
Point |
|
2 LINESTRING Geometry contains one line string. |
Line (if only 2 pts) or Polyline if > 2 pts) |
|
3 POLYGON Geometry contains one polygon. |
Region |
|
4 Collection Geometry is a heterogeneous collection of elements. |
Collection |
|
5 MULTIPOINT Geometry has multiple points. |
MultiPoint |
|
6 MULTILINESTRING Geometry has multiple line strings. Poly-line |
Region |
|
7 MULTIPOLYGON Geometry has multiple polygons (more than one exterior boundary). |
Region |
Geometry Conversions from Oracle Spatial to MapInfo Pro
The following lists Oracle Spatial geometry types and what they convert to in MapInfo Pro.
| Geometry Type | Converted to MapInfo Type | Comments |
|---|---|---|
|
Circular Arc |
Polyline |
Circular Arcs are made up of three coordinates, starting point, any point on the arc, and ending point. MapInfo Pro will use these three points to form a polyline representing the arc. |
|
Circle |
Region |
Circles are made up of three coordinates on the circumference of the circle. MapInfo Pro will use these three points to form a circular region. |
|
Rectangle |
Region |
|
|
MULTIPOINT |
Multipoint |
|
|
COLLECTION {Point (cluster), Line String, Multiple Line String, Polygon, Multiple Polygon} |
Collection {Multipoint, Polyline, Region} |
|
|
Unknown or invalid geometries or user defined. |
Oracle currently does not have a mechanism to check the validity of objects. MapInfo Pro will perform some geometry checks. If MapInfo Pro detects an invalid or an unknown geometry, it will return a null object to prevent errors. No error message will display to notify users of the null geometries. |
MapInfo Pro can download some or all of an Oracle Spatial table through either a spatial query or attribute query.