Display Name: Spatial Join

Description: Geoprocessing tool used to join the attributes of two feature classes based on the spatial relationships between the features in the two feature classes and to write the join an output.

Category:

Help URL: https://egis.tbc.sa/server/rest/directories/arcgisoutput/SpatialJoin2_GPServer/SpatialJoin2/SpatialJoin.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: target_features

Data Type: GPFeatureRecordSetLayer
Display Name Target Features
Description: Attributes of the target features and the attributes from the joined features are transferred to the output feature class. However, a subset of attributes can be defined in the field map parameter.
Direction: esriGPParameterDirectionInput
Default Value:
Geometry Type: esriGeometryPolygon
HasZ: false
HasM: false
Spatial Reference: 4326  (4326)

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• REGION_ID ( type: esriFieldTypeSmallInteger, alias: REGION_ID )
• ANAME ( type: esriFieldTypeString, alias: ANAME, length: 50 )
• ENAME ( type: esriFieldTypeString, alias: ENAME, length: 50 )
• Test_ID ( type: esriFieldTypeSmallInteger, alias: iest_id )
• SHAPE_Length ( type: esriFieldTypeDouble, alias: SHAPE_Length )
• SHAPE_Area ( type: esriFieldTypeDouble, alias: SHAPE_Area )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: join_features

Data Type: GPFeatureRecordSetLayer
Display Name Join Features
Description: The attributes from the join features are joined to the attributes of the target features. See the explanation of the Join Operation parameter for details on how the aggregation of joined attributes are affected by the type of join operation.
Direction: esriGPParameterDirectionInput
Default Value:
Geometry Type: esriGeometryPoint
HasZ: false
HasM: false
Spatial Reference: 102100  (3857)

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• city_id ( type: esriFieldTypeDouble, alias: كود المدينة )
• aname ( type: esriFieldTypeString, alias: اسم المدينة بالعربي, length: 100 )
• ename ( type: esriFieldTypeString, alias: اسم المدينة بالانجليزي, length: 100 )
• region_a ( type: esriFieldTypeInteger, alias: اسم المنطقة الادارية بالعربي )
• region_e ( type: esriFieldTypeInteger, alias: اسم المنطقة الادارية بالانجليزي )
• governorate_a ( type: esriFieldTypeString, alias: اسم المحافظة الادارية بالعربي, length: 100 )
• governorate_e ( type: esriFieldTypeString, alias: اسم المحافظة الادارية بالانجليزي, length: 100 )
• moi_class_a ( type: esriFieldTypeInteger, alias: تصنيف وزارة الداخلية بالعربي )
• moi_class_e ( type: esriFieldTypeInteger, alias: تصنيف وزارة الداخلية بالانجليزي )
• saudi_male ( type: esriFieldTypeDouble, alias: اجمالي السكان السعوديين ذكور )
• saudi_fmale ( type: esriFieldTypeDouble, alias: اجمالي السكان السعوديين اناث )
• saudi_total ( type: esriFieldTypeDouble, alias: اجمالي السكان السعوديين )
• nonsaudi_male ( type: esriFieldTypeDouble, alias: اجمالي السكان غير السعوديين ذكور )
• nonsaudi_fmale ( type: esriFieldTypeDouble, alias: اجمالي السكان غير السعوديين اناث )
• nonsaudi_total ( type: esriFieldTypeDouble, alias: اجمالي السكان غير السعوديين )
• male_total ( type: esriFieldTypeDouble, alias: اجمالي الذكور )
• fmale_total ( type: esriFieldTypeDouble, alias: اجمالي الاناث )
• total_popul ( type: esriFieldTypeDouble, alias: اجمالي السكان )
• housing ( type: esriFieldTypeDouble, alias: اجمالي المساكن )
• popul_date ( type: esriFieldTypeDouble, alias: تاريخ التعداد )
• x_coordinates ( type: esriFieldTypeDouble, alias: الاحداثي السيني )
• y_coordinates ( type: esriFieldTypeDouble, alias: الاحداثي الصادي )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• govern_id ( type: esriFieldTypeInteger, alias: كود المحافظة الادارية )
• momra_classification ( type: esriFieldTypeInteger, alias: تصنيف الشئون البلدية والقروية )
• old ( type: esriFieldTypeInteger, alias: old )
• em ( type: esriFieldTypeInteger, alias: em )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: out_feature_class

