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