Display Name: assetCalcByExpression

Description: user selects JOBNO, FIXEDASSETID, or WWACCOUNT to locate associated main assets.

Category:

Help URL: https://arcgis.cincinnati-oh.gov/arcgis/rest/directories/arcgisoutput/GPservices/assetCalculator_GPServer/GPservices_assetCalculator/assetCalc.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: value

Data Type: GPString
Display Name value
Description: value
Direction: esriGPParameterDirectionInput
Dependency:
Default Value: WSL-2499
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: queryType

Data Type: GPString
Display Name queryType
Description: type of query
Direction: esriGPParameterDirectionInput
Dependency:
Default Value: JOBNO
Parameter Type: esriGPParameterTypeRequired
Category:
Choice List: [ FIXEDASSETNO, WWACCOUNT, JOBNO ]

Parameter: FIXED_ASSET_LAYER

Data Type: GPFeatureRecordSetLayer
Display Name FIXED_ASSET_LAYER
Description: Output layer
Direction: esriGPParameterDirectionOutput
Dependency:
Default Value:
Geometry Type: esriGeometryPolyline
HasZ: false
HasM: false
Spatial Reference: 102723  (3735)

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED )
• EDITOR ( type: esriFieldTypeString, alias: EDITOR, length: 30 )
• CREATION_DATE ( type: esriFieldTypeDate, alias: CREATION_DATE, length: 36 )
• LAST_EDIT ( type: esriFieldTypeDate, alias: LAST_EDIT, length: 36 )
• ASSETID ( type: esriFieldTypeInteger, alias: ASSETID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• INSTALLYEAR ( type: esriFieldTypeSmallInteger, alias: INSTALLYEAR )
• SERVICEAREA ( type: esriFieldTypeString, alias: SERVICEAREA, length: 4 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLESTATUS, length: 20 )
• LIFECYCLECHANGEYEAR ( type: esriFieldTypeInteger, alias: LIFECYCLECHANGEYEAR )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 20 )
• MICROFICHE ( type: esriFieldTypeString, alias: MICROFICHE, length: 7 )
• JOBNUMBER ( type: esriFieldTypeString, alias: JOBNUMBER, length: 10 )
• PROJECT ( type: esriFieldTypeInteger, alias: PROJECT )
• BRANCHNUMBER ( type: esriFieldTypeString, alias: BRANCHNUMBER, length: 7 )
• REMARKS ( type: esriFieldTypeString, alias: REMARKS, length: 50 )
• OUTOFSERVICE ( type: esriFieldTypeSmallInteger, alias: OutOfService )
• EXTERIORCOATING ( type: esriFieldTypeString, alias: EXTERIORCOATING, length: 4 )
• JOINTTYPE1 ( type: esriFieldTypeString, alias: JOINTTYPE1, length: 20 )
• JOINTTYPE2 ( type: esriFieldTypeString, alias: JOINTTYPE2, length: 20 )
• INSULATED ( type: esriFieldTypeSmallInteger, alias: INSULATED )
• CROSSINGTYPE ( type: esriFieldTypeString, alias: CROSSINGTYPE, length: 2 )
• REHABTYPE ( type: esriFieldTypeString, alias: REHABTYPE, length: 2 )
• REHABYEAR ( type: esriFieldTypeInteger, alias: REHABYEAR )
• RESTRAINTPIPETYPE ( type: esriFieldTypeString, alias: RESTRAINTPIPETYPE, length: 2 )
• CORROSIONPOTENTIAL ( type: esriFieldTypeString, alias: CORROSIONPOTENTIAL, length: 4 )
• PLANTNET ( type: esriFieldTypeString, alias: PlantNet, length: 2 )
• PLAN ( type: esriFieldTypeString, alias: PLAN, length: 20 )
• C_FACTOR ( type: esriFieldTypeInteger, alias: C_FACTOR )
• MODELDESCRIPTOR ( type: esriFieldTypeString, alias: MODELDESCRIPTOR, length: 50 )
• REDUCIBLE ( type: esriFieldTypeSmallInteger, alias: REDUCIBLE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER )
• GROUNDSURFACETYPE ( type: esriFieldTypeString, alias: GROUNDSURFACETYPE, length: 20 )
• PRESSURERATING ( type: esriFieldTypeString, alias: PRESSURERATING, length: 20 )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: ADMINISTRATIVEAREA, length: 6 )
• CIP_ACTIVITY_ID ( type: esriFieldTypeString, alias: CIP_ACTIVITY_ID, length: 15 )
• FIXED_ASSET_NO ( type: esriFieldTypeString, alias: FIXED_ASSET_NO, length: 12 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 36 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 36 )
• MXSITEID ( type: esriFieldTypeString, alias: MXSITEID, length: 8 )
• REPAIR_DISTRICTS ( type: esriFieldTypeString, alias: REPAIR_DISTRICTS, length: 10 )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, length: 255 )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• SHAPE_Length ( type: esriFieldTypeDouble, alias: SHAPE_Length )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: FREQUENCY_OUTPUT

