Tables:

Table: WASTEWATER.WASTEWATER.Yearly_Hydraulic_Cleaning_List (1)

Name: WASTEWATER.WASTEWATER.Yearly_Hydraulic_Cleaning_List

Display Field: RouteDirection

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RouteDirection ( type: esriFieldTypeString, alias: RouteDirection, length: 255 )
• Route ( type: esriFieldTypeDouble, alias: Route )
• ISSUE ( type: esriFieldTypeString, alias: ISSUE, length: 255 , Coded Values: [R: Roots] , [G: Grease] , [RG: Roots & Grease] )
• PIPE ( type: esriFieldTypeString, alias: PIPE, length: 255 )
• NOZZLE ( type: esriFieldTypeString, alias: NOZZLE, length: 255 , Coded Values: [6Saw: 6" Saw] , [8Saw: 8" Saw] , [10Saw: 10" Saw] , ...5 more... )
• Map_Page ( type: esriFieldTypeString, alias: Map_Page, length: 255 )
• PG ( type: esriFieldTypeString, alias: PG, length: 255 )
• Upstream_MH ( type: esriFieldTypeString, alias: Upstream_MH, length: 255 )
• MAIN_ID ( type: esriFieldTypeString, alias: MAIN_ID, length: 255 )
• Downstream_MH ( type: esriFieldTypeString, alias: Downstream_MH, length: 255 )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, length: 255 )
• Footage ( type: esriFieldTypeString, alias: Footage, length: 255 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• Schedule ( type: esriFieldTypeString, alias: Schedule, length: 50 , Coded Values: [Weekly: Weekly] , [Monthly: Monthly] , [Quarterly: Quarterly] , ...2 more... )
• CleaningDate ( type: esriFieldTypeDate, alias: Date Cleaned, length: 8 )
• CleanedBy ( type: esriFieldTypeString, alias: CleanedBy, length: 50 , Coded Values: [Bill Betts: Bill Betts] , [Brad Bobo: Brad Bobo] , [Braden Goucher: Braden Goucher] , ...7 more... )
• WorkorderNUM ( type: esriFieldTypeDouble, alias: Workorder Number )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PG_Route ( type: esriFieldTypeString, alias: PG_Route, length: 255 )
• CommentsTwo ( type: esriFieldTypeString, alias: CommentsTwo, length: 255 )
• PG_Route_Numeric ( type: esriFieldTypeInteger, alias: PG_Route_Numeric )