Loading PostGIS Spatial Data

MapInfo EasyLoader uploads MapInfo tables into PostGIS, which stores spatial data in a geometry column called sp_geometry. Unsupported data types are ignored resulting in an empty record in the sp_geometry geometry column. For a list of unsupported data types, see Unsupported Geometry.

MapInfo EasyLoader uploads a table with a Serial datatype for the primary key column. This allows the database to automatically increment the key column.

To check if a geometry object is valid in PostGIS, use the function called isvalid. The following is an example SQL statement:

select isvalid(sp_geometry) from test