{ "name": "SpatialJoin", "displayName": "Spatial Join", "description": "Joins attributes from one feature to another based on the spatial relationship. The target features and the joined attributes from the join features are written to the output feature class.", "category": "", "helpUrl": "https://solutions.esri.in/server/rest/directories/arcgisoutput/SpatialJoin_GPServer/SpatialJoin/SpatialJoin.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "target_features", "dataType": "GPString", "displayName": "Target Features", "description": "The attributes from the target features and the attributes from the joined features will be transferred to the output feature class. However, a subset of attributes can be defined by the field map parameter.", "direction": "esriGPParameterDirectionInput", "defaultValue": "Zone", "parameterType": "esriGPParameterTypeRequired", "category": "", "choiceList": [ "Zone_SpatialJoin", "Zone", "Container" ] }, { "name": "join_features", "dataType": "GPString", "displayName": "Join Features", "description": "The attributes from the join features will be 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", "defaultValue": "Container", "parameterType": "esriGPParameterTypeRequired", "category": "", "choiceList": [ "Zone_SpatialJoin", "Zone", "Container" ] }, { "name": "out_feature_class", "dataType": "GPFeatureRecordSetLayer", "displayName": "Output Feature Class", "description": "A new feature class containing the attributes of the target and join features. By default, all attributes of the target features and the attributes of the joined features will be written to the output. However, the set of attributes to be transferred can be defined by the field map parameter.", "direction": "esriGPParameterDirectionOutput", "defaultValue": { "displayFieldName": "", "hasZ": true, "hasM": true, "geometryType": "esriGeometryPolyline", "spatialReference": { "wkid": 102100, "latestWkid": 3857 }, "fields": [ { "name": "OBJECTID_12", "type": "esriFieldTypeOID", "alias": "OBJECTID_12" }, { "name": "Join_Count", "type": "esriFieldTypeInteger", "alias": "Join_Count" }, { "name": "TARGET_FID", "type": "esriFieldTypeInteger", "alias": "TARGET_FID" }, { "name": "JOIN_FID", "type": "esriFieldTypeInteger", "alias": "JOIN_FID" }, { "name": "objectid", "type": "esriFieldTypeInteger", "alias": "objectid" }, { "name": "zone_name", "type": "esriFieldTypeString", "alias": "zone_name", "length": 254 }, { "name": "objectid_1", "type": "esriFieldTypeInteger", "alias": "objectid_1" }, { "name": "shape_leng", "type": "esriFieldTypeDouble", "alias": "shape_leng" }, { "name": "zone_name_", "type": "esriFieldTypeString", "alias": "zone_name_", "length": 254 }, { "name": "capacity_a", "type": "esriFieldTypeString", "alias": "capacity_a", "length": 254 }, { "name": "current_ar", "type": "esriFieldTypeString", "alias": "current_ar", "length": 254 }, { "name": "capacity_h", "type": "esriFieldTypeString", "alias": "capacity_h", "length": 254 }, { "name": "current_ma", "type": "esriFieldTypeString", "alias": "current_ma", "length": 254 }, { "name": "occupancy_", "type": "esriFieldTypeString", "alias": "occupancy_", "length": 254 }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 254 }, { "name": "allowed_ty", "type": "esriFieldTypeString", "alias": "allowed_ty", "length": 254 }, { "name": "globalid", "type": "esriFieldTypeString", "alias": "globalid", "length": 38 }, { "name": "created_da", "type": "esriFieldTypeDate", "alias": "created_da", "length": 8 }, { "name": "created_us", "type": "esriFieldTypeString", "alias": "created_us", "length": 254 }, { "name": "last_edite", "type": "esriFieldTypeDate", "alias": "last_edite", "length": 8 }, { "name": "last_edi_1", "type": "esriFieldTypeString", "alias": "last_edi_1", "length": 254 }, { "name": "st_length_", "type": "esriFieldTypeDouble", "alias": "st_length_" }, { "name": "objectid_2", "type": "esriFieldTypeInteger", "alias": "objectid" }, { "name": "container_", "type": "esriFieldTypeString", "alias": "container_", "length": 254 }, { "name": "container1", "type": "esriFieldTypeString", "alias": "container1", "length": 254 }, { "name": "length_m", "type": "esriFieldTypeDouble", "alias": "length_m" }, { "name": "width_m", "type": "esriFieldTypeDouble", "alias": "width_m" }, { "name": "height_m", "type": "esriFieldTypeDouble", "alias": "height_m" }, { "name": "zone_nam_1", "type": "esriFieldTypeString", "alias": "zone_name", "length": 254 }, { "name": "stacklevel", "type": "esriFieldTypeInteger", "alias": "stacklevel" }, { "name": "base_heigh", "type": "esriFieldTypeDouble", "alias": "base_heigh" }, { "name": "top_height", "type": "esriFieldTypeDouble", "alias": "top_height" }, { "name": "status_1", "type": "esriFieldTypeString", "alias": "status", "length": 254 }, { "name": "intake_id", "type": "esriFieldTypeString", "alias": "intake_id", "length": 38 }, { "name": "globalid_1", "type": "esriFieldTypeString", "alias": "globalid", "length": 38 }, { "name": "created__1", "type": "esriFieldTypeDate", "alias": "created_da", "length": 8 }, { "name": "created__2", "type": "esriFieldTypeString", "alias": "created_us", "length": 254 }, { "name": "last_edi_2", "type": "esriFieldTypeDate", "alias": "last_edite", "length": 8 }, { "name": "last_edi_3", "type": "esriFieldTypeString", "alias": "last_edi_1", "length": 254 }, { "name": "st_area_sh", "type": "esriFieldTypeDouble", "alias": "st_area_sh" }, { "name": "st_length1", "type": "esriFieldTypeDouble", "alias": "st_length_" }, { "name": "Shape_Length", "type": "esriFieldTypeDouble", "alias": "Shape_Length" } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "join_operation", "dataType": "GPString", "displayName": "Join Operation", "description": "The operation that will join the target features and join features 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\u2014If 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\u2014If 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", "defaultValue": "Join one to many", "parameterType": "esriGPParameterTypeOptional", "category": "", "choiceList": [ "Join one to one", "Join one to many" ] }, { "name": "join_type", "dataType": "GPBoolean", "displayName": "Keep All Target Features", "description": "Specifies whether all target features will be maintained in the output feature class (an outer join) or only those that have the specified spatial relationship with the join features (an inner join).Checked\u2014All target features will be maintained in the output (outer join). This is the default.Unchecked\u2014Only 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 value 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", "defaultValue": true, "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "field_mapping", "dataType": "GPString", "displayName": "Field Map", "description": "The fields that will be included in the output feature class with their respective properties and source fields. The output includes all fields from the join and target features by default.Use the field map to add, delete, rename, and reorder fields, as well as change other field properties.The field map can be used to combine values from two or more input fields into a single output field.", "direction": "esriGPParameterDirectionInput", "dependency": "target_features", "defaultValue": "objectid \"objectid\" true true false 10 Long 0 10,First,#,Zone,objectid,-1,-1;zone_name \"zone_name\" true true false 254 Text 0 0,First,#,Zone,zone_name,0,253;objectid_1 \"objectid_1\" true true false 10 Long 0 10,First,#,Zone,objectid_1,-1,-1;shape_leng \"shape_leng\" true true false 19 Double 8 18,First,#,Zone,shape_leng,-1,-1;zone_name_ \"zone_name_\" true true false 254 Text 0 0,First,#,Zone,zone_name_,0,253;capacity_a \"capacity_a\" true true false 254 Text 0 0,First,#,Zone,capacity_a,0,253;current_ar \"current_ar\" true true false 254 Text 0 0,First,#,Zone,current_ar,0,253;capacity_h \"capacity_h\" true true false 254 Text 0 0,First,#,Zone,capacity_h,0,253;current_ma \"current_ma\" true true false 254 Text 0 0,First,#,Zone,current_ma,0,253;occupancy_ \"occupancy_\" true true false 254 Text 0 0,First,#,Zone,occupancy_,0,253;status \"status\" true true false 254 Text 0 0,First,#,Zone,status,0,253;allowed_ty \"allowed_ty\" true true false 254 Text 0 0,First,#,Zone,allowed_ty,0,253;globalid \"globalid\" true true false 38 Text 0 0,First,#,Zone,globalid,0,37;created_da \"created_da\" true true false 8 Date 0 0,First,#,Zone,created_da,-1,-1;created_us \"created_us\" true true false 254 Text 0 0,First,#,Zone,created_us,0,253;last_edite \"last_edite\" true true false 8 Date 0 0,First,#,Zone,last_edite,-1,-1;last_edi_1 \"last_edi_1\" true true false 254 Text 0 0,First,#,Zone,last_edi_1,0,253;st_length_ \"st_length_\" true true false 19 Double 0 0,First,#,Zone,st_length_,-1,-1;objectid_2 \"objectid\" true true false 10 Long 0 10,First,#,Container,objectid,-1,-1;container_ \"container_\" true true false 254 Text 0 0,First,#,Container,container_,0,253;container1 \"container1\" true true false 254 Text 0 0,First,#,Container,container1,0,253;length_m \"length_m\" true true false 19 Double 8 18,First,#,Container,length_m,-1,-1;width_m \"width_m\" true true false 19 Double 8 18,First,#,Container,width_m,-1,-1;height_m \"height_m\" true true false 19 Double 8 18,First,#,Container,height_m,-1,-1;zone_nam_1 \"zone_name\" true true false 254 Text 0 0,First,#,Container,zone_name,0,253;stacklevel \"stacklevel\" true true false 5 Long 0 5,First,#,Container,stacklevel,-1,-1;base_heigh \"base_heigh\" true true false 19 Double 8 18,First,#,Container,base_heigh,-1,-1;top_height \"top_height\" true true false 19 Double 8 18,First,#,Container,top_height,-1,-1;status_1 \"status\" true true false 254 Text 0 0,First,#,Container,status,0,253;intake_id \"intake_id\" true true false 38 Text 0 0,First,#,Container,intake_id,0,37;globalid_1 \"globalid\" true true false 38 Text 0 0,First,#,Container,globalid,0,37;created__1 \"created_da\" true true false 8 Date 0 0,First,#,Container,created_da,-1,-1;created__2 \"created_us\" true true false 254 Text 0 0,First,#,Container,created_us,0,253;last_edi_2 \"last_edite\" true true false 8 Date 0 0,First,#,Container,last_edite,-1,-1;last_edi_3 \"last_edi_1\" true true false 254 Text 0 0,First,#,Container,last_edi_1,0,253;st_area_sh \"st_area_sh\" true true false 19 Double 0 0,First,#,Container,st_area_sh,-1,-1;st_length1 \"st_length_\" true true false 19 Double 0 0,First,#,Container,st_length_,-1,-1", "parameterType": "esriGPParameterTypeOptional", "category": "Fields" }, { "name": "match_option", "dataType": "GPString", "displayName": "Match Option", "description": "Specifies the criteria that will be used to match rows.Intersect\u2014The features in the join features will be matched if they intersect a target feature. This is the default. Specify the distance in the Search Radius parameter.Intersect 3D\u2014 The features in the join features will be matched if they intersect a target feature in three-dimensional space (x, y, and z). Specify the distance in the Search Radius parameter.Within a distance\u2014The features in the join features will be matched if they are within a specified distance of a target feature. Specify the distance in the Search Radius parameter.Within a distance geodesic\u2014This is the same as Within a distance except that geodesic distance is used rather than planar distance. Distance between features will be calculated using a geodesic formula that takes into account the curvature of the spheroid and correctly handles data near and across the dateline and poles. Use this option if the data covers a large geographic extent or the coordinate system of the inputs is unsuitable for distance calculations.Within a distance 3D\u2014The features in the join features will be matched if they are within a specified distance of a target feature in three-dimensional space. Specify the distance in the Search Radius parameter.Contains\u2014The 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\u2014The features in the join features will be matched if a target feature completely contains them. A polygon can completely contain any feature. A point cannot completely contain any feature, not even a point. A polyline can completely contain only polyline and point features.Contains Clementini\u2014This spatial relationship produces the same results as Completely contains except 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\u2014The features in the join features will be matched if a target feature is within them. This is the opposite of Contains. For this option, the target features can only be polygons when the join features are also polygons. A point can be a join feature only if a point is the target.Completely within\u2014The features in the join features will be matched if a target feature is completely within them. This is the opposite of Completely contains.Within Clementini\u2014The 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\u2014The features in the join features will be matched if they are identical to a target feature. Both join and target feature must be of the same shape type\u2014point to point, line to line, or polygon to polygon.Boundary touches\u2014The 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\u2014The 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\u2014The 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; lines that share a line segment will not be matched.Have their center in\u2014The 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 the distance in the Search Radius parameter.Closest\u2014The feature in the join features that is closest to a target feature will be matched. See the usage tip for more information. Specify the distance in the Search Radius parameter.Closest geodesic\u2014This is the same as Closest except that geodesic distance is used rather than planar distance. Use this option if the data covers a large geographic extent or the coordinate system of the inputs is unsuitable for distance calculationsLargest overlap\u2014The feature in the join features will be matched with the target feature with the largest overlap.", "direction": "esriGPParameterDirectionInput", "defaultValue": "Intersect", "parameterType": "esriGPParameterTypeOptional", "category": "", "choiceList": [ "Intersect", "Intersect 3D", "Largest overlap", "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" ] }, { "name": "search_radius", "dataType": "GPLinearUnit", "displayName": "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 is specified (the Match Option parameter is set to Intersect, Within a distance, Within a distance geodesic, Have their center in, Closest, or Closest geodesic). For example, using a search radius of 100 meters with the Within a distance spatial relationship 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, a distance of 0 is used.", "direction": "esriGPParameterDirectionInput", "dependency": "target_features", "defaultValue": null, "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "distance_field_name", "dataType": "GPString", "displayName": "Distance Field Name", "description": "The name of the field that contains the distance between the target feature and the closest join feature. This field will be added to the output feature class. This parameter is only valid when the spatial relationship is specified (Match Option is set to Closest or Closest geodesic). The value of this field is -1 if no feature is matched within a search radius. If no field name is provided, the field will not be added to the output feature class.", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "match_fields", "dataType": "GPValueTable", "displayName": "Match Fields", "description": "Pairs of fields from the join features and target features that will be used for attribute matching. Only the records from the join features that share match field values with the target features will participate in the spatial join.", "direction": "esriGPParameterDirectionInput", "dependency": "target_features", "defaultValue": [], "parameterType": "esriGPParameterTypeOptional", "category": "Attribute Matching", "parameterInfos": [ { "name": "Join Fields", "dataType": "GPString", "displayName": "Join Fields", "choiceList": [ "FID", "objectid", "container_", "container1", "length_m", "width_m", "height_m", "zone_name", "stacklevel", "base_heigh", "top_height", "status", "intake_id", "globalid", "created_da", "created_us", "last_edite", "last_edi_1", "st_area_sh", "st_length_" ] }, { "name": "Target Fields", "dataType": "GPString", "displayName": "Target Fields", "choiceList": [ "FID", "objectid", "zone_name", "objectid_1", "shape_leng", "zone_name_", "capacity_a", "current_ar", "capacity_h", "current_ma", "occupancy_", "status", "allowed_ty", "globalid", "created_da", "created_us", "last_edite", "last_edi_1", "st_length_" ] } ] }, { "name": "esri_out_feature_service_name", "dataType": "GPString", "displayName": "Output Feature Service Name", "description": "The name of the hosted feature service containing all the feature or table results of the tool. When no name is specified, standard feature or table results will still be available.", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" } ] }