Pitney Bowes MapXtreme User Manual

Page 233

Advertising
background image

Chapter 11: Accessing Data from a DBMS

Adding Rows to the MapInfo_MapCatalog

MapXtreme v7.1

240

Developer Guide

Column Name

Values to Assign

Examples

SPATIALTYPE

MapInfo Spatial Object Format

1: Point layer in X/Y columns indexed
with micode (a serialized quadtree key)
4: Point layer in X/Y columns
5

.

x: SpatialWare for Oracle

6

.

x: Ingres SQL - Not Supported

7

.

x: Sybase SQS - Not Supported

8

.

x: Oracle SDO version 2 - Not Supported

9.x: MapInfo Geocoding DataBlade
SpatialWare Point Module
10.x: MapInfo Geocoding DataBlade XY Module
11.x: SpatialWare IDS/UDO datablade
13.x: Oracle Spatial
14.x: SpatialWare for Microsoft SQL Server
17.x:SQL Server 2008 GEOMETRY without M
and Z values
18.X: SQL Server 2008 GEOGRAPHY without M
and Z values
20.x: SQL Server 2008 GEOMETRY with M and
Z values
21.x: SQL Server 2008 GEOGRAPHY with M
and Z values
Spatial Object Type

x.0: Points only
x.1: Lines only
x.2: Regions only
x.3: All types supported

L

This column describes the Spatial Object
Format of how the data is stored and
indexed and the Spatial Object type(s)
supported and not supported in the column.
The digits to the left of the decimal point are
the Spatial Object Format. The digits to the
right represent the type of Spatial Object
Type that can be stored in the column

Maps to
MapInfo.GeometryColumn.PredominantGeometry
Type, and
Has<Line/Point/Region/Text>Geometries

14.0 = SQL Server
14.1
14.2
14.3

TABLENAME

The name of the table.

STATES

Advertising