The Fields tab contains a grid that allows you to link the feature class layer fields to fields in the lucity module.
Note: GIS Fields that link to a Lucity Picklist field can only link to the Code portion of the Lucity Picklist field.
Note: Never link Esri's Shape.Length field to the Lucity length field.
Fields
Column Purposes
FieldName:
The field name in the Lucity table.
DisplayName:
The field caption in Lucity.
Field Type:
The type of data stored in the field.
MaxMask:
The data format. A numeric value followed by an "x" indicates the number of characters allowed. n indicates a numerical digit.
Feature Class Field Name:
This is the name of the field in the feature class. This is NOT the alias field name.
Field Lookup:
This button column displays a list of the feature class fields. Note: If a connection to the geodatabase was unsuccessful then no fields will be listed.
Lookup Lucity ID
This column only works for feature class layers linked to Lucity Inspection modules and only appears next to the field that links to a Record #. The feature class must have contain an ID for the Lucity Asset the inspection is for. If the ID stored in the feature class is the asset's Rec # link that field to the Rec # field and leave this box unchecked. If the ID stored in the feature class is the the asset's common ID then link the field to the common ID and check the Lookup Lucity ID field next to the Rec #. This is done because in this case Lucity needs to know the record number. This looks up the record number based on the common id.
Color Coding
Red - Required field
Orange - Stores the required ID numbers of related features.
Yellow - Stores the optional ID numbers of related features.
Green - Composite address field.
Pink - Strongly recommended field. Typically this is the Lucity auto ID field. Although, technically this field isn’t required it is strongly recommended that the feature class contain a field that stores the Lucity autoID. Not having this field will impact the performance of some of the Lucity GIS tools as additional resources will be used to determine the AutoID value based upon the common ID.
Date Fields
Lucity Date and Time fields can link to GIS Composite Date/Time fields. The difference between the two is that Lucity stores the Date in one field and the Time in another and the GIS Composite fields store the Date and Time in one field. To link a Composite Date/Time field to Lucity link that field to both the Lucity Date and Time fields.
Address fields are made up of multiple components and can be linked using 2 different configurations
Components
Lucity breaks out street address information into the following fields.
Building Number - The address
Building Number 2 - Extended information about the address (1/2, A, etc...)
Street Direction
Street Prefix
Street Name
Street Suffix
Street Type
Multiple field configuration
In this configuration the feature class has all of the different building number and street name fields broken out. This is configured by linking each field in the feature class to each field in Lucity
Building Configuration
Street Name Configuration
Single Field configuration
In this configuration the feature class has the building number fields combined and the street name fields combined. This is configured by linking the field in the feature class to the special composite field in the geodatabase configuration
Building Configuration
Street Name Configuration
Combined Configurations
These configurations can be used together but both configurations for the same component cannot be used together.
Examples that work
Single Field Building Configuration + Single Field Street Name Configuration
Single Field Building Configuration + Multiple Field Street Name Configuration
Multiple Field Building Configuration + Single Field Street Name Configuration
Multiple Field Building Configuration + Multiple Field Street Name Configuration
Examples that don't work
Multiple Field Street Name Configuration + Single Field Street Name Configuration
Single Field Building Configuration + Multiple Field Building Configuration
How to Link a feature class field to a Lucity field.
Decide which field should be linked.
Look at the field in Lucity. Either get the field display name or CTRL + Right -click and look at field properties for the field name.
In the GIS Config select the feature class linked to the correct module
Search through the grid on the right for the Lucity field using the field name or display name.
Enter the name of the feature class layer in the Feature Class Field Name field OR push the Field Lookup button for a list of fields from the associated feature class.
Address Fields
