Name: Flushing

Display Field: HydrantID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 10000

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 )
• HydrantID ( type: esriFieldTypeString, alias: Hydrant ID, length: 50 )
• TagID ( type: esriFieldTypeString, alias: Tag ID, length: 50 )
• Street ( type: esriFieldTypeString, alias: Street, length: 50 , Coded Values: [1ST AVE: 1ST AVE] , [2ND AVE: 2ND AVE] , [3RD AVE: 3RD AVE] , ...711 more... )
• Location ( type: esriFieldTypeString, alias: Location, length: 75 )
• FlushingStart ( type: esriFieldTypeDate, alias: Flushing Start, length: 8 )
• FlushingEnd ( type: esriFieldTypeDate, alias: Flushing End, length: 8 )
• StaticPressure ( type: esriFieldTypeInteger, alias: Static Pressure (psi) )
• Flowgpm ( type: esriFieldTypeInteger, alias: Flow (gpm) )
• FlushDurationMin ( type: esriFieldTypeInteger, alias: Flush Duration (min) )
• WaterClean ( type: esriFieldTypeString, alias: Is the water clean?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 500 )
• Creator ( type: esriFieldTypeString, alias: Creator, length: 50 )
• Creator_Date ( type: esriFieldTypeDate, alias: Creator_Date, length: 8 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 50 )
• Editor_Date ( type: esriFieldTypeDate, alias: Editor_Date, length: 8 )
• WOReq ( type: esriFieldTypeString, alias: Work Order Required, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Immediate Action: Immediate Action] )
• QAQCComments ( type: esriFieldTypeString, alias: QA/ QC Comments, length: 500 )
• QAQCBy ( type: esriFieldTypeString, alias: QA/QC By, length: 50 )
• QAQCDate ( type: esriFieldTypeDate, alias: QAQCDate, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• CompletedBy ( type: esriFieldTypeString, alias: Completed By, length: 100 )
• DeadEndMainHydrant ( type: esriFieldTypeString, alias: Hydrant on Dead End Main, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• Processed ( type: esriFieldTypeString, alias: Processed, length: 10 )
• WorkPerformed ( type: esriFieldTypeString, alias: WorkPerformed, length: 255 , Coded Values: [Flushing: Flushing] , [Inspection: Inspection] , [Flushing and Inspection: Flushing and Inspection] )
• RelGUID ( type: esriFieldTypeGUID, alias: RelGUID, length: 38 )
• IsolationValvePresent ( type: esriFieldTypeString, alias: IsolationValvePresent, length: 255 , Coded Values: [Present: Present] , [Not Present: Not Present] )
• IsolationValveStatus ( type: esriFieldTypeString, alias: IsolationValveStatus, length: 255 , Coded Values: [Operable: Operable] , [Inoperable: Inoperable] )
• ClearBrush ( type: esriFieldTypeString, alias: ClearBrush, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• BrushAction ( type: esriFieldTypeString, alias: BrushAction, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Flange_6 ( type: esriFieldTypeString, alias: Flange_6, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• BreakAway ( type: esriFieldTypeString, alias: BreakAway, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• Caps ( type: esriFieldTypeString, alias: Caps, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• CapsAction ( type: esriFieldTypeString, alias: CapsAction, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• UpperBarrelLeaks ( type: esriFieldTypeString, alias: UpperBarrelLeaks, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• UpperBarrelLeaksAction ( type: esriFieldTypeString, alias: UpperBarrelLeaksAction, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• StructuralLeaks ( type: esriFieldTypeString, alias: StructuralLeaks, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• StructuralLeaksAction ( type: esriFieldTypeString, alias: StructuralLeaksAction, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• FlushOperation ( type: esriFieldTypeString, alias: FlushOperation, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• CapThreads ( type: esriFieldTypeString, alias: CapThreads, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• CapThreadsAction ( type: esriFieldTypeString, alias: CapThreadsAction, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• HyTagged ( type: esriFieldTypeString, alias: HyTagged, length: 255 , Coded Values: [Pass: Pass] , [Fail: Fail] , [Not Inspected: Not Inspected] , ...1 more... )
• HyTaggedAction ( type: esriFieldTypeString, alias: HyTaggedAction, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Inspected ( type: esriFieldTypeString, alias: Inspected, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Painted ( type: esriFieldTypeString, alias: Painted, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Tagged ( type: esriFieldTypeString, alias: Tagged, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Greased ( type: esriFieldTypeString, alias: Greased, length: 255 , Coded Values: [Yes: Yes] , [No: No] )

Relationships:

• Hydrants.DBO.Hydrants (1) -- Related To: Hydrants (0)

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

  Iteminfo   Thumbnail   Metadata