Manually Making a Remote Table Mappable - MapInfo_Pro - 2023

MapInfo Pro Help
Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
Version
2023
ft:locale
en-US
Product name
MapInfo Pro
ft:title
MapInfo Pro Help
First publish date
1985
ft:lastEdition
2023-09-12
ft:lastPublication
2023-09-12T16:39:16.995000

For each spatial table in the remote database that you want to access in MapInfo Pro, you must add a row to the MAPINFO_MAPCATALOG table. This is carried out in MapInfo Pro when on the TABLE tab, in the Maintenance group, you click Maintenance, and Make DBMS Table Mappable.

If you do not use MapInfo Pro to manage the Map Catalog, you must manually add rows to the MAPINFO_MAPCATALOG table for each spatial table in the database that you want to geocode. Each entry must contain the following information about the table.

Column Name Values to Assign Example

SPATIALTYPE

SPATIALTYPE values are constructed from the spatial index type from this table and the value that represents the table contents as described here:

  • 0 - points only
  • 1 – lines
  • 2 - regions
  • 3 - all geometries
  • 4 – text
 
4.2

TABLENAME

Name of the table.

 
Drainage

OWNERNAME

Owner name.

 
Georgetown

SPATIALCOLUMN

Name of the column, if any containing spatial features. The name is:

  • NO_COLUMN (for mappable tables using X,Y)
 
NO_COLUMN

DB_X_LL

X coordinate of the lower left corner of the layer's bounding rectangle, in units indicated by the COORDINATESYSTEM as defined by MapInfo Pro.

 
-360

DB_Y_LL

Lower left bounding Y value.

 
-90

DB_X_UR

Upper right bounding X value.

 
360

DB_Y_UR

Upper right bounding Y value.

 
90

VIEW_X_LL

X coordinate of the lower left corner of the view's bounding rectangle, in units indicated by the COORDINATESYSTEM as defined by MapInfo Pro.

 
-360

VIEW_Y_LL

Lower left bounding Y value.

 
-90

VIEW_X_UR

Upper right bounding X value.

 
360

VIEW_Y_UR

Upper right bounding Y value.

 
90

COORDINATESYSTEM

A string representing a MapInfo-supported coordinate system that specifies a map projection, coordinate units, etc.

For Example: 
Earth Projection 1,33 (for NAD 83) or
 
Earth 
Projection 1,0

SYMBOL

A MapInfo Symbol clause (for a layer containing points)

 
Symbol 
(35,0,12)

XCOLUMNNAME

Specify the name of the column containing X coordinates. 

NO_COLUMN

YCOLUMNNAME

Specify the name of the column containing Y coordinates. 

NO_COLUMN

RENDITIONTYPE

Specify 1 if on, 0 if off.

 
1

RENDITIONCOLUMN

Specify the name of the rendition column.

 
MI_STYLE

RENDITIONTABLE

Specify the name of the rendition table.

This field is not used.

 
left empty

NUMBER_ROWS

Specify the number of rows in the table.

 
11