Name: AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository

Display Field: StreetName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2500

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository
  Description:
  Prototype:
  YearPainted: null
  Notes: null
  TroyHydrantNumber: null
  HouseNum: null
  StreetName: null
  InspectionDate: null
  Operable: 1
  Manufacturer: American Darling
  Static: null
  Residual: null
  Pitot: null
  Coefficient: 0.9
  Diameter: 2.5
  HydGPM: null
  HydGPM_20: null
  HydGPM_10: null
  HydGPM_0: null
  Capacity_Class: null
  OperatesHard: null
  Zerk: null
  Housing: null
  Cap: null
  Greased: null
  Paint: null
  OverallCondition: null
  Status: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

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

Supports Coordinates Quantization: false

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