Working with SQL Server with SpatialWare Tables - 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

SpatialWare is a Precisely product that helps users store, access, manage, and manipulate spatial data as a standard part of their business data. You can query both spatial and non-spatial data within a single SQL Server query using SpatialWare. All of the strengths of SQL Server as a relational database are extended to spatial data using SpatialWare. Spatial data may for example be directly managed and edited by many different users simultaneously.

Cannot Upload Object

If you edit a mappable SpatialWare table and try to insert MapInfo Ellipse, Rounded Rectangle, or Arc objects into it, the following message displays:

Cannot Upload. Object format is not supported in SpatialWare (Ellipse, Rounded Rectangle, or Arc)

This is because you are trying to insert objects that are not supported. To fix the problem, delete these objects from the table or transform them to polylines or regions. To determine which objects have to be deleted or transformed, run a query in the SQL Select dialog box and specify "obj" in the Select Column clause. The resulting query will tell you the types of objects in the table. Select the objects you wish to delete or transform and display the selection in an editable layer in a Map window. To delete the objects, use the Cut command (located on the SPATIAL tab, in the Clipboard group). To transform the objects, use the Convert to Regions or Convert to Polylines commands (located on the SPATIAL tab, in the Create and Editgroups). For best results, transform ellipse and rounded rectangles into regions, and transform arcs into polylines.

If you make a SpatialWare table mappable with the Object Type default of Point and try to insert a line or region object into it, the same message Cannot Upload Object format is not supported in SpatialWare (Ellipse, Rounded Rectangle, or Arc) displays. This is because you are trying to insert objects other than a point. You need to make the table mappable with the Object type specified as ALL. To fix the problem, delete the table from the Map Catalog using MapInfo EasyLoader. Then re-add the table to the Map Catalog with an object type of ALL using the Make Table Mappable option.