Shared Flashcard Set

Details

ArcSDE Commands
Review for 8132 Final
39
Geography
Graduate
04/15/2012

Additional Geography Flashcards

 


 

Cards

Term
sdemon -o status -s geowww1.bcit.ca -i esri_sde ('esri_sde' OR '5151', port #)
Definition
-Checks to see if the GIOMGR process is running; you will see the SDE server status
Term
sdemon -o info -I users -s geowww1.bcit.ca -i esri_sde
Definition
-lists processes for each user (including SDECANADA) and their process IDs (PIDs)
Term
sdemon -o info -I config -s geowww1.bcit.ca -i esri_sde
Definition
-checks ArcSDE configuration info (defined when ArcSDE installed)
Term
sdelayer -o describe -u a00**** -p ****** -s geowww1.bcit.ca -i esri_sde
Definition
-lists all the layers that you have access to
Term
sdelayer -o describe_long -l sdecanada.roads,shape -u -p -s geowww1.bcit.ca -i esri_sde
Definition
-describe a single layer with more detail
Term
sdetable -o describe -t a00******.cities -u a00****** -p mvaldmanis -s geowww1.bcit.ca -i esri_sde
Definition
-describes a00******.cities table; shows table definition.
Term
sdelayer -o feature_info -l sdecanada.cities,shape -u -p -s geowww1.bcit.ca -i esri_sde
Definition
-get info about every feature in the sdecanada.cities layer
Term
sdelayer –o list –l sdecanada.lakes,shape –v 16 –u a00****** –p ***** –s geowww1.bcit.ca –i esri_sde
Definition
-lists layer data properties like envelope, # of point, also lists point data
Term
sdedbtune -o export -f DBTUNE -u a00****** -p ***** -s geowww1.bcit.ca -i esri_sde
Definition
-downloads a copy of the dbtune table. Since we do it from the dos prompt on H:, it downloads it to the H: drive
Term
sdelayer –o stats –l F7BCIT,footprint –u A00****** –p ****** –i esri_sde –s geowww1.bcit.ca
Definition
-dsiplays stats about the footprint of the F7BCIT raster
Term
-o
Definition
Operation - which operation do you want to use
Term
-s
Definition
ArcSDE server host name
Term
-i
Definition
ArcSDE service name or port number (default: esri_sde or 5151)
Term
-p
Definition
password
Term
-u
Definition
username
Term
'describe'
Definition
Lists feature class or table definitions (short form)
Term
sdemon
Definition
this command is used primarily to monitor and manage an ArcSDE service. Some of the operations used with sdemon also monitor and manage direct connections made to the ArcSDE geodatabase.
Term
l
Definition
only used with 'info' operation
Term
-l 'config'
Definition
displays configuration variable
Term
-l 'locks'
Definition
displays lock information about processes that are holding locks
Term
-l 'stats'
Definition
displays process statistics for each arcSDE client/server connection
Term
-l 'users'
Definition
Lists user's connections to the ArcSDE geodatabase, the type of connection, and associated process identifiers; each connection is one record.
Term
-l 'users_long'
Definition
Lists user's connections to the ArcSDE geodatabase, the type of connection, and associated process identifiers; information is returned in a list of properties for each connection.
Term
-l 'vars'
Definition
Displays ArcSDE service environment variables
Term
-l 'instances'
Definition
Name of the user-owned geodatabase to be queried (Oracle only)
Term
sdelayer
Definition
this command creates and administers ArcSDE layers. Requires you to enter your username and password.
Term
-l
Definition
The business table and its spatial column (ie: '-l sdecanada.cities,shape').
Term
feature_info
Definition
operation, Reports information about the feature, such as shape validity; measurements and extent information; the feature ID (FID); the presence of annotation, etc...
Term
stats:
Definition
reports feature class stats.
Term
list:
Definition
lists the fields of a feature including the point values for all points that define the shape of the feature.
-v: feature id #
Term
sdetable:
Definition
dministers business tables, the data within them, their indexes, and views. This command is used to view table definitions (rows and columns). Works for stand alone tables and for attrubutes of layers - this is known as the Business Table!!!
Term
-t
Definition
table name
Term
sdebtune
Definition
manages parameters of the DBTUNE table
'export': export the table to a txt file
Term
sdeimport
Definition
takes an existing sdeexport file and loads the data into a feature class.
Term
shp2sde
Definition
loads an ESRI shapefile into a feature class. (does not work with 64 bit Windows)
Term
cov2sde
Definition
loads a coverage, Map LIBRARIAN layer, or an ArcStorm™ layer into a feature class.
Term
tbl2sde
Definition
loads an attribute-only dBASE® or INFO™ file into a table.
Term
sdegroup
Definition
a specialty feature class creation command that combines the features of an existing feature class into single multipart features and stores them in a new feature class for background display. The generated feature class is used for rapid display of a large amount of geometry data. The attribute information is not retained, and spatial searches cannot be performed on these feature classes.
Term
sderaster
Definition
sderaster: use when manipulating rasters
Supporting users have an ad free experience!