Name: Inspection

Display Field: HydrantID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 10000

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
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• HydrantID ( type: esriFieldTypeString, alias: Hydrant ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HydrantID )
• TagID ( type: esriFieldTypeString, alias: Tag ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TagID )
• OverallCondition_Structure_ ( type: esriFieldTypeString, alias: Overall Condition - Structure , editable: true, nullable: true, length: 50, defaultValue: null, modelName: OverallCondition_Structure_ , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• OverallCondition_Operation ( type: esriFieldTypeString, alias: Overall Condition - Operation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OverallCondition_Operation , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• ClearBrush ( type: esriFieldTypeString, alias: Clear of Brush or Other Obstructions, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ClearBrush , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• BrushAction ( type: esriFieldTypeString, alias: Clear of Brush - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BrushAction , Coded Values: [Yes: Yes] , [No: No] )
• Flange_6 ( type: esriFieldTypeString, alias: Traffic flange does not exceed 6_ above ground level, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Flange_6 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• FlangeAction ( type: esriFieldTypeString, alias: Flange - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FlangeAction , Coded Values: [Yes: Yes] , [No: No] )
• BreakAway ( type: esriFieldTypeString, alias: Condition of break-away device, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BreakAway , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• BreakAwayAction ( type: esriFieldTypeString, alias: Break-away device - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BreakAwayAction , Coded Values: [Yes: Yes] , [No: No] )
• ListenLeakage ( type: esriFieldTypeString, alias: Listen device check for main valve leakage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ListenLeakage , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• ListenLeakageAction ( type: esriFieldTypeString, alias: Listen device - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ListenLeakageAction , Coded Values: [Yes: Yes] , [No: No] )
• BarrelFreeWet ( type: esriFieldTypeString, alias: Hydrant barrel free of water and/or ice, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BarrelFreeWet , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• BarrelFreeWetAction ( type: esriFieldTypeString, alias: Hydrant barrel - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BarrelFreeWetAction , Coded Values: [Yes: Yes] , [No: No] )
• Caps ( type: esriFieldTypeString, alias: All caps in place, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Caps , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• CapsAction ( type: esriFieldTypeString, alias: All caps in place - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CapsAction , Coded Values: [Yes: Yes] , [No: No] )
• LubricationAction ( type: esriFieldTypeString, alias: Lubrication - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LubricationAction , Coded Values: [Yes: Yes] , [No: No] )
• UpperBarrelLeaks ( type: esriFieldTypeString, alias: Listening device check for upper barrel leaks, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UpperBarrelLeaks , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• UpperBarrelLeaksAction ( type: esriFieldTypeString, alias: Upper barrel leaks - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UpperBarrelLeaksAction , Coded Values: [Yes: Yes] , [No: No] )
• StructuralLeaks ( type: esriFieldTypeString, alias: Structural Leaks, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StructuralLeaks , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• StructuralLeaksAction ( type: esriFieldTypeString, alias: Structural leaks - Corrective Action Taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StructuralLeaksAction , Coded Values: [Yes: Yes] , [No: No] )
• StaticPSI ( type: esriFieldTypeDouble, alias: Record static hydrant pressure (psi), editable: true, nullable: true, defaultValue: null, modelName: StaticPSI )
• FlushOperation ( type: esriFieldTypeString, alias: Flush operation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FlushOperation , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• IsoValveOp ( type: esriFieldTypeString, alias: Isolation Valve Operational, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IsoValveOp , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• IsoValveOpAction ( type: esriFieldTypeString, alias: Iso Valve - corrective action taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IsoValveOpAction , Coded Values: [Yes: Yes] , [No: No] )
• BarrelDrainage ( type: esriFieldTypeString, alias: Hydrant barrel drainage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BarrelDrainage , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• BarrelDrainageAction ( type: esriFieldTypeString, alias: Hydrant Barrel - Corrective action taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BarrelDrainageAction , Coded Values: [Yes: Yes] , [No: No] )
• CapThreads ( type: esriFieldTypeString, alias: Cap threads and lubrication, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CapThreads , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• CapThreadsAction ( type: esriFieldTypeString, alias: Cap threads - corrective action taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CapThreadsAction , Coded Values: [Yes: Yes] , [No: No] )
• HyTagged ( type: esriFieldTypeString, alias: Hydrant Tagged, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HyTagged , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• HyTaggedAction ( type: esriFieldTypeString, alias: Hydrant tagged - Corrective action taken?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HyTaggedAction , Coded Values: [Yes: Yes] , [No: No] )
• WO_Req ( type: esriFieldTypeString, alias: Work Order Required, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WO_Req , Coded Values: [Yes: Yes] , [No: No] , [Immediate Action: Immediate Action] )
• CompletedBy ( type: esriFieldTypeString, alias: Completed By, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CompletedBy )
• DeadEndMainHydrant ( type: esriFieldTypeString, alias: Hydrant on Dead End Main, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DeadEndMainHydrant , Coded Values: [Yes: Yes] , [No: No] )
• Lubrication ( type: esriFieldTypeString, alias: Lubrication, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Lubrication , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• Creator_Date ( type: esriFieldTypeDate, alias: Creator_Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: Creator_Date )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• Editor_Date ( type: esriFieldTypeDate, alias: Editor_Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: Editor_Date )
• WOID ( type: esriFieldTypeString, alias: WOID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WOID )
• Exercised ( type: esriFieldTypeString, alias: Exercised, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintEvent1 , Coded Values: [Yes: Yes] , [No: No] )
• Flagged ( type: esriFieldTypeString, alias: Flagged, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintEvent2 , Coded Values: [Yes: Yes] , [No: No] )
• Inspected ( type: esriFieldTypeString, alias: Inspected, editable: true, nullable: true, length: 50, defaultValue: Yes, modelName: MaintEvent3 , Coded Values: [Yes: Yes] , [No: No] )
• Painted ( type: esriFieldTypeString, alias: Painted, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintEvent4 , Coded Values: [Yes: Yes] , [No: No] )
• Raised ( type: esriFieldTypeString, alias: Raised, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintEvent5 , Coded Values: [Yes: Yes] , [No: No] )
• Repaired ( type: esriFieldTypeString, alias: Repaired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintEvent6 , Coded Values: [Yes: Yes] , [No: No] )
• Tagged ( type: esriFieldTypeString, alias: Tagged, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintEvent7 , Coded Values: [Yes: Yes] , [No: No] )
• Winterized ( type: esriFieldTypeString, alias: Winterized, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintEvent8 , Coded Values: [Yes: Yes] , [No: No] )
• Greased ( type: esriFieldTypeString, alias: Greased, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintEvent9 , Coded Values: [Yes: Yes] , [No: No] )
• QAQCComments ( type: esriFieldTypeString, alias: QAQCComments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: QAQCComments )
• QAQC_By ( type: esriFieldTypeString, alias: QAQC_By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: QAQC_By )
• QAQC_Date ( type: esriFieldTypeDate, alias: QAQC_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: QAQC_Date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Inspection
  Description:
  Prototype:
  QAQC_Date: null
  QAQC_By: null
  HydrantID: null
  TagID: null
  OverallCondition_Structure_: null
  OverallCondition_Operation: null
  ClearBrush: null
  BrushAction: null
  Flange_6: null
  FlangeAction: null
  BreakAway: null
  BreakAwayAction: null
  ListenLeakage: null
  ListenLeakageAction: null
  BarrelFreeWet: null
  BarrelFreeWetAction: null
  Caps: null
  CapsAction: null
  LubricationAction: null
  UpperBarrelLeaks: null
  UpperBarrelLeaksAction: null
  StructuralLeaks: null
  StructuralLeaksAction: null
  StaticPSI: null
  FlushOperation: null
  IsoValveOp: null
  IsoValveOpAction: null
  BarrelDrainage: null
  BarrelDrainageAction: null
  CapThreads: null
  CapThreadsAction: null
  HyTagged: null
  HyTaggedAction: null
  WO_Req: null
  CompletedBy: null
  DeadEndMainHydrant: null
  Lubrication: null
  Comments: null
  QAQCComments: null
  Greased: null
  Winterized: null
  Tagged: null
  WOID: null
  Exercised: null
  Flagged: null
  Inspected: Yes
  Painted: null
  Raised: null
  Repaired: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Hydrants (0) -- Related To: Hydrants (0)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: Creator_Date
• Creator Field: Creator
• Edit Date Field: Editor_Date
• Editor Field: Editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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