Unit-1
Data Integration
Join and relate
Join and relate spatial and attribute data
There are two methods to associate data stored in table with geographic
features. They are join and relate.
Join:
- Joining is the process of appending the fields of
one table to other through an attribute common to
both tables.
- It combines two tables through key values. Values
in one or more keys are matched across tables and
the information is combined based on the matching.
- You can choose to define the join based on either
attributes or a predefined geodatabase relationship
class (also referred to as a spatial join)
Joining the attribute data from the table
One-to-one and many-to-one relationships:
-When the Join Operation parameter is set to Join one-to-one, one row in the
output feature class is linked for each target feature.
- Below is the example of one population change for one country.
Joining the attribute data from the table
One-to-one and many-to-one relationships:
- When the Join Operation parameter is set to Join many-to-one, many records
in the layer's attribute table join to the same record in the table of output
feature.
Joining the attribute data from the table
One-to-many and many-to-many relationships:
- When the Join Operation parameter is set to Join one-to-many, there can be
more than one row in the output feature class for each target feature.
Joining the attribute data from the table
One-to-many and many-to-many relationships:
- When the Join Operation parameter is set to Join many-to-many, multiple
records in a table are associated with multiple records in another table.
Joining data by location (spatially)
- Join by location, or spatial join, uses spatial associations between the
layers involved to append fields from one layer to another.
- Some of the spatial associations in ArcGIS platform includes
• Intersects
• Completely contains
• Completely within
• Within a distance of
- Spatial joins begin by selecting a target feature and comparing it spatially to
other feature layers.
https://www.youtube.com/watch?v=g9vN0QAWueQ
Joining data by Attribute
• Joining steps;
1.In the table of content right click the layer on the table you want to join, point to
the join and relate. Then click join
2.Click on what you want to join to this layer arrow and click join attributes from the
table
3.Click the field on which join will be based
4.Click the table to join the layer. If not currently part of map, click the browse
button to search for it.
5.Click the field in the table on which join will be based
6.Choose whether to keep records or only matching records
• NOTE :- If you want to permanently save joined data, export the data to new
feature class. Right click the layer or table of content, point to the data then click
export data
Relate:
An operation that establishes a temporary connection between the records in two
tables.
Eg; If you select the building, you can find all the tenants that occupy the building.
Relating steps:
1.In the table of content right click the layer or table you want to relate, point to join
and relate and
click relate
2. Choose the field in the layer on which the related will be based.
3. Choose the table or layer to relate or load table from disk
4. Choose the field in the related table on which to base the relate
5. Type the name for relate you will use to access the related data
6. Click OK. Relate is established
