sdexinfo

The sdexinfo command describes an ArcSDE export file.

Usage syntax

sdexinfo [-o describe] -f <{export_file | -}>

sdexinfo -o list -f <{export_file | -}> [-s] [-a]

sdexinfo -o stats -f <{export_file | -}>

sdexinfo -h

sdexinfo -?

Operations

Operation	Description
describe	Lists the export file header and attribute column definitions (the default)
list	Performs the stats operation and lists partial or complete feature and attribute data values
stats	Performs the describe operation and lists statistical information

Options

Options	Description
-a	Lists the attribute data values
-f	ArcSDE export file name; if "-", read from standard input
-h or -?	Use either of these options to see the usage and options for the command. Note: If using a C shell, use -h or "-\?".
-o	Operation
-s	Displays a detailed shape feature definition Displays all fields of the feature definition including the point values

Discussion

The sdexinfo command allows you to obtain information about an ArcSDE export file.

Examples

Each of the operations performed with the sdexinfo command provides a description of the export file.

Describe the export file

Use the describe operation to get a list of the header and column definitions.

sdexinfo -o describe -f c:\GISData\xfaults
-----------------------------------------------------------------------
SDEX File:                  c:\GISData\xfaults
Version:                    SDEX 9.0.0.2
Type:                       Final
Volume Type:                Single
Layer ID:                   3
Description:
Database Name:              SDE
Table Owner:                RJP
Table Name:                 ORFAULTS
Spatial Column Name:        SHAPE
Minimum Shape ID:           1
Grid Size 0, 1, 2:          6790.25,       0,       0
Entity Type:                nslc+
I/O Mode:                   Normal
Layer Config. Keyword:      DEFAULTS
Layer Precision:            64-bit
User Privileges:            SELECT, UPDATE, INSERT, DELETE
Creation Date:              08/08/05 07:19:43
Layer Envelope:
minx: 480039.87500, miny: 5454508.50000
maxx: 856992.56300, maxy: 5937025.00000
XY False Origin:            479999.999, 3759999.99
XY System Units:            1000.0
XY Half SysUnit:            0.5
XY Round:                   1.0
Z Offset:                   0.0
Z Units:                    1.0
Z Half SysUnit:             0.5
Z Round:                    1.0
Measure Offset:             0.0
Measure Units:              1.0
Measure Half SysUnit:       0.5
Measure Round:              1.0
Spatial Referencd ID:       3
Coordinate System:          UNKNOWN

SDE Attribute Columns: 9
Name             Type         Width       numDecimal         Null?         RowID
---------------------------------------------------------------------------------
OBJECTID       SE_INT32        10             0             NOT NULL        SDE
FNODE_         SE_FLOAT64      11             0
TNODE_         SE_FLOAT64      11             0
LPOLY_         SE_FLOAT64      11             0
RPOLY_         SE_FLOAT64      11             0
LENGTH         SE_FLOAT64      15             3
ORFAULT_       SE_FLOAT64      11             0
ORFAULT_ID     SE_FLOAT64      11             0
SHAPE          SE_SHAPE         0             0

---------------------------------------------------------------------------------

List feature and attribute values

The list operation returns the description list, statistics, and feature and attribute data values. The feature and attribute value list will be detailed if you use the -s option. Otherwise, it returns the same information as the stats operation.

sdexinfo -o list -f c:\GISData\xfaults -s

Note: This list can be quite long.

Obtain statistics on the export file

Use the stats operation to get statistical information on the export file in addition to a description list.

sdexinfo -o stats -f c:\GISData\xfaults

Returns the same description as in the last example but with added information:

Spatial Column Statistics:

Total Linear Features:              18239
                                ------------------------------
Total Features:                     18239

Minimum Feature Number:                 1
Maximum Feature Number:             18239
Largest Feature:                       30 Points
Smallest Feature:                       2 Points
Average Feature:                        3.56 Points
Minimum Line String Length:             2.756804
Maximum Line String Length:         22454.355594
Average Line String Length:          1404.028506
Layer Envelope:
                     minx:480039.87500, miny:5454508.50000
                     maxx:856992.56300, maxy:5937025.00000
--------------------------------------------------------------

Home