Name: System Valve Inspection

Display Field: INSSTART

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 533fa008e28341eeb7cbe80d8c8fd577

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• SDELOADER.Infrastructure_wSystemValveInspection.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SDELOADER.Infrastructure_wSystemValveInspection.INSSTART ( type: esriFieldTypeDate, alias: Start DateTime, length: 8 )
• SDELOADER.Infrastructure_wSystemValveInspection.VALVECOND ( type: esriFieldTypeString, alias: Valve Condition, length: 50 , Coded Values: [New: New] , [Good: Good] , [Fair: Fair] , ...2 more... )
• SDELOADER.Infrastructure_wSystemValveInspection.TURNHARD ( type: esriFieldTypeSmallInteger, alias: Hard to Turn , Coded Values: [0: False] , [1: True] )
• SDELOADER.Infrastructure_wSystemValveInspection.OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [0: False] , [1: True] )
• SDELOADER.Infrastructure_wSystemValveInspection.PAVED ( type: esriFieldTypeSmallInteger, alias: Paved Over , Coded Values: [0: False] , [1: True] )
• SDELOADER.Infrastructure_wSystemValveInspection.CORRODED ( type: esriFieldTypeSmallInteger, alias: Corroded , Coded Values: [0: False] , [1: True] )
• SDELOADER.Infrastructure_wSystemValveInspection.GSURFACE ( type: esriFieldTypeString, alias: Ground Surface, length: 50 , Coded Values: [Asphalt: Asphalt] , [Brick: Brick] , [Concrete: Concrete] , ...5 more... )
• SDELOADER.Infrastructure_wSystemValveInspection.FINTORQUE ( type: esriFieldTypeInteger, alias: Final Torque (Ft Pounds) )
• SDELOADER.Infrastructure_wSystemValveInspection.DEPTHTONUT ( type: esriFieldTypeDouble, alias: Depth To Nut (Feet) )
• SDELOADER.Infrastructure_wSystemValveInspection.MAINTNEED ( type: esriFieldTypeString, alias: Maintenance Needed, length: 255 )
• SDELOADER.Infrastructure_wSystemValveInspection.NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
• SDELOADER.Infrastructure_wSystemValveInspection.INSEND ( type: esriFieldTypeDate, alias: End DateTime, length: 8 )
• SDELOADER.Infrastructure_wSystemValveInspection.WORKKEY ( type: esriFieldTypeString, alias: Workorder ID, length: 50 )
• SDELOADER.Infrastructure_wSystemValveInspection.INSPECTID ( type: esriFieldTypeString, alias: Inspection ID, length: 50 )
• SDELOADER.Infrastructure_wSystemValveInspection.FACILITYKEY ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
• SDELOADER.Infrastructure_wSystemValveInspection.INSPECTOR ( type: esriFieldTypeString, alias: Inspection User, length: 50 )
• SDELOADER.Infrastructure_wSystemValveInspection.INSSTATUS ( type: esriFieldTypeString, alias: Inspection Status, length: 20 , Coded Values: [Unassigned: Unassigned] , [Assigned: Assigned] , [In Progress: In Progress] , ...1 more... )
• SDELOADER.Infrastructure_wSystemValveInspection.ROTATION ( type: esriFieldTypeDouble, alias: Rotation )
• SDELOADER.Infrastructure_wSystemValveInspection.LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• SDELOADER.Infrastructure_wSystemValveInspection.LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• SDELOADER.Infrastructure_wSystemValveInspection.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SDELOADER.Infrastructure_wSystemValveInspection.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• SDELOADER.Infrastructure_wSystemValveInspection.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• SDELOADER.Infrastructure_wSystemValveInspection.last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• SDELOADER.Infrastructure_wSystemValveInspection.last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• SDELOADER.Infrastructure_wSystemValveInspection.VALVEFUNCTION ( type: esriFieldTypeString, alias: Valve Function, length: 50 , Coded Values: [ML: Main Line] , [FS: Fire Service] , [HYD: Hydrant] )
• SDELOADER.Infrastructure_wSystemValveInspection.BOXCOND ( type: esriFieldTypeString, alias: Valve Box Condition, length: 50 , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...1 more... )
• SDELOADER.Infrastructure_wSystemValveInspection.DIAMETER ( type: esriFieldTypeDouble, alias: Valve Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...32 more... )
• SDELOADER.Infrastructure_wSystemValveInspection.LOCATION ( type: esriFieldTypeString, alias: Location Description, length: 255 )
• SDELOADER.Infrastructure_wSystemValveInspection.VALVEFOUNDOP ( type: esriFieldTypeString, alias: Valve Discovered Open?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SDELOADER.Infrastructure_wSystemValveInspection.TURNSTOCLOSE ( type: esriFieldTypeDouble, alias: Turns to Close )
• SDELOADER.Infrastructure_wSystemValveInspection.VALVEDIRECTION ( type: esriFieldTypeString, alias: Direction to Close, length: 50 , Coded Values: [RHV: Right Hand To Close] , [LHV: Left Hand to Close] , [UNK: Unknown] )
• SDELOADER.Infrastructure_wSystemValveInspection.ValveShutdown ( type: esriFieldTypeString, alias: Does valve get positive shutdown?, length: 50 , Coded Values: [1: Good - Valve shuts down successfully] , [2: Fair - Valve partially shuts down] , [3: Poor - Valve does not shut down, needs attention] , ...1 more... )
• SDELOADER.Infrastructure_wSystemValveInspection.ASSETID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
• SDELOADER.Infrastructure_wSystemValveInspection.Valve_GlobalID ( type: esriFieldTypeGUID, alias: Valve_GlobalID, length: 38 )
• SDELOADER.Infrastructure_wSystemValveInspection.NUTTYPE ( type: esriFieldTypeString, alias: NUTTYPE, length: 255 , Coded Values: [2: 2" Square Nut] , [WHEEL: Wheel Valve] , [Other: Other (Noted elsewhere)] )
• SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.ATTACHMENTID ( type: esriFieldTypeInteger, alias: ATTACHMENTID )
• SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
• SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
• SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
• SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.DATA ( type: esriFieldTypeBlob, alias: DATA )
• SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.GLOBALID ( type: esriFieldTypeGUID, alias: GLOBALID, length: 38 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata