3D Analyst Tools ArcToolbox

Create and Migrate and Table to Relationship Class Tools

Create Relationship Class

How to Create Relationship Class Tool in Arc Toolbox ArcMap ArcGIS??

Create Relationship Class

Path to access the tool

:

Create Relationship Class Tool, Relationship Classes Toolset, Data Management Tools Toolbox

 

Create Relationship Class

This tool creates a relationship class to store an association between fields or features in the origin table and the destination table.

1.    Origin Table

The table or feature class that is associated to the destination table.

2.    Destination Table

The table that is associated to the origin table.

3.    Output Relationship Class

The relationship class that is created.

4.    Relationship Type

The type of relationship to create between the origin and destination tables.

1. SIMPLE—A relationship between independent objects (parent to parent). This is the default.
2. COMPOSITE—A relationship between dependent objects where the lifetime of one object controls the lifetime of the related object (parent to child).

5.    Forward Path Label

A name to uniquely identify the relationship when navigating from the origin table to the destination table.

6.    Backward Path label

A name to uniquely identify the relationship when navigating from the destination table to the origin table.

7.    Message Direction

The direction in which messages are passed between the origin and destination tables. For example, in a relationship between poles and transformers, when the pole is deleted, it sends a message to its related transformer objects informing them it was deleted.

1. FORWARD—Messages are passed from the origin to the destination table.
2. BACKWARD—Messages are passed from the destination to the origin table.
3. BOTH—Messages are passed from the origin to the destination table and from the destination to the origin table.
4. NONE—No messages passed. This is the default.

8.    Cardinality

Determines how many relationships exist between rows or features in the origin and rows or features in the destination table.

1. ONE_TO_ONE—Each row or feature in the origin table can be related to zero or one row or feature in the destination table. This is the default.
2. ONE_TO_MANY—Each row or feature in the origin table can be related to one or several rows or features in the destination table.
3. MANY_TO_MANY—Several fields or features in the origin table can be related to one or several rows or features in the destination table.

9.    Relationship class is attributed

Specifies if the relationship will have attributes.

1. Checked—Indicates the relationship class will have attributes.
2. Unchecked—Indicates the relationship class will not have attributes. This is the default.

10. Origin Primary Key

The field in the origin table, typically the OID field, that links it to the Origin Foreign Key field in the relationship class table.

11. Origin Foreign Key

The field in the relationship class table that links it to the Origin Primary Key field in the origin table.

12. Destination Primary Key (optional)

The field in the destination table, typically the OID field, that links it to the Destination Foreign Key field in the relationship class table.

13. Destination Foreign Key (optional)

The field in the relationship class table that links it to the Destination Primary Key field in the destination table.

Migrate Relationship Class

How to Migrate Relationship Class Tool in Arc Toolbox ArcMap ArcGIS??

Migrate Relationship Class

Path to access the tool

:

Migrate Relationship Class Tool, Relationship Classes Toolset, Data Management Tools Toolbox

 

Migrate Relationship Class

Migrates an ObjectID-based relationship class to a GlobalID-based relationship class.

1.    Input Relationship Class

ObjectID-based relationship class that will be migrated to a GlobalID-based relationship class. The origin and destination feature classes or tables must already have GlobalIDs.

Table to Relationship Class

How to Table to Relationship Class Tool in Arc Toolbox ArcMap ArcGIS??

Table to Relationship Class

Path to access the tool

:

Table to Relationship Class Tool, Relationship Classes Toolset, Data Management Tools Toolbox

 

Table to Relationship Class

Creates an attributed relationship class from the origin, destination, and relationship tables.

1.    Origin Table

The table or feature class that will be associated to the destination table.

2.    Destination Table

The table or feature class that will be associated to the origin table.

3.    Output Relationship Class

The relationship class that will be created.

4.    Relationship Type

The type of association to create between the origin and destination tables.

1. SIMPLE—An association where each object is independent of each other (a parent-to-parent relationship). This is the default.
2. COMPOSITE—An association where the lifetime of one object controls the lifetime of its related object (a parent-child relationship).

5.    Forward Path Label

A label describing the relationship as it is traversed from the origin table/feature class to the destination table/feature class.

6.    Backward Path Label

A label describing the relationship as it is traversed from the destination table/feature class to the origin table/feature class.

7.    Message Direction

The direction messages will be propagated between the objects in the relationship. For example, in a relationship between poles and transformers, when the pole is deleted, it sends a message to its related transformer objects informing them it was deleted.

1. NONE—No messages propagated. This is the default.
2. FORWARD—Messages propagated from the origin to the destination.
3. BACKWARD—Messages propagated from the destination to the origin.
4. BOTH—Messages propagated from the origin to the destination and from the destination to the origin.

8.    Cardinality

The cardinality of the relationship between the origin and destination.

1. ONE_TO_ONE—Each object of the origin table/feature class can be related to zero or one object of the destination table/feature class. This is the default.
2. ONE_TO_MANY—Each object of the origin table/feature class can be related to multiple objects in the destination table/feature class.
3. MANY_TO_MANY—Multiple objects of the origin table/feature class can be related to multiple objects in the destination table/feature class.

9.    Relationship Table

The table containing attributes that will be added to the relationship class.

10. Attribute Fields

The fields containing attribute values that will be added to the relationship class.

The Add Field button, which is used only in ModelBuilder, allows you to add expected field(s) so you can complete the dialog and continue to build your model.

11. Origin Primary Key

The field in the origin table that will be used to create the relationship. Generally, this is the object identifier field.

12. Origin Foreign Key

The name of the Foreign Key field in the relationship table that refers to the Primary Key field in the origin table/feature class.

13. Destination Primary Key

The field in the destination table that will be used to create the relationship. Generally, this is the object identifier field.

14. Destination Foreign Key

The field in the relationship table that refers to the Primary Key field in the destination table.