UIC Attribute Rules

Setup

1. create local database from sql management studio named UIC

2. enable as enterprise gdb via pro

   import arcpy
   arcpy.management.EnableEnterpriseGeodatabase(r'...\uic-attribute-rules\pro-project\localhost.sde', r'C:\Program Files\ESRI\License10.6\sysgen\keycodes')

   If you receive errors, you may need to execute the following sql

   ALTER DATABASE UIC
   SET ALLOW_SNAPSHOT_ISOLATION ON
   
   ALTER DATABASE UIC
   SET READ_COMMITTED_SNAPSHOT ON

3. import the XML Workspace for the existing UIC database

   arcpy.management.ImportXMLWorkspaceDocument(r'...\uic-attribute-rules\pro-project\localhost.sde', r'...\uic-attribute-rules\data\UIC_STAGING.XML', 'SCHEMA_ONLY', None)

4. Create a python conda workspace for the project

   conda create --clone arcgispro-py3 --name uic

5. install the development requirements

   pip install -r requirements.dev.txt

Installation

Database Migrations

Remove feature dataset

1. Import the individual feature classes contained within the feature datasets
2. Import everything outside the feature dataset

python migrations

1. update config.py to set correct source
2. run migration code
   • python migrations.py

What happens

1. removes unused tables
2. unversions tables
3. disables editor tracking
4. adds and removes table fields
5. removes unused domains
6. moves fields from one table to another
7. creates well contingency
8. adds editor tracking
9. versions tables

Attribute Rules

1. update config.py to set correct source
2. Install attribute rules
   • python ar.py