{ "name": "CalculateField", "displayName": "Clear Incidents", "description": "Clears reported incidents on the map", "category": "", "helpUrl": "https://unosatgis.cern.ch/h/rest/directories/arcgisoutput/UNOCC/UNOCC_GP_IncidentVisibilityToggle_v1_GPServer/UNOCC_UNOCC_GP_IncidentVisibilityToggle_v1/CalculateField.htm", "executionType": "esriExecutionTypeSynchronous", "parameters": [ { "name": "in_table", "dataType": "GPFeatureRecordSetLayer", "displayName": "Input Table", "description": "The table containing the field that will be updated with the new calculation.", "direction": "esriGPParameterDirectionInput", "defaultValue": { "displayFieldName": "", "geometryType": "esriGeometryPoint", "spatialReference": { "wkid": 102100, "latestWkid": 3857 }, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255 }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 1000 }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38 }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8 }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128 }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8 }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128 }, { "name": "Visibility", "type": "esriFieldTypeString", "alias": "Map Visibility", "length": 256 } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "field", "dataType": "GPString", "displayName": "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", "dependency": "in_table", "defaultValue": "Visibility", "parameterType": "esriGPParameterTypeRequired", "category": "", "choiceList": [ "Visibility" ] }, { "name": "expression", "dataType": "GPString", "displayName": "Expression", "description": "The simple calculation expression used to create a value that will populate the selected rows.", "direction": "esriGPParameterDirectionInput", "dependency": "in_table", "defaultValue": "\"No\"", "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "expression_type", "dataType": "GPString", "displayName": "Expression Type", "description": "Specifies the type of expression that will be used.Python\u2014The Python expression type will be used.Arcade\u2014The Arcade expression type will be used.SQL\u2014The SQL expression type will be used.VBScript\u2014The VBScript expression type will be used.If the input is a feature service, the default expression type is SQL. For any other type of input, the default expression type is Python.To learn more about Python expressions, see Calculate Field Python examples.To learn more about Arcade expressions, see the ArcGIS Arcade guide.To learn more about SQL expressions, see Calculate field values.SQL expressions support faster calculations for feature services and enterprise geodatabases. Instead of performing calculations one feature or row at a time, a single request is sent to the server or database, resulting in significantly faster calculations.Only feature services and enterprise geodatabases support SQL expressions. For other formats, use Python or Arcade expressions.", "direction": "esriGPParameterDirectionInput", "defaultValue": "Python", "parameterType": "esriGPParameterTypeOptional", "category": "", "choiceList": [ "Python" ] }, { "name": "code_block", "dataType": "GPString", "displayName": "Code Block", "description": "A block of code that will be used for complex expressions.", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "out_table", "dataType": "GPFeatureRecordSetLayer", "displayName": "Updated Input Table", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": { "displayFieldName": "", "geometryType": "esriGeometryPoint", "spatialReference": { "wkid": 102100, "latestWkid": 3857 }, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255 }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 1000 }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38 }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8 }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128 }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8 }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128 }, { "name": "Visibility", "type": "esriFieldTypeString", "alias": "Map Visibility", "length": 256 } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeDerived", "category": "" }, { "name": "field_type", "dataType": "GPString", "displayName": "Field Type", "description": "Specifies 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 field will have a length of 512, unless the input is a shapefile or dBASE file, in which case the length will be 254. To adjust the length, use the Alter Field tool.Short (16-bit integer)\u2014The field type will be short. Short fields support whole numbers between -32,768 and 32,767.Long (32-bit integer)\u2014The field type will be long. Long fields support whole numbers between -2,147,483,648 and 2,147,483,647.Big integer (64-bit integer)\u2014The field type will be big integer. Big integer fields support whole numbers between -(253) and 253Float (32-bit floating point)\u2014The field type will be float. Float fields support fractional numbers between -3.4E38 and 1.2E38.Double (64-bit floating point)\u2014The field type will be double. Double fields support fractional numbers between -2.2E308 and 1.8E308.Text\u2014The field type will be text. Text fields support a string of characters.Date\u2014The field type will be date. Date fields support date and time values.Date only\u2014The field type will be date only. Date only fields support date values with no time values.Time only\u2014The field type will be time only. Time only fields support time values with no date value.Timestamp offset\u2014The field type will be timestamp offset. Timestamp offset fields support a date, time and offset from UTC value.Blob (binary data)\u2014The field type will be BLOB. BLOB fields support data stored as a long sequence of binary numbers. You need a custom loader or viewer or a third-party application to load items into a BLOB field or view the contents of a BLOB field.GUID (globally unique identifier)\u2014The field type will be GUID. GUID fields store registry-style strings consisting of 36 characters enclosed in curly brackets.Raster\u2014 The field type will be raster. Raster fields can store raster data in or alongside the geodatabase. All ArcGIS software-supported raster dataset formats can be stored, but it is recommended that only small images be used.", "direction": "esriGPParameterDirectionInput", "defaultValue": "Text", "parameterType": "esriGPParameterTypeOptional", "category": "", "choiceList": [ "Text" ] }, { "name": "enforce_domains", "dataType": "GPBoolean", "displayName": "Enforce Domains", "description": "Specifies whether field domain rules will be enforced.Checked\u2014Field domain rules will be enforced. If a field cannot be updated, the field value will remain unchanged, and the tool messages will include a warning message.Unchecked\u2014Field domain rules will not be enforced. This is the default", "direction": "esriGPParameterDirectionInput", "defaultValue": false, "parameterType": "esriGPParameterTypeOptional", "category": "" } ] }