Data Type: GPRecordSet
Display Name FREQUENCY_OUTPUT
Description: Output of frequency by material and diameter
Direction: esriGPParameterDirectionOutput
Dependency:
Default Value:
Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FREQUENCY ( type: esriFieldTypeInteger, alias: FREQUENCY )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 20 )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: ROWS_OUTPUT

Data Type: GPRecordSet
Display Name ROWS_OUTPUT
Description: Output of rows from asset query
Direction: esriGPParameterDirectionOutput
Dependency:
Default Value:
Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED )
• EDITOR ( type: esriFieldTypeString, alias: EDITOR, length: 30 )
• CREATION_DATE ( type: esriFieldTypeDate, alias: CREATION_DATE, length: 8 )
• LAST_EDIT ( type: esriFieldTypeDate, alias: LAST_EDIT, length: 8 )
• ASSETID ( type: esriFieldTypeInteger, alias: ASSETID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, length: 20 )
• INSTALLYEAR ( type: esriFieldTypeSmallInteger, alias: INSTALLYEAR )
• SERVICEAREA ( type: esriFieldTypeString, alias: SERVICEAREA, length: 4 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLESTATUS, length: 20 )
• LIFECYCLECHANGEYEAR ( type: esriFieldTypeInteger, alias: LIFECYCLECHANGEYEAR )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 20 )
• MICROFICHE ( type: esriFieldTypeString, alias: MICROFICHE, length: 7 )
• JOBNUMBER ( type: esriFieldTypeString, alias: JOBNUMBER, length: 10 )
• PROJECT ( type: esriFieldTypeInteger, alias: PROJECT )
• BRANCHNUMBER ( type: esriFieldTypeString, alias: BRANCHNUMBER, length: 7 )
• REMARKS ( type: esriFieldTypeString, alias: REMARKS, length: 50 )
• OUTOFSERVICE ( type: esriFieldTypeSmallInteger, alias: OutOfService )
• EXTERIORCOATING ( type: esriFieldTypeString, alias: EXTERIORCOATING, length: 4 )
• JOINTTYPE1 ( type: esriFieldTypeString, alias: JOINTTYPE1, length: 20 )
• JOINTTYPE2 ( type: esriFieldTypeString, alias: JOINTTYPE2, length: 20 )
• INSULATED ( type: esriFieldTypeSmallInteger, alias: INSULATED )
• CROSSINGTYPE ( type: esriFieldTypeString, alias: CROSSINGTYPE, length: 2 )
• REHABTYPE ( type: esriFieldTypeString, alias: REHABTYPE, length: 2 )
• REHABYEAR ( type: esriFieldTypeInteger, alias: REHABYEAR )
• RESTRAINTPIPETYPE ( type: esriFieldTypeString, alias: RESTRAINTPIPETYPE, length: 2 )
• CORROSIONPOTENTIAL ( type: esriFieldTypeString, alias: CORROSIONPOTENTIAL, length: 4 )
• PLANTNET ( type: esriFieldTypeString, alias: PlantNet, length: 2 )
• PLAN ( type: esriFieldTypeString, alias: PLAN, length: 20 )
• C_FACTOR ( type: esriFieldTypeInteger, alias: C_FACTOR )
• MODELDESCRIPTOR ( type: esriFieldTypeString, alias: MODELDESCRIPTOR, length: 50 )
• REDUCIBLE ( type: esriFieldTypeSmallInteger, alias: REDUCIBLE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER )
• GROUNDSURFACETYPE ( type: esriFieldTypeString, alias: GROUNDSURFACETYPE, length: 20 )
• PRESSURERATING ( type: esriFieldTypeString, alias: PRESSURERATING, length: 20 )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: ADMINISTRATIVEAREA, length: 6 )
• CIP_ACTIVITY_ID ( type: esriFieldTypeString, alias: CIP_ACTIVITY_ID, length: 15 )
• FIXED_ASSET_NO ( type: esriFieldTypeString, alias: FIXED_ASSET_NO, length: 12 )
• SE_ANNO_CAD_DATA ( type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• MXSITEID ( type: esriFieldTypeString, alias: MXSITEID, length: 8 )
• REPAIR_DISTRICTS ( type: esriFieldTypeString, alias: REPAIR_DISTRICTS, length: 10 )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, length: 255 )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• SHAPE_LEN ( type: esriFieldTypeDouble, alias: SHAPE.LEN )
Features: None.



Parameter Type: esriGPParameterTypeRequired
Category:

Supported Operations:   Submit Job