Locate the AdvisoryLocks_initialize.sql located in the C:\Program Files\Bentley\Communications CONNECT Edition\OpenCommsDesigner\ Database\Spatial\Asneeded folder. This SQL script must be edited to set the proper XY coordinate extents for the geospatial project. Verify the existing extents from the MDSYS user tables (SDO_GEOM_METADATA) to obtain the correct values for the project:

The default script values in bold below will need to be edited:

MDSYS.SDO_DIM_ELEMENT('X', 100000, 7000000, 5E-8),

MDSYS.SDO_DIM_ELEMENT('Y', 100000, 7000000, 5E-8)

The symbology for the boundary features can also be customized from the default values given in the script if desired.

After editing the symbology and extents values, run the AdvisoryLocks_initialize.sql script.