Pitney Bowes MapXtreme - Manual (Page 216)

Chapter 11: Accessing Data from a DBMS
Mapping DBMS Data with X/Y Columns
MapXtreme v7.1 223 Developer Guide
ti.CacheSettings.CacheType = CacheOption.Off ' On is the default
Dim tbl As Table = connection.Catalog.OpenTable(ti)
End Sub
Mapping DBMS Data with X/Y Columns
You can access data from a DBMS table that has X/Y coordinates. You need to create a
MapInfo_MapCatalog and register the tables as SpatialType 4.0 and specify two column names as
the coordinates. The columns should be indexed on the table. Connect to the DBMS via ODBC and
specify the new columns as “Obj” or “MI_Geometry” in your query.
Accessing Data from Oracle
To connect to an Oracle database from a MapXtreme application, the Oracle OCI connectivity client
must be installed and appropriate permissions granted. See your Oracle documentation for detailed
information.
Geometry Conversion
The table below shows the translation from MapXtreme objects to Oracle Spatial
(SDO_GEOMETRY).
From MapInfo To Oracle
NULL geometry NULL
Point 1 POINT
MultiCurve (with IsLegacyLine = true) 2 LINESTRING Geometry contains one line string
Polygon 3 POLYGON Geometry contains one polygon.
FeatureGeometryCollection 4 Collection Geometry is a heterogeneous collection of
elements.
MultiPoint 5 MULTIPOINT
MultiCurve 6 MULTILINESTRING Geometry has multiple line strings.
MultiPolygon 7 MULTIPOLYGON Geometry has multiple polygons.
Ellipse NULL
LegacyArc NULL