Data Type: GPFeatureRecordSetLayer
Display Name Output Feature Class
Description: A new feature class containing the attributes of the target and join features. By default, all attributes of target features and the attributes of the joined features are written to the output. However, the set of attributes to be transferred can be controlled by the field map parameter.
Direction: esriGPParameterDirectionOutput
Default Value:
Geometry Type: esriGeometryPolygon
HasZ: false
HasM: false
Spatial Reference: 4326  (4326)

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Join_Count ( type: esriFieldTypeInteger, alias: Join_Count )
• TARGET_FID ( type: esriFieldTypeInteger, alias: TARGET_FID )
• REGION_ID ( type: esriFieldTypeSmallInteger, alias: REGION_ID )
• ANAME ( type: esriFieldTypeString, alias: ANAME, length: 50 )
• ENAME ( type: esriFieldTypeString, alias: ENAME, length: 50 )
• Test_ID ( type: esriFieldTypeSmallInteger, alias: iest_id )
• city_id ( type: esriFieldTypeDouble, alias: كود المدينة )
• aname_1 ( type: esriFieldTypeString, alias: اسم المدينة بالعربي, length: 100 )
• ename_1 ( type: esriFieldTypeString, alias: اسم المدينة بالانجليزي, length: 100 )
• region_a ( type: esriFieldTypeInteger, alias: اسم المنطقة الادارية بالعربي )
• region_e ( type: esriFieldTypeInteger, alias: اسم المنطقة الادارية بالانجليزي )
• governorate_a ( type: esriFieldTypeString, alias: اسم المحافظة الادارية بالعربي, length: 100 )
• governorate_e ( type: esriFieldTypeString, alias: اسم المحافظة الادارية بالانجليزي, length: 100 )
• moi_class_a ( type: esriFieldTypeInteger, alias: تصنيف وزارة الداخلية بالعربي )
• moi_class_e ( type: esriFieldTypeInteger, alias: تصنيف وزارة الداخلية بالانجليزي )
• saudi_male ( type: esriFieldTypeDouble, alias: اجمالي السكان السعوديين ذكور )
• saudi_fmale ( type: esriFieldTypeDouble, alias: اجمالي السكان السعوديين اناث )
• saudi_total ( type: esriFieldTypeDouble, alias: اجمالي السكان السعوديين )
• nonsaudi_male ( type: esriFieldTypeDouble, alias: اجمالي السكان غير السعوديين ذكور )
• nonsaudi_fmale ( type: esriFieldTypeDouble, alias: اجمالي السكان غير السعوديين اناث )
• nonsaudi_total ( type: esriFieldTypeDouble, alias: اجمالي السكان غير السعوديين )
• male_total ( type: esriFieldTypeDouble, alias: اجمالي الذكور )
• fmale_total ( type: esriFieldTypeDouble, alias: اجمالي الاناث )
• total_popul ( type: esriFieldTypeDouble, alias: اجمالي السكان )
• housing ( type: esriFieldTypeDouble, alias: اجمالي المساكن )
• popul_date ( type: esriFieldTypeDouble, alias: تاريخ التعداد )
• x_coordinates ( type: esriFieldTypeDouble, alias: الاحداثي السيني )
• y_coordinates ( type: esriFieldTypeDouble, alias: الاحداثي الصادي )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• govern_id ( type: esriFieldTypeInteger, alias: كود المحافظة الادارية )
• momra_classification ( type: esriFieldTypeInteger, alias: تصنيف الشئون البلدية والقروية )
• old ( type: esriFieldTypeInteger, alias: old )
• em ( type: esriFieldTypeInteger, alias: em )
• SHAPE_Length ( type: esriFieldTypeDouble, alias: SHAPE_Length )
• SHAPE_Area ( type: esriFieldTypeDouble, alias: SHAPE_Area )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: join_operation

