Geodatabase configuration

GeoAdministrator links records in the Operations and Regulations database to records in the ArcGIS Pro geodatabase. For example, an address is represented by a record in each database.

• The geodatabase stores geographic information for the address.
• The address record in the Operations and Regulations database stores legal and administrative information, and links to other records such as assets and service requests.

To link the address records in the two databases, you must add an ADDRKEY column to the GIS address table. The ADDRKEY column in the Operations and Regulations ADDRESS table stores keys that uniquely identify each address record. You can link the address records in the two databases by adding the same keys to the GIS table.

Other types of records require you to add additional columns. For example, assets can require up to seven additional columns, depending on the asset type. At a minimum, a point asset such as a manhole or a street sign requires three columns: COMPKEY, COMPTYPE, and UNITID.

The COMPKEY is the primary key, the COMPTYPE is a numeric code indicating the type of asset (such as 12 for a hydrant asset), and the UNITID is the name or identification code that the user assigns to the asset when it is created.

Other asset types, such as street segments and roadways, also require additional columns. The required columns for each type of record are listed in the tables below.