Pitney Bowes MapInfo Professional - Manual (Page 484)

Manually Creating a MapInfo_MapCatalog
To create a MAPINFO_MAPCATALOG manually:
1. If the RDBMS requires owners and users, then create the user MAPINFO with the PASSWORD
MAPINFO in the specific database where the mappable tables are located.
2. Create the table MAPINFO_MAPCATALOG in the database.
The Create Table statement must be equivalent to the following SQL Create Table statement:
Create Table MAPINFO_MAPCATALOG(
Float, SPATIALTYPE
Char(32), TABLENAME
Char(32), OWNERNAME
Char(32), SPATIALCOLUMN
Float, DB_X_LL
Float, DB_Y_LL
Float, DB_X_UR
Float, DB_Y_UR
Float, VIEW_X_LL
Float, VIEW_Y_LL
Float, VIEW_X_UR
Float, VIEW_Y_UR
Char(254), COORDINATESYSTEM
Char(254), SYMBOL
Char(32), XCOLUMNNAME
Char(32), YCOLUMNNAME
Integer, RENDITIONTYPE
VarChar(32), RENDITIONCOLUMN
VarChar(32),
Integer RENDITIONTABLE
NUMBER_ROWS
)
It is important that the structure of the table is exactly like this statement. The only substitution that
can be made is for databases that support varchar or text data types; these data types can be
substituted for the Char data type.
3. Create a unique index on the TABLENAME and the OWNERNAME, so only one table for each owner
can be made mappable.
4. Grant Select privileges to all users on the MAPINFO_MAPCATALOG. This allows users to make
tables mappable. The Update, Insert, and Delete privileges must be granted at the discretion of the
database administrator.
Spatial Index Types
The spatial index type applies to the column that has the spatial information in the DBMS table. The
spatial index provides a fast way for MapInfo Professional to access the spatial data in the table. The
index types to choose from are.
Type Number Spatial Index Type
1 MapInfo MICODE schema (any database)
4 XY schema (any database)
13 Oracle Spatial Geometry
14 SpatialWare for SQL Server
MapInfo Professional 12.5 484
Manually Creating a MapInfo_MapCatalog