Name: Sewer Catch Basin Work Order

Display Field: InspectionDate

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 6e0b5dee06df452bbbdfdb6dbe2cf17b

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• Dry ( type: esriFieldTypeString, alias: Is the catch basin dry?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• StandingWater ( type: esriFieldTypeString, alias: Standing water present?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• FlowingWater ( type: esriFieldTypeString, alias: Flowing water in catch basin?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• SurfaceSheen ( type: esriFieldTypeString, alias: Is there a sheen on the surface of the water?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Odor ( type: esriFieldTypeString, alias: Is there an odor of the water?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• DebrisBlockage ( type: esriFieldTypeString, alias: Is the catch basin blocked by debris?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Collapsed ( type: esriFieldTypeString, alias: Is the structure collapsed?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Overgrown ( type: esriFieldTypeString, alias: Is the structure overgrown with vegitation?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• GeneralLocation ( type: esriFieldTypeString, alias: General location of the catch basin, length: 300 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 300 )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, length: 50 )
• CreatedDate ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• EditBy ( type: esriFieldTypeString, alias: Edit By, length: 50 )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• Manhole_ID ( type: esriFieldTypeDouble, alias: Catch Basin ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID_Relation ( type: esriFieldTypeGUID, alias: GUID_Relation, length: 38 )
• WorkType ( type: esriFieldTypeString, alias: Work Order Type, length: 50 , Coded Values: [Inspection: Inspection] , [Rinse: Rinse] , [Repair: Repair] , ...1 more... )
• CB_Condition ( type: esriFieldTypeString, alias: CB_Condition, length: 20 , Coded Values: [Needs Repair: Needs Repair] , [Repaired: Repaired] , [Good: Good] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• WorkStatus ( type: esriFieldTypeString, alias: Work Status, length: 255 , Coded Values: [OPEN: Open] , [CLOSED: Closed] )

Relationships:

• Catch_Basins (1) -- Related To: Catch Basins (3)

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

  Iteminfo   Thumbnail   Metadata