Default configuration keywords specific to SQL Server
Default configuration keywords specific to SQL Server
|
| Release 9.3 |
   |
Note:This topic was updated for 9.3.1.
In addition to the default DBTUNE keywords common to all DBMSs for ArcSDE 9 and higher that were listed in the topic DBTUNE configuration keywords, there are nine SQL Server-specific configuration keyword present by default in the SDE_dbtune table. They have to do with specifying geometry storage. Each keyword contains two parameters: the GEOMETRY_STORAGE parameter to set the feature class geometry storage type, and the UI_TEXT parameter to allow the keyword to be used when creating data in ArcCatalog and other ArcObjects applications.
- WKB_GEOMETRY—When this keyword is specified at feature class creation, the storage type for the geometry column is set to the Open Geospatial Consortium, Inc.'s (OGC) well-known binary (WKB) type.
The following text shows how the keyword appears in the dbtune.sde file:
##WKB_GEOMETRY
GEOMETRY_STORAGE "OGCWKB"
UI_TEXT "User interface text"
This storage type provides a portable representation of geometry as a contiguous stream of bytes. The OGC well-known binary representation supports only simple 2D geometries.
GEOMETRY—When specified at feature class creation, this keyword sets the storage type for the geometry column to use the Microsoft Geometry type. This can only be used with SQL Server 2008 databases.
This is how the keyword appears in the dbtune.sde file:
##GEOMETRY
GEOMETRY_STORAGE "GEOMETRY"
UI_TEXT "User interface text"
The Microsoft Geometry type is a SQL-compliant spatial data type used for data that uses projected spatial reference systems.
GEOGRAPHY—When specified at feature class creation, this keyword sets the storage type for the geometry column to use the Microsoft Geography type. This can only be used with SQL Server 2008 databases.
This is how the keyword appears in the dbtune.sde file:
##GEOGRAPHY
GEOMETRY_STORAGE "GEOGRAPHY"
UI_TEXT "User interface text"
The Microsoft Geography type is a SQL-compliant spatial data type used for geodetic spatial data. See About geometry storage types for further descriptions.
As mentioned in the topic The DEFAULTS keyword, if you specify a keyword that only has a few parameters, the rest of the parameters are read from the DEFAULTS configuration keyword. Therefore, if you specify GEOMETRY when you create a feature class in a geodatabase in SQL Server, the software uses the values for the GEOMETRY_STORAGE parameter from the GEOMETRY keyword, then goes to the DEFAULTS keyword for values for all the other parameters, such as B_STORAGE.
If the GEOMETRY_STORAGE parameter under the DEFAULTS keyword in the SDE_dbtune table is set to SDEBINARY or OGCWKB and you create feature classes in your geodatabase that use GEOMETRY or GEOGRAPHY storage, you must use storage-specific keywords when you create a topology, terrain, or geometric network associated with those feature classes. The keywords are as follows:
NETWORK_GEOGRAPHYTERRAIN_GEOGRAPHYTOPOLOGY_GEOGRAPHYNETWORK_GEOMETRYTERRAIN_GEOMETRYTOPOLOGY_GEOMETRY
The first three contain a GEOMETRY_STORAGE parameter set to GEOGRAPHY, and the last three have a GEOMETRY_STORAGE parameter set to GEOMETRY.
For example, if you create a feature class, gasmains, using the GEOGRAPHY keyword, you must use the NETWORK_GEOGRAPHY keyword when you create a geometric network involving the gasmains feature class. The GEOMETRY_STORAGE parameter must be set in all parts of the composite configuration keyword. For example, for TOPOLOGY_GEOMETRY, the GEOMETRY_STORAGE parameter must be added and set to GEOMETRY under the TOPOLOGY_GEOMETRY and TOPOLOGY_GEOMETRY::DIRTYAREAS keywords.
See Composite configuration keywords for details on network, terrain, and topology keywords.
