Name: wHydrantActivity

Display Field: ENTNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLESTATUS, length: 20 , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...4 more... )
• INSTALLDATE ( type: esriFieldTypeSmallInteger, alias: INSTALLDATE )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID )
• HYDRANT_ID ( type: esriFieldTypeDouble, alias: HYDRANT_ID )
• ENTID ( type: esriFieldTypeDouble, alias: ENTID )
• ENTNAME ( type: esriFieldTypeString, alias: ENTNAME, length: 20 )
• ROW_ID ( type: esriFieldTypeString, alias: ROW_ID, length: 20 )
• SEGMENT_ID ( type: esriFieldTypeInteger, alias: SEGMENT_ID )
• VAIL_ID ( type: esriFieldTypeInteger, alias: VAIL_ID )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 80 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 30 )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, length: 50 )
• POSITION ( type: esriFieldTypeString, alias: POSITION, length: 20 )
• MAIN_DIAMETER ( type: esriFieldTypeSmallInteger, alias: MAIN_DIAMETER )
• HYDRANT_MAKE ( type: esriFieldTypeString, alias: HYDRANT_MAKE, length: 20 , Coded Values: [AMERD: AMERD] , [COREY: COREY] , [CLOW: CLOW] , ...18 more... )
• DISTANCE_HYD_TO_VALVE ( type: esriFieldTypeDouble, alias: DISTANCE_HYD_TO_VALVE )
• NUMBER_OF_OUTLETS ( type: esriFieldTypeSmallInteger, alias: NUMBER_OF_OUTLETS )
• STORTZ_CONNECTION ( type: esriFieldTypeString, alias: STORTZ_CONNECTION, length: 20 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• DRAINHOLES_CAPPED ( type: esriFieldTypeString, alias: DRAINHOLES_CAPPED, length: 20 , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• BARREL_TYPE ( type: esriFieldTypeString, alias: BARREL_TYPE, length: 20 )
• ATLAS_TILE ( type: esriFieldTypeString, alias: ATLAS_TILE, length: 10 )
• MAINTENANCE_AREA ( type: esriFieldTypeSmallInteger, alias: MAINTENANCE_AREA )
• HYDRANT_FLOW ( type: esriFieldTypeString, alias: HYDRANT_FLOW, length: 50 )
• COLOUR_CODE ( type: esriFieldTypeString, alias: COLOUR_CODE, length: 20 , Coded Values: [Blue: Blue] , [Green: Green] , [Orange: Orange] , ...1 more... )
• PRESSURE_ZONE ( type: esriFieldTypeString, alias: PRESSURE_ZONE, length: 20 )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, length: 80 )
• ASSUMPTIONSTATUS ( type: esriFieldTypeString, alias: ASSUMPTIONSTATUS, length: 30 )
• STARTOFMAINTDATE ( type: esriFieldTypeDate, alias: STARTOFMAINTDATE, length: 8 )
• FINALACCEPTANCEDATE ( type: esriFieldTypeDate, alias: FINALACCEPTANCEDATE, length: 8 )
• REMOVED_DATE ( type: esriFieldTypeDate, alias: REMOVED_DATE, length: 8 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 50 )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, length: 8 )
• CREATE_USER ( type: esriFieldTypeString, alias: CREATE_USER, length: 16 )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, length: 8 )
• UPDATE_USER ( type: esriFieldTypeString, alias: UPDATE_USER, length: 16 )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, length: 20 )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LastActivity, length: 4 , Coded Values: [INST: Installation] , [UPDT: Update Info] , [INSP: Inspection] , ...5 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, length: 8 )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, length: 5 )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, length: 30 )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, length: 30 )
• OPERATIONALSTATUS ( type: esriFieldTypeString, alias: OperationalStatus, length: 5 , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...3 more... )
• FLOWGPM ( type: esriFieldTypeSmallInteger, alias: FLOWGPM )
• FLOW20 ( type: esriFieldTypeSmallInteger, alias: FLOW20 )
• STATICPSI ( type: esriFieldTypeSmallInteger, alias: SATICPSI )
• RESIDPSI ( type: esriFieldTypeSmallInteger, alias: RESIDPSI )
• PITOT ( type: esriFieldTypeSmallInteger, alias: PITOT )
• FLOWMINS ( type: esriFieldTypeString, alias: FLOWMINS, length: 7 )
• GALUSED ( type: esriFieldTypeInteger, alias: GALUSED )
• ISOVALVE ( type: esriFieldTypeString, alias: IsoValve, length: 4 , Coded Values: [Yes: Yes] , [No: No] )
• OPERATIONCOMMENTS ( type: esriFieldTypeString, alias: OPERATIONCOMMENTS, length: 200 , Coded Values: [BranchValveNS: Branch valve needs service] , [Broken Barrel: Broken Barrel] , [Broken Stem: Broken Stem] , ...6 more... )
• HYDRANTREPAIRS ( type: esriFieldTypeString, alias: HYDRANTREPAIRS, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• PITOT2 ( type: esriFieldTypeSmallInteger, alias: PITOT2 )
• FLOWGPM2 ( type: esriFieldTypeSmallInteger, alias: FLOWGPM2 )
• RESIDUAL_HYDRANT ( type: esriFieldTypeString, alias: RESIDUAL_HYDRANT, length: 20 )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, length: 1000 )
• REPAIRS_NEEDED ( type: esriFieldTypeString, alias: REPAIRS_NEEDED, length: 50 , Coded Values: [Major: Major] , [Minor: Minor] )
• HYDRANT_DRAINAGE ( type: esriFieldTypeString, alias: HYDRANT_DRAINAGE, length: 20 , Coded Values: [Yes: Yes] , [No: No] )
• HYDRANT_OPERATION_NUT ( type: esriFieldTypeString, alias: HYDRANT_OPERATION_NUT, length: 20 , Coded Values: [needs service: needs service] , [good condition: good condition] )
• HYDRANT_PAINTING ( type: esriFieldTypeString, alias: HYDRANT_PAINTING, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• GALUSED1 ( type: esriFieldTypeString, alias: GALUSED1, length: 20 )
• TESTID ( type: esriFieldTypeSmallInteger, alias: TESTID )
• MAXIMO_WO ( type: esriFieldTypeString, alias: MAXIMO_WO, length: 10 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata