Special Fields

When a dataset is imported into GISquirrel using the Import Layer tool, some extra fields are added to the table that were not present in the original. This section explains what these fields are for and whether they are mandatory or optional.

If you are using GISquirrel to connect to tables that you have created without using the Import Layer tool, please read this section to make sure your table structure meets the GISquirrel requirements.

Identity field (auto-numbering integer primary key field)

REQUIRED for all editable feature classes. A feature class without an identity field will not be editable. The field can have any name.

Geometry field

REQUIRED for all feature classes. The field can have any name, and must be of "geometry" data type.

asq_lasteditedby

OPTIONAL. If present in the table underlying an editable feature class, this field is populated with the login name of the last user to edit the feature in a GISquirrel editing session.

asq_lasteditedwhen

OPTIONAL. If present in the table underlying an editable feature class, this field is populated with the date/time the feature was last edited in a GISquirrel editing session.

asq_lockedby

OPTIONAL but RECOMMENDED. If present in the table underlying an editable feature class, this field is used to lock features while they are being edited by one user in a GISquirrel editing session. The field is populated with the login name of the editing user, and cleared when that user saves edits. If this field is absent, it will be possible for multiple users to edit the same feature simultaneously, and the last save will overwrite previous edits.

shapelength

OPTIONAL but RECOMMENDED for line and polygon feature classes. This field is automatically updated with the feature length for lines, or the perimeter for polygons, whenever the feature is edited in a GISquirrel editing session.

shapearea

OPTIONAL but RECOMMENDED for polygon feature classes. This field is automatically updated with the feature area whenever the feature is edited in a GISquirrel editing session.