�ݺ�ߣ

‫د�Ĭ.‫ﺳﮭٶĶ�ﻰ�Ĭ�īأﺣﻣد�Ĭ
‫وﺟود‬‫ﯾﻣﻧﻊ‬ ‫اﻟﺟداول‬ ‫ﻣن‬ ‫ﻋدد‬ ‫ﻓﻰ‬ ‫اﻟﺑﯾﺎﻧﺎت‬‫اﻟﺑﯾﺎﻧ�ﺎت‬ ‫ﻗﺎﻋ�دة‬ ‫ﻓ�ﻲ‬ ‫اﻟﻣﻌﻠوﻣ�ﺎت‬ ‫ﺗﻛرار‬‫ﻣﺧز‬ ‫ﺳ�ﺗﻛون‬ ‫اﻟﺑﯾﺎﻧ�ﺎت‬ ‫ﻷن‬‫ﻣ�رة‬ ‫ﻧ�ﺔ‬
‫ﺟدول‬ ‫ﻓﻲ‬ ‫ﻓﻘط‬ ‫واﺣدة‬‫اﻟﻔﺋ�ﺔ‬ ‫ﺣﺳ�ب‬ ‫وﺗﻘﺳ�ﯾﻣﺎﺗﮭم‬ ‫ﻟﻠﺳ�ﻛﺎن‬ ‫وﺟ�دول‬ ‫اﻟﺗﻌﻠﯾﻣﯾﺔ‬ ‫ﻟﻠﺣﺎﻟﺔ‬ ‫ﺟدول‬ ‫وﺟود‬ ‫ﻣﺛل‬ ،‫واﺣد‬‫اﻟﻌﻣرﯾ�ﺔ‬
‫وھﻛذا‬ ‫اﻟﺻﺣﯾﺔ‬ ‫ﻟﻠﺧدﻣﺎت‬ ‫اﺧر‬ ‫وﺟدول‬...
‫ﺎ‬ً‫ﻌ‬‫ﻣ‬ ‫اﻟﺟدوﻟﯾن‬ ‫رﺑط‬ ‫او‬ ‫ﺿم‬ ‫ﯾﻣﻛن‬ ،‫ﻣﺎ‬ ‫ﺟدول‬ ‫ﻓﻲ‬ ‫ﻣوﺟودة‬ ‫ﻏﯾر‬ ‫ﻣﻌﻠوﻣﺎت‬ ‫إﻟﻰ‬ ‫ﺗﺣﺗﺎج‬ ‫ﻋﻧدﻣﺎ‬ ‫ﻟذا‬.
GIS

