The Join Features tool works with two layers. Join Features joins attributes from one feature to another based on spatial, temporal, and attribute relationships or some combination of the three. The tool determines all input features that meet the specified join conditions and joins the second input layer to the first. You can optionally join all features to the matching features or summarize the matching features.
Join Features can be applied to points, lines, areas, and tables. A temporal join requires that your input data is time-enabled, and a spatial join requires that your data has a geometry.
The layer that will have attributes from the join layer appended to its table.
Analysis using the Near spatial relationship requires a projected coordinate system. You can set the Processing coordinate system in Analysis Environments. If your processing coordinate system is not set to a projected coordinate system, you will be prompted to set it when you Run Analysis .
In addition to choosing a layer from your map, you can choose Choose Analysis Layer at the bottom of the drop-down list to browse to your contents for a big data file share dataset or feature layer.
The join layer with the attributes that will be appended to the target layer.
In addition to choosing a layer from your map, you can choose Choose Analysis Layer at the bottom of the drop-down list to browse to your contents for a big data file share dataset or feature layer.
Determines how joins between the target and join layers will be handled in the output if multiple joining features are found to have the same relationship to the layer being joined. There are two join operations from which to choose:
For example, suppose you wanted to find supermarkets within 2 kilometers of a farmer's market. In this case, the target layer has a single feature representing a farmer's market, and the join layer represents the local grocery stores and has attributes such as total annual sales. Using the Join Features tool, you find that five grocery stores meet the criteria. If you specified a join operation of Join one to many, you would end up with five features in your result, each row representing the farmer's market and a supermarket. If you specified a Join one to one relationship, you would end up with one feature representing the farmer's market and the summarized information from the supermarkets, such as the count (2), and other statistics such as the sum of annual sales.
Specifies the join option used. You can apply one, two, or three of the following join types:
The spatial relationship that will determine if features are joined to each other. The following available relationships depend on the type of geometry (point, polyline, or polygon) being used as the input features:
Specifies the radius applied to a spatial near relationship.
For example, if you had a dataset representing a nuclear plant and a dataset representing residences, you could set a 1 kilometer nearSpatial distance to find houses within 1 kilometer of the nuclear plant.
The temporal relationship that will determine if features are joined to each other. This option is only available if time is enabled on both layers, and the available relationships depend on the type of time (instant or interval) used for the input features. The available temporal relationships are as follows:
Specifics the temporal radius applied to a temporal near relationship. A temporal near relationship includes Near, Near Before, and Near After.
For example, if you have a layer of boating incidents and a layer of GPS tracks for a hurricane, you could look for boating incidents within a specified distance of hurricane tracks in both space (1 kilometer) and time (5 hours). This would result in boating incidents joined to hurricanes that occurred close together in space and time.
Matches values in a field from one layer to values in a field in another layer.
For example, if you had a countywide geographic layer of residential addresses (including a ZIP field) and a tabular dataset of health demographics by ZIP Code (a field named HEALTHZIP), you could join the health dataset to the residential data by matching the ZIP field to the HEALTHZIP field. This would result in a layer of residences with the corresponding health data.
Calculates statistics on the joined features if the join operation is Join one to one. All statistics will be calculated by default.
You can calculate statistics on features that are summarized. On numeric fields, you can calculate the following:
On string fields, you can calculate the following:
All statistics are calculated on nonnull values. The resulting layer will contain a new field for each statistic calculated. Any number of statistics can be added by choosing an attribute and a statistic.
Applies a condition to specified fields. Only features with fields that meet these conditions will be joined.
For example, if you want to apply a join to a dataset for only those features where health_spending is greater than 20 percent of income, apply a join condition of $target["health_spending"] > ($join["income"] * .20)
using the field health_spending from the first dataset (the dataset features are joined to) and the income field from the second dataset (the dataset being joined).
Join conditions can be applied using the expression calculator.
GeoAnalytics results are stored to an data store and exposed as a feature layer in Portal for ArcGIS. In most cases, results should be stored to the spatiotemporal data store and this is the default. In some cases, saving results to the relational data store is a good option. The following are reasons why you may want to store results to the relational data store:
You should not use the relational data store if you expect your GeoAnalytics results to increase and need to take advantage of the spatiotemporal big data store's capabilities to handle large amounts of data.
The name of the layer that will be created. If you are writing to an ArcGIS Data Store, your results will be saved in My Content and added to the map. If you are writing to a big data file share, your results will be stored in the big data file share and added to its manifest. It will not be added to the map. The default name is based on the tool name and the input layer name. If the layer already exists, the tool will fail.
When writing to ArcGIS Data Store (relational or spatiotemporal big data store) using the Save result in drop-down box, you can specify the name of a folder in My Content where the result will be saved.