SQL Server Database Table - spectrum_spatial - Latest

Spectrum Spatial Guide

Product type
Software
Portfolio
Locate
Product family
Spectrumâ„¢ software
Product
Spectrumâ„¢ software > Spatial > Spectrum Spatial
Version
Latest
ft:locale
en-US
Product name
Spectrum Technology Platform
ft:title
Spectrum Spatial Guide
Copyright
2025
First publish date
2007
ft:lastEdition
2025-03-07
ft:lastPublication
2025-03-07T10:28:48.112000

Example

This is an example of a named table definition for a SQL Server database table. It includes a column hint for the geometry.

<?xml version="1.0" encoding="UTF-8"?>
<NamedDataSourceDefinition xmlns="http://www.mapinfo.com/mxp" xmlns:gml="http://www.opengis.net/gml" version="MXP_NamedResource_1_5">
     <ConnectionSet>
           <NamedConnectionRef resourceID="/Samples/NamedConnections/mySQLServerConnection">
                <ConnectionName>Connection_1</ConnectionName>
           </NamedConnectionRef>
     </ConnectionSet>
     <DataSourceDefinitionSet>
           <DBDataSourceDefinition id="id1" volatile="true">
                <DataSourceName>WORLD</DataSourceName>
                <ConnectionMember>
                     <ConnectionName>Connection_1</ConnectionName>
                </ConnectionMember>
                <DBTable owner="scott">WORLD</DBTable>
                <DBDataSourceMetadata>
				<FeatureGeometryAttribute srsName="epsg:4326">SP_GEOMETRY</FeatureGeometryAttribute>
			</DBDataSourceMetadata>
           </DBDataSourceDefinition>
     </DataSourceDefinitionSet>
     <DataSourceRef ref="id1"/>
</NamedDataSourceDefinition>