Name: Hydrant Inspection

Display Field: Date

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f4098d79a9224945b98e62564ed77e71

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

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 )
• Date ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• Inspector ( type: esriFieldTypeString, alias: Inspected by, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspector )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Location )
• Model ( type: esriFieldTypeString, alias: Make/Model, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Model , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Corey: Corey] , ...12 more... )
• Paint ( type: esriFieldTypeString, alias: Paint Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Paint , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] )
• Obstruction ( type: esriFieldTypeString, alias: 5' radius obstruction, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Obstruction )
• Height ( type: esriFieldTypeString, alias: Proper Height?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Height , Coded Values: [Yes: Yes] , [No: No] )
• Auxiliary_valve ( type: esriFieldTypeString, alias: Aux Valve to grade?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Auxiliary_valve , Coded Values: [Yes: Yes] , [No: No] )
• Auxiliary_Condition ( type: esriFieldTypeString, alias: Aux Valve Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Auxiliary_Condition , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] )
• Port_Caps ( type: esriFieldTypeString, alias: Port Caps removed?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Port_Caps , Coded Values: [Yes: Yes] , [No: No] )
• Cap_Gaskets ( type: esriFieldTypeString, alias: Check cap gaskets?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Cap_Gaskets , Coded Values: [Yes: Yes] , [No: No] )
• Threads ( type: esriFieldTypeString, alias: Greased threads?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Threads , Coded Values: [Yes: Yes] , [No: No] )
• Chains ( type: esriFieldTypeString, alias: Chains on caps?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Chains , Coded Values: [Yes: Yes] , [No: No] )
• Operational ( type: esriFieldTypeString, alias: Operational, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operational , Coded Values: [Yes: Yes] , [No: No] )
• PSI ( type: esriFieldTypeInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PSI )
• Leaks ( type: esriFieldTypeString, alias: Leaks, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Leaks , Coded Values: [Yes: Yes] , [No: No] )
• Aux_Valve_working ( type: esriFieldTypeString, alias: Aux Valve working?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Aux_Valve_working , Coded Values: [Yes: Yes] , [No: No] )
• Aux_Valve_turns ( type: esriFieldTypeInteger, alias: # of turns to close Aux Valve, editable: true, nullable: true, defaultValue: null, modelName: Aux_Valve_turns )
• Turns_to_close ( type: esriFieldTypeInteger, alias: # of Turns to Close, editable: true, nullable: true, defaultValue: null, modelName: Turns_to_close )
• Drain ( type: esriFieldTypeString, alias: Drains?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Drain , Coded Values: [Yes: Yes] , [No: No] )
• Operating_nut ( type: esriFieldTypeString, alias: Operating Nut Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operating_nut , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] )
• operating_nut_type ( type: esriFieldTypeString, alias: Type of operating nut, editable: true, nullable: true, length: 255, defaultValue: null, modelName: operating_nut_type )
• operating_nut_lube ( type: esriFieldTypeString, alias: Lubrication of operating nut?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: operating_nut_lube , Coded Values: [Yes: Yes] , [No: No] )
• Notes ( type: esriFieldTypeString, alias: Repairs needed or performed/Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Notes )
• Createdby ( type: esriFieldTypeString, alias: Createdby, editable: false, nullable: true, length: 255, defaultValue: null, modelName: Createdby )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DateCreated )
• Editedby ( type: esriFieldTypeString, alias: Editedby, editable: false, nullable: true, length: 255, defaultValue: null, modelName: Editedby )
• DateEdited ( type: esriFieldTypeDate, alias: DateEdited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DateEdited )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• Zone ( type: esriFieldTypeString, alias: Zone Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Zone )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )

Templates:

• Name: Hydrant Inspection
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• BARTLETT_GIS.GIS.wHydrant (0) -- Related To: GIS.wHydrant (378)

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

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: DateCreated
• Creator Field: Createdby
• Edit Date Field: DateEdited
• Editor Field: Editedby

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