Working with oracle spatial tables – Pitney Bowes MapInfo Professional User Manual

Page 195

Advertising
background image

For Spatial Geometry types with Line Objects Only: If you have created a map that contains line

objects only and you are trying to save to PostGIS, this message displays:

Arc is an unsupported object. Convert to polylines?

Click Yes to convert the unsupported objects to polylines; you would select No to decline to convert
the unsupported objects. If you decline, you cannot save the map you have created to the SQL Server
Spatial database.

For Spatial Geometry of type Rectangle: If you have created a map that contains rectangle objects

and you are trying to save to PostGIS, this message displays:

Cannot upload Object - Rectangle object type is not supported in this
table. Operation canceled.

Click OK. You cannot save the map you have created to the PostGIS database.

Working with Oracle Spatial Tables

Oracle Spatial is an implementation of a spatial database from Oracle Corporation. You can install it in
addition to the MapInfo Professional ODBC Connectivity component. Although it has some similarities
to the previous Oracle SDO relational implementation, it is significantly different. Oracle Spatial maintains
the Oracle SDO implementation via a relational schema. However, MapInfo Professional does not support
the Oracle SDO relational schema via the Oracle Call Interface (OCI). MapInfo Professional does support
simultaneous connections to Oracle Spatial through the OCI and to other databases through ODBC.

Supported Object Types

The Multipoint and Collection object types are translated into the Spatial Objects Oracle MULTIPOINT
and COLLECTION, respectively, via Oracle OCI and vice versa. However, Oracle's COLLECTION object
is broader in scope than MapInfo Professional's Collection, which only allows one REGION, one polyline
and one multipoint. Therefore, conversion from MapInfo Professional object to Oracle objects and the
conversion from Oracle objects to MapInfo Professional objects may not be a one-to-one translation.

The following table shows the relationship between MapInfo Professional objects and Oracle objects.

MapInfo Professional Objects

Oracle Spatial Objects

Multipoint

MULTIPOINT

Collection

COLLECTION

Multipoint

Point (cluster)

Polyline

Line String

Multiple Line String

REGION

Polygon

Multiple Polygons

The table indicates how Oracle Spatial objects are translated into MapInfo Professional objects. All point
elements in an Oracle COLLECTION will be translated into one multipoint in a MapInfo Professional
Collection; all Oracle Line objects (including single and multiple) will be translated into one MapInfo
Professional polyline; and all Oracle Polygons (including single and multiple) will be translated into one
MapInfo Professional REGION. Therefore, when an Oracle COLLECTION is modified and then saved
back into Oracle Server by using MapInfo Professional, the original structure of the Oracle COLLECTION
object may be changed if it is more complicated than the MapInfo Professional Collection.

If you are connecting to an Oracle Spatial database,Oracle Spatial is a new spatial schema number 13.
It provides support for points, lines, and polygon spatial types.

195

MapInfo Professional User Guide

Chapter 7: Working with Data in a DBMS

Advertising