Relate Join
‫ﺿم‬ ‫ﯾﺗم‬‫اﻟﺟدوال‬‫ﺑﯾﻧﮭﻣﺎ‬ ‫ﻣﺷﺗرك‬ ‫ﺣﻘل‬ ‫وﺟود‬ ‫أﺳﺎس‬ ‫ﻋﻠﻰ‬.‫ﯾﺗم‬‫رﺑط‬‫ﻣﺷﺗرك‬ ‫ﺣﻘل‬ ‫وﺟود‬ ‫أﺳﺎس‬ ‫ﻋﻠﻰ‬ ‫اﻟﺟدوال‬‫ﺑﯾﻧﮭﻣﺎ‬.
‫ﻧﻘوم‬‫ﺑﻌﻣل‬Join‫ﺑﯾن‬‫طﺑﻘﺔ‬‫وطﺑﻘﺔ‬‫أو‬‫طﺑﻘﺔ‬‫وﺟدول‬‫ﻋﻧدﻣ‬‫ﺎ‬
‫ﺗﻛون‬‫اﻟﻌﻼﻗﺔ‬:
•one-to-one
•many-to-one
‫ﻧﻘوم‬‫ﺑﻌﻣل‬Relate‫ﺑﯾن‬‫طﺑﻘﺔ‬‫وطﺑﻘﺔ‬‫أو‬‫طﺑﻘﺔ‬‫وﺟدول‬
‫ﻋﻧدﻣﺎ‬‫ﺗﻛون‬‫اﻟﻌﻼﻗﺔ‬:
•one-to-many
•many-to-many
‫ﻻ‬‫ﯾﮭم‬‫ان‬‫ﯾﻛون‬‫اﺳم‬‫اﻟﻌﻣود‬‫ﻣﺗطﺎﺑﻖ‬‫ﻟﻛن‬‫ﯾﺟب‬‫ان‬‫ﺗﺗطﺎ‬‫ﺑﻖ‬
‫ﻧوع‬‫اﻟﺑﯾﺎﻧﺎت‬‫ﺑﯾن‬‫اﻟﻌﻣودﯾن‬‫ﺑﻣﻌﻧﻰ‬‫ان‬‫ﯾﻛون‬‫ﻛﻼھﻣﺎ‬
String‫او‬‫ﻛﻼھﻣﺎ‬integers‫و‬‫ھﻛذا‬.
‫ﻻ‬‫ﯾﮭم‬‫ان‬‫ﯾﻛون‬‫اﺳم‬‫اﻟﻌﻣود‬‫ﻣﺗطﺎﺑﻖ‬‫ﻟﻛن‬‫ﯾﺟب‬‫ان‬‫ﺗﺗطﺎ‬‫ﺑﻖ‬
‫ﻧوع‬‫اﻟﺑﯾﺎﻧﺎت‬‫ﺑﯾن‬‫اﻟﻌﻣودﯾن‬‫ﺑﻣﻌﻧﻰ‬‫ان‬‫ﯾﻛون‬‫ﻛﻼھﻣﺎ‬
String‫او‬‫ﻛﻼھﻣﺎ‬integers‫و‬‫ھﻛذا‬.
‫ﺗرﺗﯾب‬‫اﻟﺑﯾﺎﻧﺎت‬‫ﻓﻰ‬‫اﻻﻋﻣدة‬ ‫او‬ ‫اﻟﺻﻔوف‬‫اھﻣﯾﺔ‬ ‫ﻻ‬‫ﻟﮫ‬. ‫ﺗرﺗﯾب‬‫اﻟﺑﯾﺎﻧﺎت‬‫ﻓﻰ‬‫اﻻﻋﻣدة‬ ‫او‬ ‫اﻟﺻﻔوف‬‫اھﻣﯾﺔ‬ ‫ﻻ‬‫ﻟﮫ‬.
‫اﻟطﺑﻘﺔ‬ ‫ﺟدول‬ ‫ﻓﻰ‬ ‫اﻟﺟداول‬ ‫ﺿم‬ ‫ﻧﺗﯾﺟﺔ‬ ‫ﺗظﮭر‬‫ﯾ‬ ‫واﻧﻣﺎ‬ ‫اﻟطﺑﻘﺔ‬ ‫ﺟدول‬ ‫ﻓﻰ‬ ‫اﻟﺟداول‬ ‫ﺿم‬ ‫ﻧﺗﯾﺟﺔ‬ ‫ﺗظﮭر‬ ‫ﻻ‬‫ﻣﻛن‬
‫اﻟطرق‬ ‫ﻣن‬ ‫ﺑﻣﺟﻣوﻋﺔ‬ ‫اظﮭﺎرھﺎ‬.
‫د�Ĭ.‫ﺳﮭٶĶ�ﻰ�Ĭ�īأﺣﻣد�ĬGIS

Join table
• Several tables or layers can be joined to a single table or layer
• Target table and a join table have common field names
Join attribute table
with Excel table
One-to-one
GIS ‫د�Ĭ.‫ﺳﮭٶĶ�ﻰ�Ĭ�īأﺣﻣد�Ĭ
Target table

• There is only one record for each spatial feature
Join attribute table
with attribute table
One-to-one

Source Table
Destination Table
Target Table
Master Key
Foreign Key
*‫اﻟﺗرﺗﯾب‬‫ﻻ‬‫اھﻣﯾﺔ‬‫ﻟﮫ‬‫ﻻن‬‫اﻟﻌﻣود‬‫اﻟﻣﺷﺗرك‬‫ھذا‬‫ﺗﻛون‬‫ﺟﻣﯾﻊ‬‫اﻟﻘﯾم‬‫ﺑﺔ‬‫ﻗﯾم‬‫ﻏﯾر‬‫ﻣﺗﻛررة‬"Unique
Values"‫ﻟذﻟك‬‫ﻻ‬‫ﯾﮭم‬‫اﻟﺗرﺗﯾب‬
One-to-one

GIS
One-to-one

Exercise 1
keep all records
‫ﻣﺗﻛررة‬ ‫ﻏﯾر‬ ‫ﻗﯾم‬
One-to-one

Result 1
One-to-one

Exercise 2
matching records
One-to-one

Result 2
One-to-one

Exercise 3
keep all records
One-to-one

Result 3
One-to-one

‫ﻣﺗﻛررة‬ ‫ﻗﯾم‬
Many-to-one

Source Table
Destination Table
Target Table
Master Key
Foreign Key
‫ﻣﺗﻛررة‬ ‫ﻗﯾم‬
Many-to-one

 The associated data isn't appended to the layer's attribute table like it is
with a join. Instead, you can access the related data when you work with
the layer's attributes.
Relate Table
One-to-many

Source Table
Destination Table
Target Table
Foreign KeyMaster Key
One-to-many

Relate Table
Many-to-many

�ݺ�ߣ

Join and relates in ArcGIS

More Related Content

Join and relates in ArcGIS