Join Features (Map Viewer)

#Join Features (Map Viewer)| 来源: 网络整理| 查看: 265

The Join Features tool adds attributes from one layer or table to another based on specified spatial and attribute relationships. Optionally, statistics can be calculated for the joined features.

The output is a hosted feature layer or a hosted table layer, depending on whether the input target layer is a table.

Example

An analyst has crime data throughout their city. To analyze and study the impact of these crimes, the analyst needs to understand the relationship that the crime locations have with the various city jurisdictions such as school districts, police beats, neighborhoods, and so on. Using the Join Features tool, additional information about each location can be appended to each crime, and the impact on various jurisdictions can be further studied and analyzed.

Usage notes

Join Features includes configurations for input features, join settings, and result layer.

Input features

The Input features group includes the following parameters:

Target layer specifies the layer or table that will have records appended to it. Join layer specifies the layer or table whose records will be appended to the target layer. Join settings

The Join settings group includes the following parameters:

Use spatial relationship determines whether a spatial join is created. If Use spatial relationship is turned off, Use attribute relationship must be enabled. This option is not available if one or more of the inputs is a table layer.Spatial relationship determines how spatial features are joined to each other. The available relationships depend on the geometry type (point, line, or polygon) of the layers being joined. Spatial relationship is available when Use spatial relationship is enabled. The options are as follows:Intersects鈥擳he features in the target layer will be matched if they intersect features in the join layer.Within a distance鈥擳he features in the join layer will be matched if they are within a specified distance of features in the target layer.Identical to鈥擳he features in the target layer will be matched if they are identical to features in the join layer.Completely contains鈥擳he features will be matched if the features in the target layer completely contain features in the join layer.Completely within鈥擳he features will be matched if the features in the target layer are completely within features of the join layer.Distance determines how close features in the join layer must be to features in the target layer in order to be joined to each other. Distance is available when Within a distance is chosen for Spatial relationship.Units are the distance units that determine how close features in the join layer must be to features in the target layer in order to be joined to each other. Units is available when Within a distance is chosen for Spatial relationship.Use attribute relationship determines whether an attribute join is created. If Use attribute relationship is turned off, Use spatial relationship must be enabled. Use attribute relationship is the only option when one or more of the inputs is a table layer.Attribute relationships determines how attributes are joined to each other. Attribute relationships is available when Use attribute relationship is enabled. The following subparameters are available:Target field鈥擳he field from the target layer that will be used to create the attribute join.Join field鈥擳he field from the join layer that will be used to create the attribute join.

Target field and Join field must contain matching values to create a valid join.

Additional target fields and join fields can be added to the join by clicking the Add button.Join operation determines how joins between the target and join layers will be handled if multiple features in the join layer have the same relationship to the target layer. The options are as follows:Join one to one鈥擩oin a single record in the join layer to each feature in the target layer. This can either be the first record or a summary of all matching records, as determined by the Multiple matching records parameter. Join one to many鈥擩oin all the matching features in the join layer to the target layer. The result layer will contain multiple records of the target feature.Multiple matching records determines which records from the join layer will be used in a one-to-one join. Multiple matching records is available if Join one to one is chosen for Join operation. The options are as follows: Only keep first matching record鈥擮nly one matching record from the join layer will be used for each target feature. The matching record is determined by the Sort by parameter.Summarize matching records鈥擟alculate summary statistics for all records that match each feature in the target layer. The count of the summarized records will also be added by default.

Sort by determines how the first matching record is chosen. Sort by is available if Only keep first matching record is selected for Multiple matching records.

Sort by includes the following subparameters:Field鈥擠etermines which field from the join layer is used to choose which matching record is kept. By default, the ObjectID field is used to keep the first matching record in the dataset. If a field is selected, the values from that field will be used to select which record is kept based on the Sort order parameter. Numeric and date fields are supported.Sort order鈥擠etermines whether the field will be sorted ascending or descending when choosing the first matching record.

Field statistics determines which number fields from the join layer will be summarized. Supported summary statistics include sum, minimum, maximum, mean, and standard deviation. The statistics are calculated for each target feature. Field statistics is available if Summarize matching records is selected for Multiple matching records.

Learn more about summary statisticsJoin type determines whether the output will include only matching features, or all features from the target layer. The options are as follows:Inner join鈥擮nly matching features between the target layer and the join layer will be returned in the result layer Left join鈥擜ll features in the target layer will be returned regardless of whether they match features in the join layer

An example of one-to-one and one-to-many attribute joins using inner and left join types. In this example, the one-to-one joins include the default record, the sum of Occupants, and the maximum from Occupants.

Result layer

The Result layer group includes the following parameters:

Output name determines the name of the layer that is created and added to the map. The name must be unique. If a layer with the same name already exists in your organization, the tool will fail and you will be prompted to use a different name. Save in folder specifies the name of a folder in My Content where the result is saved. Limitations

The following limitations apply to the tool:

The option to create results as a hosted feature layer view is only available in Map Viewer Classic.Field statistics can only be calculated if a Join one to one operation is specified.Joins cannot be created using fields that have a field type of ObjectID. If the values from an ObjectID field must be used in a join, you can create an integer field and calculate the field based on the ObjectID value. Environments

Analysis environment settings are additional parameters that affect a tool's results. You can access the tool's analysis environment settings from the Environment settings parameter group.

This tool honors the following analysis environments:

Output coordinate systemProcessing extent Credits

This tool consumes credits.

Use Estimate credits to calculate the number of credits that will be required to run the tool. For more information, see Understand credits for spatial analysis.

Outputs

The tool output includes one layer containing the original records from the target layer with the matching records from the join layer appended. The geometry of the output layer is the same as the geometry of the target layer. If the target layer is a table, the output will be a table.

Licensing requirements

This tool requires the following licensing and configurations:

Creator or GIS Professional user typePublisher, Facilitator, or Administrator role, or an equivalent custom role Resources

Use the following resources to learn more:

Summary statisticsJoin Features in ArcGIS REST APIjoin_features in ArcGIS API for Python Spatial Join in ArcGIS Pro Add Join in ArcGIS ProSummary Statistics in ArcGIS Pro

Feedback on this topic?

【本文地址】

公司简介

联系我们