Pitney Bowes MapMarker USA - Manual (Page 286)

Manually Creating a MapInfo Map Catalog
MapMarker USA 25
286
User Guide
Manually Creating a MapInfo Map Catalog
If you are not a MapInfo Professional or EasyLoader user, you or your database administrator will
need to create the Map Catalog manually, as described below. You only have to create the Map
Catalog once per server/database.
1. Create the user MAPINFO in the specific database where the mappable tables are located.
2. Create the table MAPINFO_MAPCATALOG in the database.
The Create Table statement needs to be equivalent to the following SQL Create Table statement:
Create Table MAPINFO_MAPCATALOG (
SPATIALTYPE Float,
TABLENAME Char(32),
OWNERNAME Char(32),
SPATIALCOLUMN Char(32),
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 Float,
COORDINATESYSTEM Char(254),
SYMBOL Char(254),
XCOLUMNNAME Char(32),
YCOLUMNNAME Char(32),
RENDITIONTYPE INTEGER,
RENDITIONCOLUMN CHAR(32),
RENDITIONTABLE CHAR(32)
NUMBER_ROWS INTEGER
)
L
It is important that the structure of the table looks 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.
create unique index mapcat_i1
on mapinfo.mapinfo_catalog (OwnerName,TableName)
4. Grant Select, Update, Insert, and Delete privileges on the MAPINFO_MAPCATALOG. This
allows users to make tables mappable. The delete privilege should be reserved for database
administrators.
grant select, insert, update, delete on
mapinfo.mapinfo_mapcatalog to public