Configuration Parameters

This defines the name of the spatial column within the table being defined. The spatial column is the column that contains the geometry of the feature.

The following example gives the spatial column a name of SHAPE.
  SDE_LAYER SHAPE

It is recommended that SHAPE be used as the name.

This optional field specifies the coordinate system of the spatial column. This is only used during the initial creation of a spatial column. The value is an integer value that corresponds to one of the predefined coordinate systems specified in ESRI’s Projection Engine documentation which is shipped with every SDE 30.

Either SDE_COORD_SYS_ID or SDE_COORD_SYS_DESCRIPTION can be specified, but not both.

If it is not specified, then the coordinate system will taken from the first feature written to each table.

This is specified as part of a spatial column definition. It gives the size of the spatial index in the coordinate system of the layer (vector spatial column).

Setting SDE_GRID{0} to certain special values can influence what grid type is created for a given DBMS, which can affect performance. For more information, see the Esri (Legacy) ArcSDE documentation (http://edndoc.esri.com/arcsde/9.3/api/capi/schemaobjects/layers/layerinfoSetGridSizes.htm).

After the translation, the “Calculate Default Spatial Grid Index” tool (from ArcToolbox > Data Management Tools > Feature Class) can be used to calculate a valid spatial index.

The following example defines the grid size of 200:

  SDE_GRID{0} 200

This optional parameter defines the level 3 grid element size. This level grid is rarely required. If specified, this must be at least 3 times the SDE_GRID{1}.

If it is not desired, then either the value should not be specified or it should be given a value of 0.

The following example defines a grid size of 4000 for the level 2 grid:
  SDE_GRID{2} 4000

The list of field names that are used by the SDE Writer when it is operating in UPDATE mode. If the table is either registered as multi-versioned or contains a spatial column, then this configuration parameter is optional. In general, this should identify a unique feature but can also be used to update multiple features if desired.

The following example sets the update fields to be country and capital:
  SDE_UPDATE_FIELDS COUNTRY,CAPITAL

The minimum y value of the spatial column being defined. No coordinate values can be less than the value specified here.

This parameter corresponds to the Min Y property of the Feature Class’s domain in ArcGIS.

For raster catalogs, this value should be calculated from the lower left corner of the lower-leftmost raster to be added to the catalog. If the value is unspecified, the footprint column will not be created; however, the footprint column will automatically be created when the table is registered with Geodatabase.

The example below defines the lower extent of a spatial column to be -90:
  SDE_YORIGIN -90

The minimum z value stored within the spatial column.

This parameter corresponds to the Min Z property of the Feature Class’s domain in ArcGIS.

The example below defines the minimum z value to be 0:
  SDE_ZORIGIN 0

The minimum measure value that is stored within the spatial column.

The example below defines the minimum measure value to be 0:
  SDE_MEASURED_ORIGIN 0

The description of the spatial column, which is just free text.
  SDE_DESCRIPTION RoadWork

The SDE configuration keyword specifies the storage parameters for the layer (vector spatial column) or raster column.

If not specified, the keyword DEFAULTS will be used.

For more information, search parameter name-configuration string pairs in Esri ArcGIS Server help files.

The example below uses a configuration keyword of TEST:
  SDE_CONFIG_KEYWORD TEST

Y – The spatial column allows annotation to be specified.

N – The spatial column does not allow annotations.

Y – The spatial column allows linear features to be stored. Line features are those linear features that may touch or cross over themselves.

N – The spatial column does not allow linear features to be stored.

Y – The spatial column allows simple lines to be stored. Simple lines are lines that do not touch or cross over themselves.

N – The spatial column does not allow simple lines.

Y – The spatial column allows features that have multiple parts. Multi-part features must be homogeneous. That is, all parts must be either area, linear, or point within a single feature.

N – The spatial column does not allow features which have multiple parts.

SDE_BINARY – the feature geometry for the layer (vector spatial column) is stored in SDE binary mode.

WKB – the feature geometry for the layer is stored in SDE using the OGC Well Known Binary form. ArcSDE 8.x only.

SQL – Stored as SQL or well known text format. ArcSDE 8.x only.

NORMALIZED – Normalized format (used for Oracle Spatial Only). ArcSDE8.x only.

Specifies that the SDE writer truncate the table before writing. For raster tables, the associated raster column and band information tables will be truncated as well. If the table does not exist, it will be created when the data is written.

The following example sets the truncate table flag to false.

Note: This parameter is valid only if the feature reaches the writer.

  SDE_TRUNCATE_TABLE NO

Default: NO

Values: YES |NO

The cluster tolerance of the measured values in the spatial column. This value represents an extremely small distance used to resolve inexact intersection locations of coordinates during clustering operations.

The measured tolerance is the minimum distance allowed between M values before they are considered equal. It is used in clustering operations such as topology validation, buffer generation, polygon overlay and for some editing operations. If a tolerance value is not specified, a default value will be used based on a conversion of 0.001 meters in the unit of the source coordinate system.

The example below defines the measured tolerance to be 0.001:
  SDE_MEASURED_TOLERANCE 0.001

This defines the name of the raster column within the table being defined. The raster column is the column that defines the geometry of the table as raster and contains the geometry of the features in the table. If a table definition has both a spatial and a raster column, the spatial column will be ignored.

The following example gives the raster column a name of RASTER.
  SDE_RASTER RASTER

It is recommended that RASTER be used as the name.

This defines the interpolation type of pyramid creation for the table being defined.

The following example gives the raster column a pyramid interpolation type NEAREST_NEIGHBOR.
  SDE_PYRAMID_INTERPOLATION NEAREST_NEIGHBOR

Default: NONE

Values: NONE | NEAREST_NEIGHBOR | BILINEAR | BICUBIC

Note: A value of NONE disables pyramid creation and disregards the other pyramid settings.Also note that nearest neighbor is the only valid pyramid setting for classified raster data.

This defines the maximum pyramid level to be created for the table being defined.

The following example gives the raster column sets a maximum pyramid level to be automatically calculated.
  SDE_PYRAMID_MAX_LEVEL AUTO

Note: This setting is only used if the pyramid level type is set to the value CUSTOM.

Specifies the mosaic mode that will be used when mosaicking data to an SDE rastermap. The default is MERGE. A value of NONE means that new data will completely replace existing raster data, and no mosaic is applied. MERGE causes the data to be mosaicked, replacing existing pixel values with new pixel values where they overlap, and leaving all other data untouched. The NoData values in the existing raster are not altered. DELETE mode does not mosaic any new data, but rather has the sole purpose of deleting data in the existing raster. This is accomplished by deleting pixel data where the new raster overlaps the existing raster and the value for that pixel location in the new raster is nodata. MERGE and DELETE modes are ignored on insert, and are only valid for a mosaic operation.

The following example sets the mosaic mode to merge.

  SDE_RASTER_MOSAIC_MODE MERGE

Default: MERGE

Values: NONE | MERGE | DELETE