Data Type: GPString
Display Name Join Operation
Description: Determines how joins between the target features and join features will be handled in the output feature class if multiple join features are found that have the same spatial relationship with a single target feature.JOIN_ONE_TO_ONE—If multiple join features are found that have the same spatial relationship with a single target feature, the attributes from the multiple join features will be aggregated using a field map merge rule. For example, if a point target feature is found within two separate polygon join features, the attributes from the two polygons will be aggregated before being transferred to the output point feature class. If one polygon has an attribute value of 3 and the other has a value of 7, and a Sum merge rule is specified, the aggregated value in the output feature class will be 10. This is the default.JOIN_ONE_TO_MANY—If multiple join features are found that have the same spatial relationship with a single target feature, the output feature class will contain multiple copies (records) of the target feature. For example, if a single point target feature is found within two separate polygon join features, the output feature class will contain two copies of the target feature: one record with the attributes of one polygon, and another record with the attributes of the other polygon.
Direction: esriGPParameterDirectionInput
Default Value: JOIN_ONE_TO_ONE
Parameter Type: esriGPParameterTypeOptional
Category:
Choice List: [ JOIN_ONE_TO_ONE, JOIN_ONE_TO_MANY ]

Parameter: join_type

Data Type: GPBoolean
Display Name Keep All Target Features
Description: Determines if all target features will be maintained in the output feature class (known as outer join), or only those that have the specified spatial relationship with the join features (inner join). Checked—All target features will be maintained in the output (outer join). This is the default. Unchecked—Only those target features that have the specified spatial relationship with the join features will be maintained in the output feature class (inner join). For example, if a point feature class is specified for the target features, and a polygon feature class is specified for the join features, with a Match Option of WITHIN, the output feature class will only contain those target features that are within a polygon join feature; any target features not within a join feature will be excluded from the output.
Direction: esriGPParameterDirectionInput
Default Value: true
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: field_mapping

