Display Name: Calculate Field

Description: Geoprocessing tool that calculates the values of a field for a feature class, feature layer, or raster.

Category:

Help URL: https://gis-portal.usc.edu/arcgis/rest/directories/arcgisoutput/CalculateField_GPServer/CalculateField/CalculateField.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: in_table

Data Type: GPString
Display Name Input Table
Description: The table containing the field that will be updated with the new calculation.
Direction: esriGPParameterDirectionInput
Filter: null
Dependency:
Default Value: Angeles_Trails
Parameter Type: esriGPParameterTypeRequired
Category:
Choice List: [ Angeles_Trails, Cucamonga Wilderness, Angeles National Forest, LA County ]

Parameter: field

Data Type: GPString
Display Name Field Name (Existing or New)
Description: The field that will be updated with the new calculation.If a field with the specified name does not exist in the input table, it will be added.
Direction: esriGPParameterDirectionInput
Filter: null
Dependency:
Default Value: Ranked_Weight
Parameter Type: esriGPParameterTypeRequired
Category:
Choice List: [ Shape, Name, OBJECTID, Length, Elev_Gain, Max_Elev, Trail_Type, Shape_Length, Ranked_Weight ]

Parameter: expression

Data Type: GPString
Display Name Expression
Description: The simple calculation expression used to create a value that will populate the selected rows.
Direction: esriGPParameterDirectionInput
Filter: null
Dependency:
Default Value: 0
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: expression_type

Data Type: GPString
Display Name Expression Type
Description: Specifies the type of expression that will be used.PYTHON and PYTHON_9.3 are still supported for backward compatibility but are not listed as choices. Python scripts that use these keywords will continue to work.Python 3 (PYTHON3 in Python) returns the values in date fields as Python datetime objects. PYTHON and PYTHON_9.3 return the values in date fields as strings.Python 3—Python expression type. This is the default.Arcade—Arcade expression type.SQL—SQL expression.To learn more about Python expressions, see Calculate Field examples.To learn more about Arcade expressions, see the ArcGIS Arcade guide.To learn more about SQL expressions, see Calculate field values.SQL expressions were implemented to support faster calculations for feature services. Instead of performing calculations one feature or row at a time, a single request is set to the feature service, resulting in significantly faster calculations.Only feature services support SQL expressions. For other formats, use Python or Arcade expressions.
Direction: esriGPParameterDirectionInput
Filter: null
Dependency:
Default Value: PYTHON3
Parameter Type: esriGPParameterTypeOptional
Category:
Choice List: [ PYTHON3, ARCADE ]

Parameter: code_block

Data Type: GPString
Display Name Code Block
Description: A block of code that will be entered for complex expressions.
Direction: esriGPParameterDirectionInput
Filter: null
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: out_table

Data Type: GPFeatureRecordSetLayer
Display Name Updated Input Table
Description:
Direction: esriGPParameterDirectionOutput
Filter: null
Dependency:
Default Value:
Geometry Type: esriGeometryPolyline
HasZ: true
HasM: false
Spatial Reference: 4326  (4326)  VCSWkid(115700)  LatestVCSWkid(115700)

Fields:
• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• Name ( type: esriFieldTypeString, alias: Trail Name, length: 255 )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• Length ( type: esriFieldTypeDouble, alias: Length )
• Elev_Gain ( type: esriFieldTypeInteger, alias: Elev_Gain )
• Max_Elev ( type: esriFieldTypeInteger, alias: Max_Elev )
• Trail_Type ( type: esriFieldTypeString, alias: Trail Type, length: 8000 )
• Ranked_Weight ( type: esriFieldTypeInteger, alias: Ranked_Weight )
• Shape_Length ( type: esriFieldTypeDouble, alias: Shape_Length )
Features: None.



Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: field_type

Data Type: GPString
Display Name Field Type
Description: The field type of the new field. This parameter is only used when the field name does not exist in the input table.If the field is of type text, the new field will have a length of 512. For shapefiles and dBASE files, the field will have a length of 254. The length of the new field can be adjusted using the Alter Field tool.Text—Any string of characters. Float (single precision)— Fractional numbers between -3.4E38 and 1.2E38.Double (double precision)— Fractional numbers between -2.2E308 and 1.8E308.Short (small integer)— Whole numbers between -32,768 and 32,767.Long (large integer)— Whole numbers between -2,147,483,648 and 2,147,483,647.Date—Date and time. Blob (binary data)—Long sequence of binary numbers. Raster imagery—Raster images. All ArcGIS software-supported raster dataset formats can be stored, but it is highly recommended that only small images be used.GUID (globally unique identifier)—Globally unique identifier.
Direction: esriGPParameterDirectionInput
Filter: null
Dependency:
Default Value: TEXT
Parameter Type: esriGPParameterTypeOptional
Category:
Choice List: [ TEXT, FLOAT, DOUBLE, SHORT, LONG, DATE, BLOB, RASTER, GUID ]

Parameter: esri_out_feature_service_name

Data Type: GPString
Display Name Output Feature Service Name
Description: The name of the optional feature service to create on the federated server containing the result of this tool. If no name is specified an output feature service will not be created.
Direction: esriGPParameterDirectionInput
Filter: null
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:

Supported Operations:   Submit Job