Name: SDE.DBO.wHydrant_Inspections

Display Field: OBJECTID_1

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

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 )
• OBJECTID_1 ( type: esriFieldTypeString, alias: OBJECTID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OBJECTID_1 )
• Facility_Identifier ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Facility_Identifier )
• Type_of_Hydrant_Operation ( type: esriFieldTypeString, alias: Type of Hydrant Operation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Type_of_Hydrant_Operation , Coded Values: [Routine Maintenance: Routine Maintenance] , [Dead End Flush: Dead End Flush] , [3rd Party Operation: 3rd Party Operation] , ...5 more... )
• Hydrant_Condition ( type: esriFieldTypeString, alias: Hydrant Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hydrant_Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• Was_Hydrant_Exercised ( type: esriFieldTypeString, alias: Was Hydrant Exercised, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Was_Hydrant_Exercised , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Ease_of_Hydrant_Operation ( type: esriFieldTypeString, alias: Ease of Hydrant Operation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Ease_of_Hydrant_Operation , Coded Values: [Easy: Easy] , [Moderate: Moderate] , [Difficult: Difficult] , ...1 more... )
• Flow_Rate_GPM ( type: esriFieldTypeString, alias: Flow Rate GPM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Flow_Rate_GPM )
• Time_Flushed__min_ ( type: esriFieldTypeString, alias: Time Flushed (min), editable: true, nullable: true, length: 255, defaultValue: null, modelName: Time_Flushed__min_ )
• Volume_Flushed__gal_ ( type: esriFieldTypeString, alias: Volume Flushed (gal), editable: true, nullable: true, length: 255, defaultValue: null, modelName: Volume_Flushed__gal_ )
• Static_Pressure__psi_ ( type: esriFieldTypeString, alias: Static Pressure (psi), editable: true, nullable: true, length: 255, defaultValue: null, modelName: Static_Pressure__psi_ )
• Initial_Residual__mg_L_ ( type: esriFieldTypeString, alias: Initial Residual (mg/L), editable: true, nullable: true, length: 255, defaultValue: null, modelName: Initial_Residual__mg_L_ )
• Final_Residual__mg_L_ ( type: esriFieldTypeString, alias: Final Residual (mg/L), editable: true, nullable: true, length: 255, defaultValue: null, modelName: Final_Residual__mg_L_ )
• Did_Hydrant_Drain_Completely ( type: esriFieldTypeString, alias: Did Hydrant Drain Completely, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Did_Hydrant_Drain_Completely , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Are_Repairs_Needed ( type: esriFieldTypeString, alias: Are Repairs Needed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Are_Repairs_Needed , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Field_Notes ( type: esriFieldTypeString, alias: Field Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Field_Notes )
• Hydrant_Status ( type: esriFieldTypeString, alias: Hydrant Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hydrant_Status , Coded Values: [Operational: Operational] , [Out of Service: Out of Service] , [Abandoned: Abandoned] )
• Date_Operated ( type: esriFieldTypeString, alias: Date Operated, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Date_Operated )
• Operated_By ( type: esriFieldTypeString, alias: Operated By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operated_By )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GlobalID )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )

Templates:

• Name: SDE.DBO.wHydrant_Inspections
  Description:
  Prototype:
  GlobalID: null
  GUID: null
  OBJECTID_1: null
  Facility_Identifier: null
  Type_of_Hydrant_Operation: null
  Hydrant_Condition: null
  Was_Hydrant_Exercised: null
  Ease_of_Hydrant_Operation: null
  Flow_Rate_GPM: null
  Time_Flushed__min_: null
  Volume_Flushed__gal_: null
  Static_Pressure__psi_: null
  Initial_Residual__mg_L_: null
  Final_Residual__mg_L_: null
  Did_Hydrant_Drain_Completely: null
  Are_Repairs_Needed: null
  Field_Notes: null
  Hydrant_Status: null
  Date_Operated: null
  Operated_By: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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