Data Type: GPString
Display Name Field Map of Join Features
Description: Controls which attribute fields will be in the output feature class. The initial list contains all the fields from both the target features and the join features. Fields can be added, deleted, renamed, or have their properties changed. The selected fields from the target features are transferred as is, but selected fields from the join features can be aggregated by a valid merge rule. The default value is an empty string, in which case, all fields from both target and join features are transferred to the output. For details on field mapping, see the help topics "Using the field mapping control" and "Mapping input fields to output fields." Multiple fields and statistic combination may be specified.Merge rules allow you to specify how values from two or more input fields are merged or combined into a single output value. There are several merge rules that determine how the output field is populated with values.First—Use the input fields' first value.Last—Use the input fields' last value.Join—Concatenate (join) the input fields' values.Sum—Calculate the total of the input fields' values.Mean—Calculate the mean (average) of the input fields' values.Median—Calculate the median (middle) of the input fields' values.Mode—Use the value with the highest frequency.Min—Use the minimum value of all input fields' values.Max—Use the maximum value of all input fields' values.Standard deviation—Use the standard deviation classification method on all input fields' values.Count—Find the number of records included in the calculation.
Direction: esriGPParameterDirectionInput
Default Value: REGION_ID "REGION_ID" true true false 2 Short 0 5 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_Final.DBO.Areigions__1,REGION_ID,-1,-1;ANAME "ANAME" true true false 50 Text 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_Final.DBO.Areigions__1,ANAME,-1,-1;ENAME "ENAME" true true false 50 Text 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_Final.DBO.Areigions__1,ENAME,-1,-1;Test_ID "iest_id" true true false 2 Short 0 5 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_Final.DBO.Areigions__1,Test_ID,-1,-1;SHAPE_STArea__ "SHAPE_STArea__" false false true 0 Double 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_Final.DBO.Areigions__1,SHAPE.STArea(),-1,-1;SHAPE_STLength__ "SHAPE_STLength__" false false true 0 Double 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_Final.DBO.Areigions__1,SHAPE.STLength(),-1,-1;city_id "كود المدينة" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,city_id,-1,-1;aname_1 "اسم المدينة بالعربي" true true false 100 Text 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,aname,-1,-1;ename_1 "اسم المدينة بالانجليزي" true true false 100 Text 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,ename,-1,-1;region_a "اسم المنطقة الادارية بالعربي" true true false 4 Long 0 10 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,region_a,-1,-1;region_e "اسم المنطقة الادارية بالانجليزي" true true false 4 Long 0 10 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,region_e,-1,-1;governorate_a "اسم المحافظة الادارية بالعربي" true true false 100 Text 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,governorate_a,-1,-1;governorate_e "اسم المحافظة الادارية بالانجليزي" true true false 100 Text 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,governorate_e,-1,-1;moi_class_a "تصنيف وزارة الداخلية بالعربي" true true false 4 Long 0 10 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,moi_class_a,-1,-1;moi_class_e "تصنيف وزارة الداخلية بالانجليزي" true true false 4 Long 0 10 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,moi_class_e,-1,-1;saudi_male "اجمالي السكان السعوديين ذكور" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,saudi_male,-1,-1;saudi_fmale "اجمالي السكان السعوديين اناث" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,saudi_fmale,-1,-1;saudi_total "اجمالي السكان السعوديين" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,saudi_total,-1,-1;nonsaudi_male "اجمالي السكان غير السعوديين ذكور" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,nonsaudi_male,-1,-1;nonsaudi_fmale "اجمالي السكان غير السعوديين اناث" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,nonsaudi_fmale,-1,-1;nonsaudi_total "اجمالي السكان غير السعوديين" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,nonsaudi_total,-1,-1;male_total "اجمالي الذكور" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,male_total,-1,-1;fmale_total "اجمالي الاناث" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,fmale_total,-1,-1;total_popul "اجمالي السكان" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,total_popul,-1,-1;housing "اجمالي المساكن" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,housing,-1,-1;popul_date "تاريخ التعداد" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,popul_date,-1,-1;x_coordinates "الاحداثي السيني" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,x_coordinates,-1,-1;y_coordinates "الاحداثي الصادي" true true false 8 Double 8 38 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,y_coordinates,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,GlobalID,-1,-1;govern_id "كود المحافظة الادارية" true true false 4 Long 0 10 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,govern_id,-1,-1;momra_classification "تصنيف الشئون البلدية والقروية" true true false 4 Long 0 10 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,momra_classification,-1,-1;old "old" true true false 4 Long 0 10 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,old,-1,-1;em "em" true true false 4 Long 0 10 ,First,#,Database Connections\Connection to TBCWEB.sde\TBC_FINAL.DBO.Cities,em,-1,-1
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: match_option

Data Type: GPString
Display Name Match Option
Description: Defines the criteria used to match rows. The match options are:INTERSECT—The features in the join features will be matched if they intersect a target feature. This is the default. Specify a distance in the Search Radius parameter.INTERSECT_3D— The features in the join features will be matched if they intersect a target feature in three-dimensional space (x, y, and z). Specify a distance in the Search Radius parameter.WITHIN_A_DISTANCE—The features in the join features will be matched if they are within a specified distance of a target feature. Specify a distance in the Search Radius parameter.WITHIN_A_DISTANCE_GEODESIC—Same as Within a distance except that geodesic distance is used rather than planar distance. Choose this if your data covers a large geographic extent or the coordinate system of the inputs is unsuitable for distance calculations.WITHIN_A_DISTANCE_3D—The features in the join features will be matched if they are within a specified distance of a target feature in three-dimensional space. Specify a distance in the Search Radius parameter.CONTAINS—The features in the join features will be matched if a target feature contains them. The target features must be polygons or polylines. For this option, the target features cannot be points, and the join features can only be polygons when the target features are also polygons.COMPLETELY_CONTAINS—The features in the join features will be matched if a target feature completely contains them. Polygon can completely contain any feature. Point cannot completely contain any feature, not even a point. Polyline can completely contain only polyline and point.CONTAINS_CLEMENTINI—This spatial relationship yields the same results as Completely contains with the exception that if the join feature is entirely on the boundary of the target feature (no part is properly inside or outside) the feature will not be matched. Clementini defines the boundary polygon as the line separating inside and outside, the boundary of a line is defined as its end points, and the boundary of a point is always empty.WITHIN—The features in the join features will be matched if a target feature is within them. It is opposite to Contains. For this option, the target features can only be polygons when the join features are also polygons. Point can be join feature only if point is target. COMPLETELY_WITHIN—The features in the join features will be matched if a target feature is completely within them. This is opposite to Completely contains. WITHIN_CLEMENTINI—The result will be identical to Within except if the entirety of the feature in the join features is on the boundary of the target feature, the feature will not be matched. Clementini defines the boundary polygon as the line separating inside and outside, the boundary of a line is defined as its end points, and the boundary of a point is always empty.ARE_IDENTICAL_TO—The features in the join features will be matched if they are identical to a target feature. Both join and target feature must be of same shape type—point-to-point, line-to-line, and polygon-to-polygon. BOUNDARY_TOUCHES—The features in the join features will be matched if they have a boundary that touches a target feature. When the target and join features are lines or polygons, the boundary of the join feature can only touch the boundary of the target feature and no part of the join feature can cross the boundary of the target feature.SHARE_A_LINE_SEGMENT_WITH—The features in the join features will be matched if they share a line segment with a target feature. The join and target features must be lines or polygons.CROSSED_BY_THE_OUTLINE_OF—The features in the join features will be matched if a target feature is crossed by their outline. The join and target features must be lines or polygons. If polygons are used for the join or target features, the polygon's boundary (line) will be used. Lines that cross at a point will be matched, not lines that share a line segment.HAVE_THEIR_CENTER_IN—The features in the join features will be matched if a target feature's center falls within them. The center of the feature is calculated as follows: for polygon and multipoint the geometry's centroid is used, and for line input the geometry's midpoint is used. Specify a distance in the Search Radius parameter.CLOSEST—The feature in the join features that is closest to a target feature is matched. See the usage tip for more information. Specify a distance in the Search Radius parameter.CLOSEST_GEODESIC—Same as Closest except that geodesic distance is used rather than planar distance. Choose this if your data covers a large geographic extent or the coordinate system of the inputs is unsuitable for distance calculations
Direction: esriGPParameterDirectionInput
Default Value: INTERSECT
Parameter Type: esriGPParameterTypeOptional
Category:
Choice List: [ INTERSECT, INTERSECT_3D, WITHIN_A_DISTANCE_GEODESIC, WITHIN_A_DISTANCE, WITHIN_A_DISTANCE_3D, CONTAINS, COMPLETELY_CONTAINS, CONTAINS_CLEMENTINI, WITHIN, COMPLETELY_WITHIN, WITHIN_CLEMENTINI, ARE_IDENTICAL_TO, BOUNDARY_TOUCHES, SHARE_A_LINE_SEGMENT_WITH, CROSSED_BY_THE_OUTLINE_OF, HAVE_THEIR_CENTER_IN, CLOSEST_GEODESIC, CLOSEST ]

Parameter: search_radius

Data Type: GPLinearUnit
Display Name Search Radius
Description: Join features within this distance of a target feature will be considered for the spatial join. A search radius is only valid when the spatial relationship (Match Option) INTERSECT, WITHIN_A_DISTANCE, WITHIN_A_DISTANCE_GEODESIC, HAVE_THEIR_CENTER_IN, CLOSEST or CLOSEST_GEODESIC is specified. Using a search radius of 100 meters with the spatial relationship WITHIN_A_DISTANCE will join feature within 100 meters of a target feature. For the three WITHIN_A_DISTANCE relationships, if no value is specified for search radius then a distance of 0 is used.
Direction: esriGPParameterDirectionInput
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: distance_field_name

Data Type: GPString
Display Name Distance Field Name
Description:
Direction: esriGPParameterDirectionInput
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:

Supported Operations:   Submit Job