MapInfo Pro

I have a database view that contains SP_GEOMETRY and the following fields

When I open the "Make DBMS Table Mappable" dialogue box under Table > Database, I cannot see this DB view. 

I understand that the table or view should be registered under MAPINFO.MAPCATALOG in order to view the table/view in MapInfo. How to do this in the first place?

1. Is it ok to manually update the MAPINFO.MAPCATALOG table with the DB table or view name?
2. What are the mandatory parameters I need to update?

The following is the structure of the MAPINFO.MAPCATALOG table. Most of the parameters are unknown to me.

      ,[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]

Hi Dhan,

I use the below SQL to update, where

• the coordinate system is for MGA 2020 Zone 55
• the spatial type is one of the following:
  • 17 - point
  • 17.1 - line
  • 17.2 - region
  • 17.3 - multiple spatial types
• The "DB_" prefixed fields are the coordinate system bounds
• RENDITIONCOLUMN contains the name of the field for MapInfo styling

I can make guesses at how some of the other fields are used but can't be sure; however this will hopefully help and has worked well for me.

INSERT INTO [GISProd].[MAPINFO].[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])
     VALUES
           (17.1        -- line
           ,'property_mp'
           ,'vicmap'
           ,'SP_Geometry'
           ,-180000
           ,5560000
           ,880000
           ,6345000
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,'Earth Projection 8, 1028, "m", 147, 0, 0.9996, 500000, 10000000 Bounds (-180000,5560000) (880000,6345000)'
           ,''
           ,'NO_COLUMN'
           ,'NO_COLUMN'
           ,1
           ,'MI_STYLE'
           ,''
           ,NULL)

I have a database view that contains SP_GEOMETRY and the following fields

When I open the "Make DBMS Table Mappable" dialogue box under Table > Database, I cannot see this DB view. 

I understand that the table or view should be registered under MAPINFO.MAPCATALOG in order to view the table/view in MapInfo. How to do this in the first place?

1. Is it ok to manually update the MAPINFO.MAPCATALOG table with the DB table or view name?
2. What are the mandatory parameters I need to update?

The following is the structure of the MAPINFO.MAPCATALOG table. Most of the parameters are unknown to me.

      ,[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]

Hi James,

Thank you for the information and the detailed explanation. 

I have added the new database view (AM_PIPES_DL_VW) to the MAPINFO_MAPCATALOG, but I can't see it when I open the "Database Table" dialogue box in MapInfo Pro (2023 build 142). What could be the reason for this?

MAPINFO_MAPCATALOG table

"Database Table" dialogue box in MapInfo Pro

Hi Dhan,

I use the below SQL to update, where

• the coordinate system is for MGA 2020 Zone 55
• the spatial type is one of the following:
  • 17 - point
  • 17.1 - line
  • 17.2 - region
  • 17.3 - multiple spatial types
• The "DB_" prefixed fields are the coordinate system bounds
• RENDITIONCOLUMN contains the name of the field for MapInfo styling

I can make guesses at how some of the other fields are used but can't be sure; however this will hopefully help and has worked well for me.

INSERT INTO [GISProd].[MAPINFO].[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])
     VALUES
           (17.1        -- line
           ,'property_mp'
           ,'vicmap'
           ,'SP_Geometry'
           ,-180000
           ,5560000
           ,880000
           ,6345000
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,'Earth Projection 8, 1028, "m", 147, 0, 0.9996, 500000, 10000000 Bounds (-180000,5560000) (880000,6345000)'
           ,''
           ,'NO_COLUMN'
           ,'NO_COLUMN'
           ,1
           ,'MI_STYLE'
           ,''
           ,NULL)

I have a database view that contains SP_GEOMETRY and the following fields

When I open the "Make DBMS Table Mappable" dialogue box under Table > Database, I cannot see this DB view. 

I understand that the table or view should be registered under MAPINFO.MAPCATALOG in order to view the table/view in MapInfo. How to do this in the first place?

1. Is it ok to manually update the MAPINFO.MAPCATALOG table with the DB table or view name?
2. What are the mandatory parameters I need to update?

The following is the structure of the MAPINFO.MAPCATALOG table. Most of the parameters are unknown to me.

      ,[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]

Hi James,

Thank you for the information and the detailed explanation. 

I have added the new database view (AM_PIPES_DL_VW) to the MAPINFO_MAPCATALOG, but I can't see it when I open the "Database Table" dialogue box in MapInfo Pro (2023 build 142). What could be the reason for this?

MAPINFO_MAPCATALOG table

"Database Table" dialogue box in MapInfo Pro

Hi Dhan,

I use the below SQL to update, where

• the coordinate system is for MGA 2020 Zone 55
• the spatial type is one of the following:
  • 17 - point
  • 17.1 - line
  • 17.2 - region
  • 17.3 - multiple spatial types
• The "DB_" prefixed fields are the coordinate system bounds
• RENDITIONCOLUMN contains the name of the field for MapInfo styling

I can make guesses at how some of the other fields are used but can't be sure; however this will hopefully help and has worked well for me.

INSERT INTO [GISProd].[MAPINFO].[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])
     VALUES
           (17.1        -- line
           ,'property_mp'
           ,'vicmap'
           ,'SP_Geometry'
           ,-180000
           ,5560000
           ,880000
           ,6345000
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,'Earth Projection 8, 1028, "m", 147, 0, 0.9996, 500000, 10000000 Bounds (-180000,5560000) (880000,6345000)'
           ,''
           ,'NO_COLUMN'
           ,'NO_COLUMN'
           ,1
           ,'MI_STYLE'
           ,''
           ,NULL)

