{
 "name": "assetCalc",
 "displayName": "assetCalcByExpression",
 "description": "user selects JOBNO, FIXEDASSETID, or WWACCOUNT to locate  associated main assets.",
 "category": "",
 "helpUrl": "https://arcgis.cincinnati-oh.gov/arcgis/rest/directories/arcgisoutput/GPservices/assetCalculator_GPServer/GPservices_assetCalculator/assetCalc.htm",
 "executionType": "esriExecutionTypeAsynchronous",
 "parameters": [
  {
   "name": "value",
   "dataType": "GPString",
   "displayName": "value",
   "description": "value",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "WSL-2499",
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "queryType",
   "dataType": "GPString",
   "displayName": "queryType",
   "description": "type of query",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "JOBNO",
   "parameterType": "esriGPParameterTypeRequired",
   "category": "",
   "choiceList": [
    "FIXEDASSETNO",
    "WWACCOUNT",
    "JOBNO"
   ]
  },
  {
   "name": "FIXED_ASSET_LAYER",
   "dataType": "GPFeatureRecordSetLayer",
   "displayName": "FIXED_ASSET_LAYER",
   "description": "Output layer",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "geometryType": "esriGeometryPolyline",
    "spatialReference": {
     "wkid": 102723,
     "latestWkid": 3735
    },
    "fields": [
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID"
     },
     {
      "name": "ENABLED",
      "type": "esriFieldTypeSmallInteger",
      "alias": "ENABLED"
     },
     {
      "name": "EDITOR",
      "type": "esriFieldTypeString",
      "alias": "EDITOR",
      "length": 30
     },
     {
      "name": "CREATION_DATE",
      "type": "esriFieldTypeDate",
      "alias": "CREATION_DATE",
      "length": 36
     },
     {
      "name": "LAST_EDIT",
      "type": "esriFieldTypeDate",
      "alias": "LAST_EDIT",
      "length": 36
     },
     {
      "name": "ASSETID",
      "type": "esriFieldTypeInteger",
      "alias": "ASSETID"
     },
     {
      "name": "FACILITYID",
      "type": "esriFieldTypeString",
      "alias": "FACILITYID",
      "length": 20
     },
     {
      "name": "INSTALLYEAR",
      "type": "esriFieldTypeSmallInteger",
      "alias": "INSTALLYEAR"
     },
     {
      "name": "SERVICEAREA",
      "type": "esriFieldTypeString",
      "alias": "SERVICEAREA",
      "length": 4
     },
     {
      "name": "LIFECYCLESTATUS",
      "type": "esriFieldTypeString",
      "alias": "LIFECYCLESTATUS",
      "length": 20
     },
     {
      "name": "LIFECYCLECHANGEYEAR",
      "type": "esriFieldTypeInteger",
      "alias": "LIFECYCLECHANGEYEAR"
     },
     {
      "name": "SUBTYPE",
      "type": "esriFieldTypeInteger",
      "alias": "Subtype"
     },
     {
      "name": "MATERIAL",
      "type": "esriFieldTypeString",
      "alias": "MATERIAL",
      "length": 20
     },
     {
      "name": "MICROFICHE",
      "type": "esriFieldTypeString",
      "alias": "MICROFICHE",
      "length": 7
     },
     {
      "name": "JOBNUMBER",
      "type": "esriFieldTypeString",
      "alias": "JOBNUMBER",
      "length": 10
     },
     {
      "name": "PROJECT",
      "type": "esriFieldTypeInteger",
      "alias": "PROJECT"
     },
     {
      "name": "BRANCHNUMBER",
      "type": "esriFieldTypeString",
      "alias": "BRANCHNUMBER",
      "length": 7
     },
     {
      "name": "REMARKS",
      "type": "esriFieldTypeString",
      "alias": "REMARKS",
      "length": 50
     },
     {
      "name": "OUTOFSERVICE",
      "type": "esriFieldTypeSmallInteger",
      "alias": "OutOfService"
     },
     {
      "name": "EXTERIORCOATING",
      "type": "esriFieldTypeString",
      "alias": "EXTERIORCOATING",
      "length": 4
     },
     {
      "name": "JOINTTYPE1",
      "type": "esriFieldTypeString",
      "alias": "JOINTTYPE1",
      "length": 20
     },
     {
      "name": "JOINTTYPE2",
      "type": "esriFieldTypeString",
      "alias": "JOINTTYPE2",
      "length": 20
     },
     {
      "name": "INSULATED",
      "type": "esriFieldTypeSmallInteger",
      "alias": "INSULATED"
     },
     {
      "name": "CROSSINGTYPE",
      "type": "esriFieldTypeString",
      "alias": "CROSSINGTYPE",
      "length": 2
     },
     {
      "name": "REHABTYPE",
      "type": "esriFieldTypeString",
      "alias": "REHABTYPE",
      "length": 2
     },
     {
      "name": "REHABYEAR",
      "type": "esriFieldTypeInteger",
      "alias": "REHABYEAR"
     },
     {
      "name": "RESTRAINTPIPETYPE",
      "type": "esriFieldTypeString",
      "alias": "RESTRAINTPIPETYPE",
      "length": 2
     },
     {
      "name": "CORROSIONPOTENTIAL",
      "type": "esriFieldTypeString",
      "alias": "CORROSIONPOTENTIAL",
      "length": 4
     },
     {
      "name": "PLANTNET",
      "type": "esriFieldTypeString",
      "alias": "PlantNet",
      "length": 2
     },
     {
      "name": "PLAN",
      "type": "esriFieldTypeString",
      "alias": "PLAN",
      "length": 20
     },
     {
      "name": "C_FACTOR",
      "type": "esriFieldTypeInteger",
      "alias": "C_FACTOR"
     },
     {
      "name": "MODELDESCRIPTOR",
      "type": "esriFieldTypeString",
      "alias": "MODELDESCRIPTOR",
      "length": 50
     },
     {
      "name": "REDUCIBLE",
      "type": "esriFieldTypeSmallInteger",
      "alias": "REDUCIBLE"
     },
     {
      "name": "DEPTH",
      "type": "esriFieldTypeDouble",
      "alias": "DEPTH"
     },
     {
      "name": "DIAMETER",
      "type": "esriFieldTypeDouble",
      "alias": "DIAMETER"
     },
     {
      "name": "GROUNDSURFACETYPE",
      "type": "esriFieldTypeString",
      "alias": "GROUNDSURFACETYPE",
      "length": 20
     },
     {
      "name": "PRESSURERATING",
      "type": "esriFieldTypeString",
      "alias": "PRESSURERATING",
      "length": 20
     },
     {
      "name": "ADMINISTRATIVEAREA",
      "type": "esriFieldTypeString",
      "alias": "ADMINISTRATIVEAREA",
      "length": 6
     },
     {
      "name": "CIP_ACTIVITY_ID",
      "type": "esriFieldTypeString",
      "alias": "CIP_ACTIVITY_ID",
      "length": 15
     },
     {
      "name": "FIXED_ASSET_NO",
      "type": "esriFieldTypeString",
      "alias": "FIXED_ASSET_NO",
      "length": 12
     },
     {
      "name": "GLOBALID",
      "type": "esriFieldTypeGlobalID",
      "alias": "GLOBALID",
      "length": 38
     },
     {
      "name": "CREATED_USER",
      "type": "esriFieldTypeString",
      "alias": "CREATED_USER",
      "length": 255
     },
     {
      "name": "CREATED_DATE",
      "type": "esriFieldTypeDate",
      "alias": "CREATED_DATE",
      "length": 36
     },
     {
      "name": "LAST_EDITED_USER",
      "type": "esriFieldTypeString",
      "alias": "LAST_EDITED_USER",
      "length": 255
     },
     {
      "name": "LAST_EDITED_DATE",
      "type": "esriFieldTypeDate",
      "alias": "LAST_EDITED_DATE",
      "length": 36
     },
     {
      "name": "MXSITEID",
      "type": "esriFieldTypeString",
      "alias": "MXSITEID",
      "length": 8
     },
     {
      "name": "REPAIR_DISTRICTS",
      "type": "esriFieldTypeString",
      "alias": "REPAIR_DISTRICTS",
      "length": 10
     },
     {
      "name": "HYPERLINK",
      "type": "esriFieldTypeString",
      "alias": "HYPERLINK",
      "length": 255
     },
     {
      "name": "LENGTH",
      "type": "esriFieldTypeDouble",
      "alias": "LENGTH"
     },
     {
      "name": "SHAPE_Length",
      "type": "esriFieldTypeDouble",
      "alias": "SHAPE_Length"
     }
    ],
    "features": [],
    "exceededTransferLimit": false
   },
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "FREQUENCY_OUTPUT",
   "dataType": "GPRecordSet",
   "displayName": "FREQUENCY_OUTPUT",
   "description": "Output of frequency by material and diameter",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "fields": [
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID"
     },
     {
      "name": "FREQUENCY",
      "type": "esriFieldTypeInteger",
      "alias": "FREQUENCY"
     },
     {
      "name": "MATERIAL",
      "type": "esriFieldTypeString",
      "alias": "MATERIAL",
      "length": 20
     },
     {
      "name": "DIAMETER",
      "type": "esriFieldTypeDouble",
      "alias": "DIAMETER"
     },
     {
      "name": "LENGTH",
      "type": "esriFieldTypeDouble",
      "alias": "LENGTH"
     }
    ],
    "features": [],
    "exceededTransferLimit": false
   },
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "ROWS_OUTPUT",
   "dataType": "GPRecordSet",
   "displayName": "ROWS_OUTPUT",
   "description": "Output of rows from asset query",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "fields": [
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID"
     },
     {
      "name": "ENABLED",
      "type": "esriFieldTypeSmallInteger",
      "alias": "ENABLED"
     },
     {
      "name": "EDITOR",
      "type": "esriFieldTypeString",
      "alias": "EDITOR",
      "length": 30
     },
     {
      "name": "CREATION_DATE",
      "type": "esriFieldTypeDate",
      "alias": "CREATION_DATE",
      "length": 8
     },
     {
      "name": "LAST_EDIT",
      "type": "esriFieldTypeDate",
      "alias": "LAST_EDIT",
      "length": 8
     },
     {
      "name": "ASSETID",
      "type": "esriFieldTypeInteger",
      "alias": "ASSETID"
     },
     {
      "name": "FACILITYID",
      "type": "esriFieldTypeString",
      "alias": "FACILITYID",
      "length": 20
     },
     {
      "name": "INSTALLYEAR",
      "type": "esriFieldTypeSmallInteger",
      "alias": "INSTALLYEAR"
     },
     {
      "name": "SERVICEAREA",
      "type": "esriFieldTypeString",
      "alias": "SERVICEAREA",
      "length": 4
     },
     {
      "name": "LIFECYCLESTATUS",
      "type": "esriFieldTypeString",
      "alias": "LIFECYCLESTATUS",
      "length": 20
     },
     {
      "name": "LIFECYCLECHANGEYEAR",
      "type": "esriFieldTypeInteger",
      "alias": "LIFECYCLECHANGEYEAR"
     },
     {
      "name": "SUBTYPE",
      "type": "esriFieldTypeInteger",
      "alias": "Subtype"
     },
     {
      "name": "MATERIAL",
      "type": "esriFieldTypeString",
      "alias": "MATERIAL",
      "length": 20
     },
     {
      "name": "MICROFICHE",
      "type": "esriFieldTypeString",
      "alias": "MICROFICHE",
      "length": 7
     },
     {
      "name": "JOBNUMBER",
      "type": "esriFieldTypeString",
      "alias": "JOBNUMBER",
      "length": 10
     },
     {
      "name": "PROJECT",
      "type": "esriFieldTypeInteger",
      "alias": "PROJECT"
     },
     {
      "name": "BRANCHNUMBER",
      "type": "esriFieldTypeString",
      "alias": "BRANCHNUMBER",
      "length": 7
     },
     {
      "name": "REMARKS",
      "type": "esriFieldTypeString",
      "alias": "REMARKS",
      "length": 50
     },
     {
      "name": "OUTOFSERVICE",
      "type": "esriFieldTypeSmallInteger",
      "alias": "OutOfService"
     },
     {
      "name": "EXTERIORCOATING",
      "type": "esriFieldTypeString",
      "alias": "EXTERIORCOATING",
      "length": 4
     },
     {
      "name": "JOINTTYPE1",
      "type": "esriFieldTypeString",
      "alias": "JOINTTYPE1",
      "length": 20
     },
     {
      "name": "JOINTTYPE2",
      "type": "esriFieldTypeString",
      "alias": "JOINTTYPE2",
      "length": 20
     },
     {
      "name": "INSULATED",
      "type": "esriFieldTypeSmallInteger",
      "alias": "INSULATED"
     },
     {
      "name": "CROSSINGTYPE",
      "type": "esriFieldTypeString",
      "alias": "CROSSINGTYPE",
      "length": 2
     },
     {
      "name": "REHABTYPE",
      "type": "esriFieldTypeString",
      "alias": "REHABTYPE",
      "length": 2
     },
     {
      "name": "REHABYEAR",
      "type": "esriFieldTypeInteger",
      "alias": "REHABYEAR"
     },
     {
      "name": "RESTRAINTPIPETYPE",
      "type": "esriFieldTypeString",
      "alias": "RESTRAINTPIPETYPE",
      "length": 2
     },
     {
      "name": "CORROSIONPOTENTIAL",
      "type": "esriFieldTypeString",
      "alias": "CORROSIONPOTENTIAL",
      "length": 4
     },
     {
      "name": "PLANTNET",
      "type": "esriFieldTypeString",
      "alias": "PlantNet",
      "length": 2
     },
     {
      "name": "PLAN",
      "type": "esriFieldTypeString",
      "alias": "PLAN",
      "length": 20
     },
     {
      "name": "C_FACTOR",
      "type": "esriFieldTypeInteger",
      "alias": "C_FACTOR"
     },
     {
      "name": "MODELDESCRIPTOR",
      "type": "esriFieldTypeString",
      "alias": "MODELDESCRIPTOR",
      "length": 50
     },
     {
      "name": "REDUCIBLE",
      "type": "esriFieldTypeSmallInteger",
      "alias": "REDUCIBLE"
     },
     {
      "name": "DEPTH",
      "type": "esriFieldTypeDouble",
      "alias": "DEPTH"
     },
     {
      "name": "DIAMETER",
      "type": "esriFieldTypeDouble",
      "alias": "DIAMETER"
     },
     {
      "name": "GROUNDSURFACETYPE",
      "type": "esriFieldTypeString",
      "alias": "GROUNDSURFACETYPE",
      "length": 20
     },
     {
      "name": "PRESSURERATING",
      "type": "esriFieldTypeString",
      "alias": "PRESSURERATING",
      "length": 20
     },
     {
      "name": "ADMINISTRATIVEAREA",
      "type": "esriFieldTypeString",
      "alias": "ADMINISTRATIVEAREA",
      "length": 6
     },
     {
      "name": "CIP_ACTIVITY_ID",
      "type": "esriFieldTypeString",
      "alias": "CIP_ACTIVITY_ID",
      "length": 15
     },
     {
      "name": "FIXED_ASSET_NO",
      "type": "esriFieldTypeString",
      "alias": "FIXED_ASSET_NO",
      "length": 12
     },
     {
      "name": "SE_ANNO_CAD_DATA",
      "type": "esriFieldTypeBlob",
      "alias": "SE_ANNO_CAD_DATA"
     },
     {
      "name": "GLOBALID",
      "type": "esriFieldTypeGlobalID",
      "alias": "GLOBALID",
      "length": 38
     },
     {
      "name": "CREATED_USER",
      "type": "esriFieldTypeString",
      "alias": "CREATED_USER",
      "length": 255
     },
     {
      "name": "CREATED_DATE",
      "type": "esriFieldTypeDate",
      "alias": "CREATED_DATE",
      "length": 8
     },
     {
      "name": "LAST_EDITED_USER",
      "type": "esriFieldTypeString",
      "alias": "LAST_EDITED_USER",
      "length": 255
     },
     {
      "name": "LAST_EDITED_DATE",
      "type": "esriFieldTypeDate",
      "alias": "LAST_EDITED_DATE",
      "length": 8
     },
     {
      "name": "MXSITEID",
      "type": "esriFieldTypeString",
      "alias": "MXSITEID",
      "length": 8
     },
     {
      "name": "REPAIR_DISTRICTS",
      "type": "esriFieldTypeString",
      "alias": "REPAIR_DISTRICTS",
      "length": 10
     },
     {
      "name": "HYPERLINK",
      "type": "esriFieldTypeString",
      "alias": "HYPERLINK",
      "length": 255
     },
     {
      "name": "LENGTH",
      "type": "esriFieldTypeDouble",
      "alias": "LENGTH"
     },
     {
      "name": "SHAPE_LEN",
      "type": "esriFieldTypeDouble",
      "alias": "SHAPE.LEN"
     }
    ],
    "features": [],
    "exceededTransferLimit": false
   },
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  }
 ]
}