VERIFIED SOLUTION i

MapInfo Pro and the Spatial object types listed in the Spatial type column of the MapInfo MapCatalog

Product Affected: MapInfo Pro™
The chart shown lists the Spatial Index Type for the integer part of the value in the SpatialType column of the MapInfo MapCatalog.  That chart (along with the list showing the object types for the values after the decimal point) describes the value represented in the Spatialtype column.
**************

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 following list describes the spatial types used in the MapInfo MapCatalog:

0 - points
1 - lines
2 - regions
3 - all
4 – text

Spatial Index TypeType Number

MapInfo MICODE schema (any database)

1

XY schema (any database)

4

Oracle Spatial Geometry

13

SpatialWare for SQL Server

14

Oracle Spatial Annotation Text

16

SQL Server Spatial (for geometry)

17

SQL Server Spatial (for geography)

18

PostGIS for PostgreSQL

19

SQL Server Spatial with M and Z values (for geometry)

20

SQL Server Spatial with M and Z values (for geography)

21

Use the XY Coordinates option when there is no index



 
UPDATED:  August 6, 2019