Manually Creating a MapInfo_MapCatalog - MapInfo_Pro - 2023

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( SPATIALTYPE TABLENAME OWNERNAME SPATIALCOLUMN DB_X_LL DB_Y_LL DB_X_UR DB_Y_UR VIEW_X_LL VIEW_Y_LL VIEW_X_UR VIEW_Y_UR COORDINATESYSTEM SYMBOL XCOLUMNNAME YCOLUMNNAME RENDITIONTYPE RENDITIONCOLUMN RENDITIONTABLE NUMBER_ROWS Float, Char(32), Char(32), Char(32), Float, Float, Float, Float, Float, Float, Float, Float, Char(254), Char(254), Char(32), Char(32), Integer, VarChar(32), VarChar(32), Integer )

   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 Pro to access the spatial data in the table. The index types to choose from are.

You use the XY Coordinates option when there is no index