I have a database view that contains SP_GEOMETRY and the following fields

When I open the "Make DBMS Table Mappable" dialogue box under Table > Database, I cannot see this DB view. 

I understand that the table or view should be registered under MAPINFO.MAPCATALOG in order to view the table/view in MapInfo. How to do this in the first place?

1. Is it ok to manually update the MAPINFO.MAPCATALOG table with the DB table or view name?
2. What are the mandatory parameters I need to update?

The following is the structure of the MAPINFO.MAPCATALOG table. Most of the parameters are unknown to me.

      ,[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]

Hey Dhan

Is the view in the same schema as the base tables?

That certainly could explain why it doesn't show with the tables in the Open DMSB Table dialog.

Hi James,

Thank you for the information and the detailed explanation. 

I have added the new database view (AM_PIPES_DL_VW) to the MAPINFO_MAPCATALOG, but I can't see it when I open the "Database Table" dialogue box in MapInfo Pro (2023 build 142). What could be the reason for this?

MAPINFO_MAPCATALOG table

"Database Table" dialogue box in MapInfo Pro

Hi Dhan,

I use the below SQL to update, where

• the coordinate system is for MGA 2020 Zone 55
• the spatial type is one of the following:
  • 17 - point
  • 17.1 - line
  • 17.2 - region
  • 17.3 - multiple spatial types
• The "DB_" prefixed fields are the coordinate system bounds
• RENDITIONCOLUMN contains the name of the field for MapInfo styling

I can make guesses at how some of the other fields are used but can't be sure; however this will hopefully help and has worked well for me.

INSERT INTO [GISProd].[MAPINFO].[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])
     VALUES
           (17.1        -- line
           ,'property_mp'
           ,'vicmap'
           ,'SP_Geometry'
           ,-180000
           ,5560000
           ,880000
           ,6345000
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,'Earth Projection 8, 1028, "m", 147, 0, 0.9996, 500000, 10000000 Bounds (-180000,5560000) (880000,6345000)'
           ,''
           ,'NO_COLUMN'
           ,'NO_COLUMN'
           ,1
           ,'MI_STYLE'
           ,''
           ,NULL)

I have a database view that contains SP_GEOMETRY and the following fields

When I open the "Make DBMS Table Mappable" dialogue box under Table > Database, I cannot see this DB view. 

I understand that the table or view should be registered under MAPINFO.MAPCATALOG in order to view the table/view in MapInfo. How to do this in the first place?

1. Is it ok to manually update the MAPINFO.MAPCATALOG table with the DB table or view name?
2. What are the mandatory parameters I need to update?

The following is the structure of the MAPINFO.MAPCATALOG table. Most of the parameters are unknown to me.

      ,[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]

Thank you, Peter & James,

I was assuming the tables and views are displayed in alphabetical order in the "Database Table" dialogue box, but it is not.

Considering we have more than 1000 tables and views, it is nice to have a search or filtering option to select the tables or views based on their names. At least a sorting option similar to Windows Explorer.

Hey Dhan

Is the view in the same schema as the base tables?

That certainly could explain why it doesn't show with the tables in the Open DMSB Table dialog.

Hi James,

Thank you for the information and the detailed explanation. 

I have added the new database view (AM_PIPES_DL_VW) to the MAPINFO_MAPCATALOG, but I can't see it when I open the "Database Table" dialogue box in MapInfo Pro (2023 build 142). What could be the reason for this?

MAPINFO_MAPCATALOG table

"Database Table" dialogue box in MapInfo Pro

Hi Dhan,

I use the below SQL to update, where

• the coordinate system is for MGA 2020 Zone 55
• the spatial type is one of the following:
  • 17 - point
  • 17.1 - line
  • 17.2 - region
  • 17.3 - multiple spatial types
• The "DB_" prefixed fields are the coordinate system bounds
• RENDITIONCOLUMN contains the name of the field for MapInfo styling

I can make guesses at how some of the other fields are used but can't be sure; however this will hopefully help and has worked well for me.

INSERT INTO [GISProd].[MAPINFO].[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])
     VALUES
           (17.1        -- line
           ,'property_mp'
           ,'vicmap'
           ,'SP_Geometry'
           ,-180000
           ,5560000
           ,880000
           ,6345000
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,'Earth Projection 8, 1028, "m", 147, 0, 0.9996, 500000, 10000000 Bounds (-180000,5560000) (880000,6345000)'
           ,''
           ,'NO_COLUMN'
           ,'NO_COLUMN'
           ,1
           ,'MI_STYLE'
           ,''
           ,NULL)

I have a database view that contains SP_GEOMETRY and the following fields

When I open the "Make DBMS Table Mappable" dialogue box under Table > Database, I cannot see this DB view. 

I understand that the table or view should be registered under MAPINFO.MAPCATALOG in order to view the table/view in MapInfo. How to do this in the first place?

1. Is it ok to manually update the MAPINFO.MAPCATALOG table with the DB table or view name?
2. What are the mandatory parameters I need to update?

The following is the structure of the MAPINFO.MAPCATALOG table. Most of the parameters are unknown to me.

      ,[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]