Name: Hydrants Inspections

Display Field: UNITID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TYPE ( type: esriFieldTypeSmallInteger, alias: Assignment , Coded Values: [1: Inspection] , [2: Flushing] , [3: Painting] , ...4 more... )
• UNITID ( type: esriFieldTypeString, alias: Unit ID, length: 10 )
• INSPECTDT ( type: esriFieldTypeDate, alias: Inspected On, length: 8 )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspected By, length: 50 )
• INSPECTOR2 ( type: esriFieldTypeString, alias: Additional Inspectors, length: 150 )
• OPERABLE ( type: esriFieldTypeString, alias: Is the Hydrant Operable?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• INSPECTED ( type: esriFieldTypeString, alias: Full Inspection Performed?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• LOCDESC ( type: esriFieldTypeString, alias: Location, length: 255 )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 500 )
• REPAIR_NOTE ( type: esriFieldTypeString, alias: Improvement/Repair Notes, length: 500 )
• FLUSHED ( type: esriFieldTypeString, alias: Flush Complete?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• FLOW_LEN ( type: esriFieldTypeDouble, alias: Flow Duration )
• PAINTED ( type: esriFieldTypeString, alias: Hydrant Painted?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• CRITICALFAC ( type: esriFieldTypeString, alias: Near a Critical Facility?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• NEEDSPAINT ( type: esriFieldTypeString, alias: Hydrant Needs Painting?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• NEEDMARKER ( type: esriFieldTypeString, alias: Needs Marker?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• HARDTURN ( type: esriFieldTypeString, alias: Is Hard to Open/Close?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• NOFLOW ( type: esriFieldTypeString, alias: Will Not Flow or Pump?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• BROKESTEM ( type: esriFieldTypeString, alias: Has Round/Broken Stem?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• HYDCAP ( type: esriFieldTypeString, alias: Has Missing Cap?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• HYDDRAIN ( type: esriFieldTypeString, alias: Has Defective Drain Tube/Cap?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• DEFTHREAD ( type: esriFieldTypeString, alias: Has Defective Threads?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• LEAKING ( type: esriFieldTypeString, alias: Is Hydrant Leaking?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• CHATTER ( type: esriFieldTypeString, alias: Is Hydrant Chattering?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• FROZEN ( type: esriFieldTypeString, alias: Is Hydrant Frozen?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• DISCHRGE_COE ( type: esriFieldTypeDouble, alias: Discharge Coefficient )
• DIFUSR_PSI_1 ( type: esriFieldTypeDouble, alias: Diffuser Pressure 1 (psi) )
• DIFUSR_FLOW_1 ( type: esriFieldTypeDouble, alias: Diffuser Flow 1 (gpm) )
• DIFUSR_PSI_2 ( type: esriFieldTypeDouble, alias: Diffuser Pressure 2 (psi) )
• DIFUSR_FLOW_2 ( type: esriFieldTypeDouble, alias: Diffuser Flow 2 (gpm) )
• DISCHARGE ( type: esriFieldTypeDouble, alias: Hydrant Discharge (gpm) )
• STATIC_PSI ( type: esriFieldTypeDouble, alias: Static Pressure (psi) )
• DESRD_RESIDL ( type: esriFieldTypeDouble, alias: Desired Residual Pressure (psi) )
• RESIDL_PSI ( type: esriFieldTypeDouble, alias: Residual Pressure (psi) )
• FIRE_FLOW ( type: esriFieldTypeDouble, alias: Fire Flow (gpm) )
• SAFETY_FACTR ( type: esriFieldTypeDouble, alias: Safety Factor Number )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 25 , Coded Values: [American: American Darling] , [Kennedy: Kennedy Valve] , [M&H: M&H Valve] , ...4 more... )
• DATE_SET ( type: esriFieldTypeString, alias: Date Set Year, length: 4 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• REL_GlobalID ( type: esriFieldTypeGUID, alias: Rel GlobalID, length: 38 )
• REL_GIS_ID ( type: esriFieldTypeInteger, alias: Rel GIS ID )
• GIS_ID ( type: esriFieldTypeInteger, alias: GIS ID )
• NOCHAINS ( type: esriFieldTypeString, alias: Are Chains Missing/Broken?, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• AUXILIARY ( type: esriFieldTypeString, alias: Auxiliary, length: 20 )
• GRIDNUM ( type: esriFieldTypeString, alias: Hydrant Grid, length: 10 )

Relationships:

• Water - Hydrants (0) -- Related To: Water - Hydrants (0)

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

  Iteminfo   Thumbnail   Metadata