Workspace properties (arcpy)

Summary

The Describe function returns the following properties for Workspace.

A Workspace returns a dataType of "Workspace".

Properties

PropertyExplanationData Type
connectionProperties
(Read Only)

The connectionProperties is a property set. The connection properties for an enterprise geodatabase workspace will vary depending on the type of SDE database being used. Possible properties include:

  • authentication_mode—Credential authentication mode of the connection. Either OSA or DBMS.
  • database—Database connected to.
  • historical_name—The historical marker name of the historical version connected to.
  • historical_timestamp—A date time that represents a moment timestamp in the historical version connected to.
  • is_geodatabase—String. Returns true if the database has been enabled to support a geodatabase; otherwise, it's false.
  • instance—Instance connection to.
  • server—SDE server name connected to.
  • user—Connected user.
  • version—The transaction version name of the transactional version connected to.

Only one of historical_name, historical_timestamp, or version exists for any given workspace.

Object
connectionString
(Read Only)

The connection string being used in conjunction with the SDE database type. For any other workspace type, returns an empty string.

String
currentRelease
(Read Only)

For a geodatabase workspace, returns True if the geodatabase's version is current. currentRelease can be used to assess if the geodatabase can be upgraded.

Boolean
domains
(Read Only)

A Python List containing the geodatabase domain names. To work with these domain names, you can use tools from the Domains_toolset.

String
release
(Read Only)

For a geodatabase workspace, returns the geodatabase release value. Below is the mapping of geodatabase release values to ArcGIS version numbers.

Geodatabase release value

ArcGIS version

2,2,0

9.2

2,3,0

9.3, 9.3.1

3,0,0

10.0, 10.1

String
workspaceFactoryProgID
(Read Only)

The ID is a string. You can use this to distinguish between specific workspace types with a finer granularity than you can with workspaceType. For example, workspaceFactoryProgID can distinguish between a file geodatabase and a personal geodatabase. Using workspaceType, you cannot make that distinction.

Following are workspaceFactoryProgID strings returned for the common workspace types:

  • esriDataSourcesGDB.AccessWorkspaceFactory.1Personal geodatabase
  • esriDataSourcesGDB.FileGDBWorkspaceFactory.1File geodatabase
  • esriDataSourcesGDB.InMemoryWorkspaceFactory.1in_memory workspace
  • esriDataSourcesGDB.SdeWorkspaceFactory.1SDE geodatabase
  • (empty string)Other (shapefile, coverage, CAD, VPF, and so on)
String
workspaceType
(Read Only)

The workspace type.

  • FileSystemFile-based (coverage, shapefile, and so forth) workspaces and in_memory workspaces
  • LocalDatabaseGeodatabases that are local (a file or personal geodatabase)
  • RemoteDatabaseGeodatabases that require a remote connection (ArcSDE, OLE DB, and so forth)
String

Code Sample

Workspace properties example (stand-alone script)

The following stand-alone script displays some workspace properties for an SDE database.

import arcpy

# Create a Describe object for an SDE database
#
desc = arcpy.Describe(r"C:data\Connection to state.sde")

# Print workspace properties
#
print "%-24s %s" % ("Connection String:", desc.connectionString)
print "%-24s %s" % ("WorkspaceFactoryProgID:", desc.workspaceFactoryProgID)
print "%-24s %s" % ("Workspace Type:", desc.workspaceType)

# Print Connection properties
#
cp = desc.connectionProperties
print "\nDatabase Connection Properties:"
print "%-12s %s" % ("  Server:", cp.server)
print "%-12s %s" % ("  Instance:", cp.instance)
print "%-12s %s" % ("  Database:", cp.database)
print "%-12s %s" % ("  User:", cp.user)
print "%-12s %s" % ("  Version:", cp.version)

# Print workspace domain names"
#
domains = desc.domains
print "\nDomains:"
for domain in domains:
    print "\t" + domain
6/21/2013