The Lucity-to-geodatabase integration allows edits made in LucityInventory modules to be pushed to the geodatabase. This is a recommended configuration for all agencies as it is required for many Lucity tools to work properly. It can be configured so that edits are not passed to the geodatabase.
Note: An agency that uses GIS must complete this configuration if it wants to allow Lucity to update the geodatabase.
Process
Inventory Edits
Edits made in the Lucity interface are pushed directly into the Lucity database.
During the push, the program checks the Lucity settings to determine which feature service it should use to connect to the geodatabase.
Setup
There are two ways to set up this integration: 1) using a feature service, or 2) using a map service. The suggested method uses a feature service as this is based on ESRI's newer more robust technology.
Complete one of the following configuration processes to establish a default link between Lucity and the geodatabase.
Feature Service
A feature service is usually the primary link between Lucity and the geodatabase. Feature services are map services published through ArcServer that have feature access capabilities enabled. An administrator adds a feature service to the Lucity connection string using the Lucity Administration Tool, which is locatedunder GIS > Connection Strings.
If collecting information for the map service that contains your operational data, click on the REST URL. A page containing the properties of the map service appears.
Scroll down and copy down theSpatial ReferenceNumber. (Do this only for the layer that contains Lucity data.)
Launch the Lucity Administration Tool and select GIS > GIS Services.
On the Map Services tab click the Add Map Service button.
Enter a Name and the REST URL of the map service.
Note: This URL should end in /MapServer.
Check the Has Feature Service? box. This tells the map that the layer has an attached Feature Service.
Fill out other fields as necessary.
Click the Save button.
Note: If you are modifying an existing map service to have editing capabilities you just need to mark Has Feature Service? box for the existing record in the Map Service setup.
Close the GIS Services tool
Point Lucity to the feature service.
Open Lucity Administration Tool > GIS > Connection Strings.
Find the connection string that links to the same data that the feature service does.
Use the Editable Map Service dropdown, select the map service that you added to the map services grid.
Relevant Settings
Settings that affect this integration are found in Lucity Web, under Admin Portal > Settings > System Settings > GIS Edit Integration section.
Optional Setup
Alternate Feature Services
While the integration instructions outlined above create a default link between Lucity and the geodatabase, an agency can also set up alternate links between Lucity and the geodatabase. Doing so allows an agency to divide its feature classes into different feature services.
Using alternate feature services is not necessary; however, feature services are also used to establish edit capabilities in the Webmap and other web-editing platforms. Feature services used for Webmap editing are typically small and contain feature classes from only one set of GIS data (e.g., Storm features). Therefore, multiple editing feature services are required for different types of data.
In such a situation, an agency can reuse its editing feature services as alternate feature services within the geodatabase configuration.
Create the feature service using ArcMap. Keep in mind:
The map service must contain the feature classes that you want it to update in the geodatabase.
The feature classes must display all of the fields that are configured to link to Lucity.
The map service does not need any additional non-Lucity feature classes.
You can either use a new map service, or an existing one.
The map service does not require any special symbology.
The user account used to add the data to the map service must have edit permissions for the feature classes that Lucity will update in the geodatabase.
The map service must point to the version of the geodatabase that Lucity should update.
If collecting information for the map service that contains your operational data, click on the REST URL. A page containing the properties of the map service appears.
Scroll down and copy down theSpatial ReferenceNumber. (Do this only for the layer that contains Lucity data.)
Launch the Lucity Administration Tool and select GIS > GIS Services.
On the Map Services tab click the Add Map Service button.
Enter a Name and the REST URL of the map service.
Note: This URL should end in /MapServer.
Check the Has Feature Service? box. This tells the map that the layer has an attached Feature Service.
Fill out other fields as necessary.
Click the Save button.
Note: If you are modifying an existing map service to have editing capabilities you just need to mark Has Feature Service? box for the existing record in the Map Service setup.
Close the GIS Services tool
Configure the feature class(es) to use an alternative feature service.
Single Feature Class/Single Alternative Feature Service: