Microsoft SQL Server Spatial

Microsoft 2008 SQL Server Spatial provides the ability to store, edit and access spatial data.

SIS supports loading data into the database whilst also allowing a multi-user environment with concurrent editing.

Microsoft SQL Server 2008 conforms to OpenGIS Simple Features Specification.

Spatial data will be stored in the GEOMETRY data type. This is a "Flat Earth" or planar data type which uses map coordinate reference system units.

SIS does not support the GEOGRAPHY data type.

This is a cursor based dataset.

Note: Microsoft SQL Server does not recognise columns with unsigned integer types. Therefore SIS creates any such columns as signed values. In addition, Decimal columns are created as NUMERIC, with a default numeric scale if both the precision and numeric scale are zero.

Arguments to Export API Method

• clsExport$
  
  SQLServerExporter

Compatibility:

• Cadcorp SIS Map Modeller
• Cadcorp SIS Map Editor
• Cadcorp SIS Map Manager
• Cadcorp SIS ActiveX Modeller
• Cadcorp SIS ActiveX Manager
• Cadcorp SIS ActiveX Viewer
• Cadcorp GeognoSIS

See full list of Export Formats

Send comments on this topic.

Click to return to www.cadcorp.com

© Copyright 2000-2017 Computer Aided Development Corporation Limited (Cadcorp).