{
 "name": "Append",
 "displayName": "Append",
 "description": "Appends to, or optionally updates, an existing target dataset with multiple input datasets. Input datasets can be feature classes, tables, shapefiles, rasters, or annotation or dimension feature classes.",
 "category": "",
 "helpUrl": "https://lcgispubags.lanecountyor.gov/arcgis/rest/directories/arcgisoutput/test/Appendtool_Test_GPServer/test_Appendtool_Test/Append.htm",
 "executionType": "esriExecutionTypeAsynchronous",
 "parameters": [
  {
   "name": "inputs",
   "dataType": "GPMultiValue:GPString",
   "displayName": "Input Datasets",
   "description": "The input datasets containing the data to be appended to the target dataset. Input datasets can be point, line, or polygon feature classes, tables, rasters, annotation feature classes, or dimensions feature classes.Tables and feature classes can be combined. If a feature class is appended to a table, attributes will be transferred; however, the features will be dropped. If a table is appended to a feature class, the rows from the input table will have null geometry.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": [
    "AppendTool_JunctionCopy"
   ],
   "parameterType": "esriGPParameterTypeRequired",
   "category": "",
   "choiceList": [
    "AppendTool_JunctionCopy",
    "CV_Demo"
   ],
   "parameterInfos": [
    {
     "name": "String",
     "dataType": "GPString",
     "displayName": "String"
    }
   ]
  },
  {
   "name": "target",
   "dataType": "GPString",
   "displayName": "Target Dataset",
   "description": "The existing dataset where the data of the input datasets will be appended.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "CV_Demo",
   "parameterType": "esriGPParameterTypeRequired",
   "category": "",
   "choiceList": [
    "AppendTool_JunctionCopy",
    "CV_Demo"
   ]
  },
  {
   "name": "schema_type",
   "dataType": "GPString",
   "displayName": "Field Matching Type",
   "description": "Specifies whether the fields of the input dataset must match the fields of the target dataset for data to be appended.Input fields must match target fields\u2014Fields from the input dataset must match the fields of the target dataset. An error will be returned if the fields do not match.Use the field map to reconcile field differences\u2014Fields from the input dataset do not need to match the fields of the target dataset. Fields from the input datasets that do not match the fields of the target dataset will not be mapped to the target dataset unless the mapping is explicitly set in the Field Map parameter.Skip and warn if schema does not match\u2014Fields from the input dataset must match the fields of the target dataset. If any of the input datasets contain fields that do not match the target dataset, that input dataset will be omitted with a warning message.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "NO_TEST",
   "parameterType": "esriGPParameterTypeOptional",
   "category": "",
   "choiceList": [
    "TEST",
    "NO_TEST",
    "TEST_AND_SKIP"
   ]
  },
  {
   "name": "field_mapping",
   "dataType": "GPString",
   "displayName": "Field Map",
   "description": "Controls how the attribute fields from the input datasets will be transferred or mapped to the target dataset.This parameter can only be used if the Field Matching Type parameter is set to Use the field map to reconcile field differences.Because the input datasets are appended to an existing target dataset that has predefined fields, you cannot add, remove, or change the type of the fields in the field map. You can set merge rules for each output field.Merge rules allow you to specify how values from two or more input fields will be merged or combined into a single output value. The following merge rules can be used to determine how the output field will be populated with values:First\u2014Use the input fields' first value.Last\u2014Use the input fields' last value.Join\u2014Concatenate (join) the input field values.Sum\u2014Calculate the total of the input field values.Mean\u2014Calculate the mean (average) of the input field values.Median\u2014Calculate the median (middle) of the input field values.Mode\u2014Use the value with the highest frequency.Min\u2014Use the minimum value of all the input field values.Max\u2014Use the maximum value of all the input field values.Standard deviation\u2014Use the standard deviation classification method on all the input field values.Count\u2014Find the number of records included in the calculation.",
   "direction": "esriGPParameterDirectionInput",
   "dependency": "inputs",
   "defaultValue": "ROADNM \"ROAD NAME\" true true false 512 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,ROADNM,0,512;JLCPWID \"JNumber\" true true false 10 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,JLCPWID,0,10;COEStructureNo \"COEStructureNo\" true true false 4 Long 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,COEStructureNo,-1,-1;UICNo \"UICNumber\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,UICNo,0,255;QAQCSTAT \"QAQCStat\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,QAQCSTAT,0,255;QAQC_Issue \"QAQC_Issue\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,QAQC_Issue,0,255;PosDup \"PosDup\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,PosDup,0,255;TYPE \"TYPE\" true true false 100 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,TYPE,0,100;SUBTYPE \"SUBTYPE\" true true false 100 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,SUBTYPE,0,100;COETYPE \"COEType\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,COETYPE,0,255;MSInspectDate \"MSInspectDate\" true true false 8 Date 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,MSInspectDate,-1,-1;LastCleanDate \"LastCleanDate\" true true false 8 Date 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,LastCleanDate,-1,-1;JDICTION \"JURISDICTION\" true true false 50 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,JDICTION,0,50;DEPT \"DEPARTMENT\" true true false 50 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,DEPT,0,50;OPMAINT \"OPERATIONAL MAINTENANCE\" true true false 50 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,OPMAINT,0,50;QAQC_Issue1 \"QAQC_Issue1\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,QAQC_Issue1,0,255;NOTES \"NOTES\" true true false 1024 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,NOTES,0,1024;QAQCFieldNotes \"QAQCFieldNotes\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,QAQCFieldNotes,0,255;InvRemark \"InvRemark\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,InvRemark,0,255;InvConflict \"InvConflict\" true true false 255 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,InvConflict,0,255;SUMP \"SUMP\" true true false 10 Text 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,SUMP,0,10;GlobalID \"GlobalID\" false false true 38 GlobalID 0 0,First,#,G:\\Caitlin\\storagebin.gdb\\SW\\AppendTool_JunctionCopy,GlobalID,-1,-1",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "subtype",
   "dataType": "GPString",
   "displayName": "Subtype",
   "description": "The subtype description that will be assigned to all new data that is appended to the target dataset.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "output",
   "dataType": "GPFeatureRecordSetLayer",
   "displayName": "Updated Target Dataset",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "geometryType": "esriGeometryPoint",
    "spatialReference": {
     "wkid": 2914,
     "latestWkid": 2914
    },
    "fields": [
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID"
     },
     {
      "name": "ROADNM",
      "type": "esriFieldTypeString",
      "alias": "ROAD NAME",
      "length": 512
     },
     {
      "name": "JLCPWID",
      "type": "esriFieldTypeString",
      "alias": "JNumber",
      "length": 10
     },
     {
      "name": "COEStructureNo",
      "type": "esriFieldTypeInteger",
      "alias": "COEStructureNo"
     },
     {
      "name": "UICNo",
      "type": "esriFieldTypeString",
      "alias": "UICNumber",
      "length": 255
     },
     {
      "name": "QAQCSTAT",
      "type": "esriFieldTypeString",
      "alias": "QAQCStat",
      "length": 255
     },
     {
      "name": "QAQC_Issue",
      "type": "esriFieldTypeString",
      "alias": "QAQC_Issue",
      "length": 255
     },
     {
      "name": "PosDup",
      "type": "esriFieldTypeString",
      "alias": "PosDup",
      "length": 255
     },
     {
      "name": "TYPE",
      "type": "esriFieldTypeString",
      "alias": "TYPE",
      "length": 100
     },
     {
      "name": "SUBTYPE",
      "type": "esriFieldTypeString",
      "alias": "SUBTYPE",
      "length": 100
     },
     {
      "name": "COETYPE",
      "type": "esriFieldTypeString",
      "alias": "COEType",
      "length": 255
     },
     {
      "name": "MSInspectDate",
      "type": "esriFieldTypeDate",
      "alias": "MSInspectDate",
      "length": 8
     },
     {
      "name": "LastCleanDate",
      "type": "esriFieldTypeDate",
      "alias": "LastCleanDate",
      "length": 8
     },
     {
      "name": "JDICTION",
      "type": "esriFieldTypeString",
      "alias": "JURISDICTION",
      "length": 50
     },
     {
      "name": "DEPT",
      "type": "esriFieldTypeString",
      "alias": "DEPARTMENT",
      "length": 50
     },
     {
      "name": "OPMAINT",
      "type": "esriFieldTypeString",
      "alias": "OPERATIONAL MAINTENANCE",
      "length": 50
     },
     {
      "name": "QAQC_Issue1",
      "type": "esriFieldTypeString",
      "alias": "QAQC_Issue1",
      "length": 255
     },
     {
      "name": "NOTES",
      "type": "esriFieldTypeString",
      "alias": "NOTES",
      "length": 1024
     },
     {
      "name": "QAQCFieldNotes",
      "type": "esriFieldTypeString",
      "alias": "QAQCFieldNotes",
      "length": 255
     },
     {
      "name": "InvRemark",
      "type": "esriFieldTypeString",
      "alias": "InvRemark",
      "length": 255
     },
     {
      "name": "InvConflict",
      "type": "esriFieldTypeString",
      "alias": "InvConflict",
      "length": 255
     },
     {
      "name": "SUMP",
      "type": "esriFieldTypeString",
      "alias": "SUMP",
      "length": 10
     },
     {
      "name": "GlobalID",
      "type": "esriFieldTypeGlobalID",
      "alias": "GlobalID",
      "length": 38
     }
    ],
    "features": [],
    "exceededTransferLimit": false
   },
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  },
  {
   "name": "expression",
   "dataType": "GPString",
   "displayName": "Expression",
   "description": "The SQL expression that will be used to select a subset of the input datasets' records. If multiple input datasets are specified, they will all be evaluated using the expression. If no records match the expression for an input dataset, no records from that dataset will be appended to the target.For more information about SQL syntax, see SQL reference for query expressions used in ArcGIS.",
   "direction": "esriGPParameterDirectionInput",
   "dependency": "inputs",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "match_fields",
   "dataType": "GPValueTable",
   "displayName": "Matching Fields for Update",
   "description": "The fields from the input dataset that will be used to match to the target dataset. If the values of these fields match, records from the input dataset will update the corresponding records of the target dataset.",
   "direction": "esriGPParameterDirectionInput",
   "dependency": "target",
   "defaultValue": [],
   "parameterType": "esriGPParameterTypeOptional",
   "category": "Update Options",
   "parameterInfos": [
    {
     "name": "Target Fields",
     "dataType": "GPString",
     "displayName": "Target Fields",
     "choiceList": [
      "OBJECTID",
      "COEStructureNo",
      "QAQC_Issue",
      "PosDup",
      "TYPE",
      "SUBTYPE",
      "MSInspectDate",
      "LastCleanDate",
      "QAQC_Issue1",
      "NOTES",
      "QAQCFieldNotes",
      "InvRemark",
      "InvConflict",
      "SUMP",
      "GlobalID"
     ]
    },
    {
     "name": "Input Fields",
     "dataType": "GPString",
     "displayName": "Input Fields",
     "choiceList": [
      "OBJECTID",
      "COEStructureNo",
      "QAQC_Issue",
      "PosDup",
      "TYPE",
      "SUBTYPE",
      "MSInspectDate",
      "LastCleanDate",
      "QAQC_Issue1",
      "NOTES",
      "QAQCFieldNotes",
      "InvRemark",
      "InvConflict",
      "SUMP",
      "GlobalID"
     ]
    }
   ]
  },
  {
   "name": "update_geometry",
   "dataType": "GPBoolean",
   "displayName": "Update Geometry",
   "description": "Specifies whether geometry in the target dataset will be updated with geometry from the input dataset if the Matching Fields for Update parameter field values match.Checked\u2014Geometry in the target dataset will be updated if the Matching Fields for Update parameter field values match.Unchecked\u2014Geometry will not be updated. This is the default.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": false,
   "parameterType": "esriGPParameterTypeOptional",
   "category": "Update Options"
  },
  {
   "name": "esri_out_feature_service_name",
   "dataType": "GPString",
   "displayName": "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",
   "defaultValue": "",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  }
 ]
}