Name: AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository

Display Field: StreetName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2500

Supported Query Formats: JSON

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TroyHydrantNumber ( type: esriFieldTypeInteger, alias: TroyHydrantNumber )
• HouseNum ( type: esriFieldTypeSmallInteger, alias: HouseNum )
• StreetName ( type: esriFieldTypeString, alias: StreetName, length: 50 , Coded Values: [1st: 1st St] , [2nd: 2nd St] , [3rd: 3rd St] , ...610 more... )
• InspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• Operable ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [1: Yes] , [2: No] )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 25 , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Mueller Company: Mueller Company] , ...2 more... )
• Static ( type: esriFieldTypeSmallInteger, alias: Static (in psi) )
• Residual ( type: esriFieldTypeSmallInteger, alias: Residual (in psi) )
• Pitot ( type: esriFieldTypeSmallInteger, alias: Pitot (gauge reading) )
• Coefficient ( type: esriFieldTypeDouble, alias: Coefficient )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter (in inches) )
• HydGPM ( type: esriFieldTypeDouble, alias: HydGPM (calculated) )
• HydGPM_20 ( type: esriFieldTypeDouble, alias: HydGPM_20 (calculated) )
• HydGPM_10 ( type: esriFieldTypeDouble, alias: HydGPM_10 (calculated) )
• HydGPM_0 ( type: esriFieldTypeDouble, alias: HydGPM_0 (calculated) )
• Capacity_Class ( type: esriFieldTypeString, alias: Capacity_Class, length: 25 , Coded Values: [CLASS AA: CLASS AA] , [CLASS A: CLASS A] , [CLASS B: CLASS B] , ...1 more... )
• OperatesHard ( type: esriFieldTypeSmallInteger, alias: Operates Hard? , Coded Values: [1: Yes] , [2: No] )
• Zerk ( type: esriFieldTypeString, alias: Zerk, length: 25 , Coded Values: [New: New] , [Ok: Ok] , [Needs Replaced: Needs Replaced] )
• Housing ( type: esriFieldTypeString, alias: Housing, length: 25 , Coded Values: [Ok: Ok] , [Loose: Loose] , [Damaged: Damaged] )
• Cap ( type: esriFieldTypeString, alias: Cap, length: 25 , Coded Values: [Tight: Tight] , [Ok: Ok] , [Loose: Loose] , ...1 more... )
• Greased ( type: esriFieldTypeSmallInteger, alias: Hydrant Greased? , Coded Values: [1: Yes] , [2: No] )
• Paint ( type: esriFieldTypeSmallInteger, alias: Needs Paint? , Coded Values: [1: Yes] , [2: No] )
• OverallCondition ( type: esriFieldTypeString, alias: OverallCondition, length: 25 , Coded Values: [New: New] , [Good: Good] , [Fair: Fair] , ...2 more... )
• Status ( type: esriFieldTypeString, alias: Hydrant Status, length: 25 , Coded Values: [Complete: Complete] , [Incomplete: Incomplete] )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• YearPainted ( type: esriFieldTypeSmallInteger, alias: YearPainted )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• wHydrant (0) -- Related To: wHydrant (0)
• wHydrant (1) -- Related To: wHydrant (0)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata