GeoMedia SQL Server Warehouse User Attributes

User attributes for this format are defined below.

Name

The name of the field to be written.

Type

This format supports the following field types.

Index

Data tables can be created with either primary or secondary indexes by setting the Index column. The Index column value can be set to:

  • PrimaryKey: Creates a primary index on table creation.
  • Indexed: Creates a secondary index on table creation.

Note that there can only be one primary index per table. If one is not specified, the default PRIMARYINDEX column will be created and indexed as the primary index.

Users can rename the default PRIMARYINDEX column by modifying Default Primary Index Column under Feature Type Parameters.

If any column in the Attribute Definition tab is specified as “primary” indexed, then Default Primary Index Column will be ignored. If no column is specified “primary”, and Default Primary Index Column is set to a column name specified in the Attribute Definition tab, then on table creation, that particular column will become a primary index column.

Spatial Definition

This tab contains a Spatial Definition table that provides information about the presence of spatial data, and allows you to set the geometry and spatial type on the writer.

For more information, see Spatial Definition.