Name: ValveActivity

Display Field: ENTNAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...4 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• VALVE_FUNCTION ( type: esriFieldTypeString, alias: VALVE_FUNCTION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_FUNCTION , Coded Values: [Control Valve: Control Valve] , [Flushing Valve: Flushing Valve] , [Hydrant Valve: Hydrant Valve] , ...3 more... )
• VALVE_TYPE ( type: esriFieldTypeString, alias: VALVE_TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVE_TYPE , Coded Values: [Butterfly Valve: Butterfly Valve] , [Curb Stop: Curb Stop] , [Gate Valve: Gate Valve] , ...9 more... )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 6, modelName: Subtype )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID, editable: true, nullable: true, defaultValue: null, modelName: ASSET_ID )
• ENTID ( type: esriFieldTypeString, alias: ENTID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ENTID )
• ENTNAME ( type: esriFieldTypeString, alias: ENTNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ENTNAME )
• ROW_ID ( type: esriFieldTypeString, alias: ROW_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ROW_ID )
• SEGMENT_ID ( type: esriFieldTypeInteger, alias: SEGMENT_ID, editable: true, nullable: true, defaultValue: null, modelName: SEGMENT_ID )
• VAIL_ID ( type: esriFieldTypeInteger, alias: VAIL_ID, editable: true, nullable: true, defaultValue: null, modelName: VAIL_ID )
• CIVIC_ADDRESS ( type: esriFieldTypeString, alias: CIVIC_ADDRESS, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CIVIC_ADDRESS )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OWNER )
• VALVE_MAKE ( type: esriFieldTypeString, alias: VALVE_MAKE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_MAKE )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASBUILTNUMBER )
• POSITION ( type: esriFieldTypeString, alias: POSITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POSITION )
• DIAMETER ( type: esriFieldTypeSmallInteger, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCATIONDESCRIPTION )
• ASSUMPTIONSTATUS ( type: esriFieldTypeString, alias: ASSUMPTIONSTATUS, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ASSUMPTIONSTATUS )
• STARTOFMAINTDATE ( type: esriFieldTypeDate, alias: STARTOFMAINTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: STARTOFMAINTDATE )
• FINALACCEPTANCEDATE ( type: esriFieldTypeDate, alias: FINALACCEPTANCEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FINALACCEPTANCEDATE )
• REMOVED_DATE ( type: esriFieldTypeDate, alias: REMOVED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REMOVED_DATE )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: NormallyOpen, editable: true, nullable: true, defaultValue: 1, modelName: NormallyOpen , Coded Values: [0: False] , [1: True] )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: null, modelName: Operable , Coded Values: [0: False] , [1: True] )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOTES )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• SURFACE_ELEVATION ( type: esriFieldTypeDouble, alias: SURFACE_ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: SURFACE_ELEVATION )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATE_DATE )
• CREATE_USER ( type: esriFieldTypeString, alias: CREATE_USER, editable: true, nullable: true, length: 16, defaultValue: null, modelName: CREATE_USER )
• UPDATE_DATE ( type: esriFieldTypeDate, alias: UPDATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATE_DATE )
• UPDATE_USER ( type: esriFieldTypeString, alias: UPDATE_USER, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UPDATE_USER )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACTIVITYID )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LastActivity, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LastActivity , Coded Values: [INST: Installation] , [UPDT: Update Info] , [EXE: Exercise Valve] , ...6 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTAMP )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPTIME )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMPUTERNAME )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPERATEDBY )
• OPERATIONALSTATUS ( type: esriFieldTypeString, alias: OperationalStatus, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OperationalStatus , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...3 more... )
• VALVEFUNCTION ( type: esriFieldTypeString, alias: ValveFunction, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ValveFunction , Coded Values: [DV: Distribution Valve] , [HV: Hydrant Valve] , [DS: Domestic Service] , ...7 more... )
• TURNTOOPERATE ( type: esriFieldTypeDouble, alias: TURNTOOPERATE, editable: true, nullable: true, defaultValue: null, modelName: TURNTOOPERATE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• GPSX ( type: esriFieldTypeDouble, alias: GPSX, editable: true, nullable: true, defaultValue: null, modelName: GPSX )
• GPSY ( type: esriFieldTypeDouble, alias: GPSY, editable: true, nullable: true, defaultValue: null, modelName: GPSY )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LINKEDDOCUMENTS )
• CREW ( type: esriFieldTypeString, alias: CREW, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CREW )
• ASSEMBLYTYPE ( type: esriFieldTypeString, alias: AssemblyType, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AssemblyType , Coded Values: [AIR: Air Valve] , [BLV: Ball valve] , [BFV: Butterfly Valve] , ...11 more... )
• OPERATIONALCOMMENTS ( type: esriFieldTypeString, alias: Operational Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: OperationalComments )
• CLOCKWISETOCLOSE ( type: esriFieldTypeString, alias: ClockwiseToClose, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ClockwiseToClose , Coded Values: [Yes: Yes] , [No: No] )
• UPDATEGPS ( type: esriFieldTypeString, alias: UpdateGps, editable: true, nullable: true, length: 4, defaultValue: null, modelName: UpdateGps , Coded Values: [Yes: Yes] , [No: No] )
• MANUALTURN ( type: esriFieldTypeString, alias: MANUALTURN, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MANUALTURN , Coded Values: [Y: Y] , [N: N] )
• HIGHTORQUE ( type: esriFieldTypeSmallInteger, alias: HIGHTORQUE, editable: true, nullable: true, defaultValue: null, modelName: HIGHTORQUE )
• TORQUEDATA ( type: esriFieldTypeString, alias: TORQUEDATA, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TORQUEDATA )
• GLAND_LEAK ( type: esriFieldTypeString, alias: GLAND_LEAK, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GLAND_LEAK , Coded Values: [No gland leak: No gland leak] , [Steady: Steady] , [Stops when jammed: Stops when jammed] , ...1 more... )
• OPERATING_NUT ( type: esriFieldTypeString, alias: OPERATING_NUT, editable: true, nullable: true, length: 16, defaultValue: null, modelName: OPERATING_NUT , Coded Values: [Good Condition: Good Condition] , [Broken Off: Broken Off] , [Rounded: Rounded] , ...2 more... )
• VALVE_BROKEN ( type: esriFieldTypeString, alias: VALVE_BROKEN, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_BROKEN , Coded Values: [Good Condition: Good Condition] , [Valve Broken Open: Valve Broken Open] , [Valve Broken Closed: Valve Broken Closed] , ...3 more... )
• VALVE_BOX ( type: esriFieldTypeString, alias: VALVE_BOX, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_BOX , Coded Values: [Good Condition: Good Condition] , [Valve Box Broken: Valve Box Broken] , [Valve Box Shifted: Valve Box Shifted] , ...6 more... )
• VALVE_TURNS ( type: esriFieldTypeString, alias: VALVE_TURNS, editable: true, nullable: true, length: 12, defaultValue: null, modelName: VALVE_TURNS , Coded Values: [Normal: Normal] , [Above Normal: Above Normal] , [Below Normal: Below Normal] , ...1 more... )
• VALVE_PRIORITY ( type: esriFieldTypeString, alias: VALVE_PRIORITY, editable: true, nullable: true, length: 12, defaultValue: null, modelName: VALVE_PRIORITY , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] , ...2 more... )
• METHOD_OF_REPAIR ( type: esriFieldTypeString, alias: METHOD_OF_REPAIR, editable: true, nullable: true, length: 16, defaultValue: null, modelName: METHOD_OF_REPAIR , Coded Values: [by hand: by hand] , [by excavation: by excavation] , [by vac dig: by vac dig] )
• GLAND_LEAK_REPAIR ( type: esriFieldTypeString, alias: GLAND_LEAK_REPAIR, editable: true, nullable: true, length: 3, defaultValue: null, modelName: GLAND_LEAK_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• OPERATING_NUT_REPAIR ( type: esriFieldTypeString, alias: OPERATING_NUT_REPAIR, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OPERATING_NUT_REPAIR , Coded Values: [Yes: Yes] , [No: No] )
• VALVE_BOX_REPAIR ( type: esriFieldTypeString, alias: VALVE_BOX_REPAIR, editable: true, nullable: true, length: 16, defaultValue: null, modelName: VALVE_BOX_REPAIR , Coded Values: [VB raised: VB raised] , [VB lowered: VB lowered] , [VB repaired: VB repaired] )
• MAXIMO_WO ( type: esriFieldTypeString, alias: MAXIMO_WO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAXIMO_WO )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• VALVELOC_GUID ( type: esriFieldTypeGUID, alias: VALVELOC_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: VALVELOC_GUID )

Templates:

• Name: ValveActivity
  Description:
  Prototype:
  VALVELOC_GUID: null
  MAXIMO_WO: null
  LIFECYCLESTATUS: Active
  INSTALLDATE: null
  VALVE_FUNCTION: null
  VALVE_TYPE: null
  SUBTYPE: 6
  ASSET_ID: null
  ENTID: null
  ENTNAME: null
  ROW_ID: null
  SEGMENT_ID: null
  VAIL_ID: null
  CIVIC_ADDRESS: null
  OWNER: null
  VALVE_MAKE: null
  ASBUILTNUMBER: null
  POSITION: null
  DIAMETER: null
  LOCATIONDESCRIPTION: null
  ASSUMPTIONSTATUS: null
  STARTOFMAINTDATE: null
  FINALACCEPTANCEDATE: null
  REMOVED_DATE: null
  NORMALLYOPEN: 1
  OPERABLE: null
  ROTATION: null
  NOTES: null
  ANCILLARYROLE: null
  ENABLED: 1
  SURFACE_ELEVATION: null
  CREATE_DATE: null
  CREATE_USER: null
  UPDATE_DATE: null
  UPDATE_USER: null
  ACTIVITYID: null
  LASTACTIVITY: null
  DATESTAMP: null
  OPTIME: null
  COMPUTERNAME: null
  OPERATEDBY: null
  OPERATIONALSTATUS: null
  VALVEFUNCTION: null
  TURNTOOPERATE: null
  DEPTH: null
  GPSX: null
  GPSY: null
  LINKEDDOCUMENTS: null
  CREW: null
  ASSEMBLYTYPE: null
  OPERATIONALCOMMENTS: null
  CLOCKWISETOCLOSE: null
  UPDATEGPS: null
  MANUALTURN: null
  HIGHTORQUE: null
  TORQUEDATA: null
  GLAND_LEAK: null
  OPERATING_NUT: null
  VALVE_BROKEN: null
  VALVE_BOX: null
  VALVE_TURNS: null
  VALVE_PRIORITY: null
  METHOD_OF_REPAIR: null
  GLAND_LEAK_REPAIR: null
  OPERATING_NUT_REPAIR: null
  VALVE_BOX_REPAIR: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata