Attribute Domain Administration

When importing a dataset, GISquirrel will import any attribute domains into the SQL Server database, and will use these in editing sessions. The information defining attribute domains is stored in the "arcsquirreldomains" table, and a new look-up table is created for each coded domain imported. Once imported, these can easily be adapted by a database administrator.

The "arcsquirreldomains" table:

Field

Function

featureclassname

The name of the feature class for which the domain will be used. Matches an entry in the "arcsquirreldomains" table.

colname

The field in the feature class on which the domain will be used.

domaintype

The type of domain. Permitted values are: “CodedValue”, “Range”.

rangedomainmin

The minimum permitted value for a range domain. NULL for coded domains.

rangedomainmax

The maximum permitted value for a range domain. NULL for coded domains.

lutname

The name of the table that defines the list of acceptable values for a coded domain. NULL for range domains.

splitpolicy

Determines the behaviour during editing when a line/polygon feature is split. Permitted values are: “DefaultValue”, “Duplicate”, “GeometryRatio”.

mergepolicy

Determines the behaviour during editing when multiple line/polygon features are merged. Permitted values are: “DefaultValue”, “AreaWeighted”, “SumValues”. NB this merge behaviour is theoretical at present, as ArcMap does not enable this behaviour.

When a geodatabase feature class that uses one or more attribute domains is imported into GISquirrel, one or more records will be inserted to the "arcsquirreldomains" table as appropriate, and a new table will be created for each coded domain.

On import, the look-up tables are created with the name arcsquirrellut_<original_domain_name>. The tables are always structured as follows:

Field

Function

domainvalue

The value that will be stored in the field that uses the coded domain.

domainname

The value that will be displayed in the pick-list. This can be the same as the domainvalue, or a more verbose name.

sortorder

An integer value determining the order the values will be shown in the pick-list.

Modified 2/20/2013
Site Map | Printable View | © 2008 - 2024 Idox Software Ltd