sde2cov

The sde2cov command converts feature classes in an ArcSDE geodatabase to ArcInfo coverages.

Note: This function is not supported on 64-bit Windows, Linux, or HP-Itanium.

Usage syntax

sde2cov -o create -l <table,column> [-V <version_name>]
-f <coverage,feature_class> [-P {double | single}]
[-a {none | all | file=<file_name>}] [-w <"where_clause">]
[-i {<service> | <port#> | <direct connection>}] [-s <server_name>]
[-D <database_name>] -u <DB_user_name> [-p <DB_user_password>]

sde2cov -o create -L <log_file> [-V <version_name>]
-f <coverage,feature_class> [-P {double | single}]
[-a {none | all | file=<file_name>}] [-w <"where_clause">]
[-i {<service> | <port#> | <direct connection>}] [-s <server_name>]
[-D <database_name>] -u <DB_user_name> [-p <DB_user_password>]

sde2cov -h

sde2cov -?

Operations

Operation	Description
create	Creates a new feature class in a coverage An error is returned if the feature class exists.

Options

Options	Description
-a	Attribute mode none: Do not load any attributes. all: Load all attribute columns (default). file=<file_name>: File containing lines in the form <SDE_column> [INFO_item] The first part selects the SDE column; the second part (optional) allows a new item name to be specified.
-D	Database name (not supported on Oracle)
-f	Output feature class name of coverage
-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 "-\?".
-i	ArcSDE service name, port number, or direct connection information (default: esri_sde or 5151)
-l	Input feature class table and spatial column name These must exist, and the executing user must have read access. If you are not the owner of the table, you must qualify the table name as owner.table.
-L	The name of the log file to extract from
-o	Operation
-p	DBMS user password
-P	ArcInfo coverage's precision (default: double)
-s	ArcSDE server host name (default: localhost)
-u	DBMS user name
-V	Version name; if specified, uses only the data that belongs to the version, if not specified, uses the default version (default: sde.DEFAULT)

Discussion

You must update the topology of any coverage produced by sde2cov. Run CLEAN on polygon and region coverages and BUILD or CLEAN on other feature classes. You must then run CREATELABELS on the output coverage to assign label points to each polygon. You can export annotation to new subclasses of existing coverages. You can't export annotation into an existing subclass of an existing coverage. All other feature types must be exported to new coverages.

Since the ArcSDE multipart area feature class equates to an ArcInfo coverage region feature, you must preserve the regions (and associated attribute data) in the resulting output coverage. Further reduction to composite polygon features could result in data loss and corruption.

Multipart lines with measures exported to route subclasses will produce coverages with an arc and a section at each vertex. You can reduce the number of arcs if the coverage is cleaned for lines using the CLEAN command. All section tables will remain after the CLEAN operation.

Note that annotation created with the geodatabase cannot be exported to a coverage with the sde2cov command. Use the tools provided in ArcToolbox and ArcCatalog to convert geodatabase annotation to a coverage.

Feature class to ArcSDE entity (feature) type mapping
Coverage feature class	ArcSDE entity (feature) type
point, node	point, node
line	simple line, line (sl)
polygon	area (a)
region.<subclass>	multipart area (a+)
route.<subclass>	multipart lines with measures (slM+)
anno.<subclass>	point, line, simple line, anno (pslA)

Examples

Export multipart polygons to a region coverage

sde2cov -o create -l world.cntry94,feature -f country,region.cntry -P single -a all -u world -p world

Export a subset of features with a WHERE clause

sde2cov -o create -l world.cities,feature -f big,point -w `population 10000000' -a all -u world -p world

Export polygons from a multiversioned feature class (layer)

sde2cov -o create -l world.countries,feature -f country,polygon -V version10 -P single -a all -u world -p world

Home