Name: GIS.DBO.HydrantInspection

Display Field: MaintenanceBy

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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 )
• MaintenanceBy ( type: esriFieldTypeString, alias: MaintenanceBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaintenanceBy , Coded Values: [Water Solutions: Water Solutions] , [TOS Operator: TOS Operator] , [Other: Other] , ...1 more... )
• MaintenanceDate ( type: esriFieldTypeDate, alias: MaintenanceDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MaintenanceDate )
• Caps_and_Chains ( type: esriFieldTypeString, alias: Caps_and_Chains, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Caps_and_Chains , Coded Values: [Yes: Yes] , [No: No] , [Replaced: Replaced] )
• Paint ( type: esriFieldTypeString, alias: Paint, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Paint , Coded Values: [Yes: Yes] , [No: No] , [Needs: Needs] , ...1 more... )
• Flag ( type: esriFieldTypeString, alias: Flag, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Flag , Coded Values: [Yes: Yes] , [No: No] , [Needs: Needs] , ...1 more... )
• Gaskets ( type: esriFieldTypeString, alias: Gaskets, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Gaskets , Coded Values: [Yes: Yes] , [No: No] , [Needs: Needs] , ...1 more... )
• ServiceValve ( type: esriFieldTypeString, alias: ServiceValve, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ServiceValve , Coded Values: [Operable: Operable] , [Inoperable: Inoperable] , [Debris: Debris] , ...2 more... )
• Drain ( type: esriFieldTypeString, alias: Drain, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Drain , Coded Values: [Yes: Yes] , [No: No] , [Needs: Needs] , ...1 more... )
• StaticPressure ( type: esriFieldTypeString, alias: StaticPressure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StaticPressure )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comment )
• RGUID ( type: esriFieldTypeGUID, alias: RGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RGUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• HydrantID ( type: esriFieldTypeString, alias: HydrantID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HydrantID )
• Traffic_Flang ( type: esriFieldTypeString, alias: Traffic_Flang, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Traffic_Flang , Coded Values: [Above Grade: Above Grade] , [Below Grade: Below Grade] , [Broken: Broken] , ...1 more... )
• HydrantMake ( type: esriFieldTypeString, alias: Hydrant Make, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HydrantMake , Coded Values: [Waterous: Waterous] , [Mueller: Mueller] , [Other: Other] )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Condition , Coded Values: [OK: OK] , [Hammers: Hammers] , [Not Inspected: Not Inspected] , ...1 more... )
• Flushed ( type: esriFieldTypeString, alias: Flushed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Flushed , Coded Values: [Yes: Yes] , [No: No] )
• NozzleCondition ( type: esriFieldTypeString, alias: Nozzle Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NozzleCondition , Coded Values: [Leaks Slightly: Leaks Slightly] , [Needs Lead: Needs Lead] , [Good Condition: Good Condition] , ...2 more... )
• Oiled ( type: esriFieldTypeString, alias: Oiled, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Oiled , Coded Values: [Yes: Yes] , [No: No] , [Needs: Needs] , ...1 more... )

Templates:

• Name: GIS.DBO.HydrantInspection
  Description:
  Prototype:
  NozzleCondition: null
  Flushed: null
  MaintenanceBy: null
  MaintenanceDate: null
  Caps_and_Chains: null
  Paint: null
  Flag: null
  Gaskets: null
  ServiceValve: null
  Drain: null
  StaticPressure: null
  Comment: null
  RGUID: null
  Oiled: null
  HydrantID: null
  Traffic_Flang: null
  HydrantMake: null
  Condition: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• wHydrant (0) -- Related To: GIS.DBO.wHydrant (1)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata