Name: swCatchBasinActivity

Display Field: STRUCTURE_TYPE

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• STRUCTURE_TYPE ( type: esriFieldTypeString, alias: STRUCTURE_TYPE, length: 50 , Coded Values: [Catchbasin Manhole: Catchbasin Manhole] , [Double Catchbasin Manhole: Double Catchbasin Manhole] , [Manhole: Manhole] , ...6 more... )
• SINK_HOLE ( type: esriFieldTypeString, alias: SINK_HOLE, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Not Inspected: Not Inspected] )
• CASTING ( type: esriFieldTypeString, alias: CASTING, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• CASTING_CONDITION ( type: esriFieldTypeString, alias: CASTING_CONDITION, length: 50 , Coded Values: [Protruding: Protruding] , [Depression: Depression] , [Okay: Okay] )
• REPAIRS_REQUIRED ( type: esriFieldTypeString, alias: REPAIRS_REQUIRED, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Not Inspected: Not Inspected] )
• REASON_FOR_REPAIR ( type: esriFieldTypeString, alias: Reason_For_Repair, length: 50 , Coded Values: [Cracked/Broken Casting: Cracked/Broken Casting] , [Failed Risers: Failed Risers] , [Sinkhole: Sinkhole] , ...4 more... )
• STRUCTURE_CONDITION ( type: esriFieldTypeString, alias: Structure Condition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• SERVICE_CONNECTION ( type: esriFieldTypeString, alias: Service Connection, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Not Inspected: Not Inspected] )
• CLEANING_NEEDED ( type: esriFieldTypeString, alias: Cleaning_Needed, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Not Inspected: Not Inspected] )
• OIL_SHEEN ( type: esriFieldTypeString, alias: OIL_SHEEN, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Not Inspected: Not Inspected] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 50 )
• CONDITION_OF_RISERS ( type: esriFieldTypeString, alias: CONDITION_OF_RISERS, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• DEPTH_OF_MANHOLE ( type: esriFieldTypeSmallInteger, alias: DEPTH_OF_MANHOLE )
• PIPE_DIAMETER_IN_INCHES ( type: esriFieldTypeSmallInteger, alias: PIPE_DIAMETER_IN_INCHES )
• INSPECTED_BY ( type: esriFieldTypeString, alias: INSPECTED_BY, length: 50 , Coded Values: [Roger Ludwig: Roger Ludwig] , [Dene Schieck: Dene Schieck] , [Dax McAllister: Dax McAllister] , ...3 more... )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, length: 1000 )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LASTACTIVITY, length: 50 , Coded Values: [INSP: Inspection] , [UPDT: Update] , [RPR: Repair / Replacement] , ...6 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, length: 8 )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD )
• MANHOLE_EXIST ( type: esriFieldTypeString, alias: MANHOLE_EXIST, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• SUMP_EXISTS ( type: esriFieldTypeString, alias: SUMP_EXISTS, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Not Inspected: Not Inspected] )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, length: 30 )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, length: 30 )
• CONTRACTOR_CLEANING ( type: esriFieldTypeString, alias: CONTRACTOR_CLEANING, length: 30 , Coded Values: [Cleaned: Cleaned] , [Obstructed (1stVisit): Obstructed (1stVisit)] , [Obstructed (2ndVisit): Obstructed (2ndVisit)] )
• LADDER_RUNGS ( type: esriFieldTypeString, alias: LADDER_RUNGS, length: 15 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• BENCHING ( type: esriFieldTypeString, alias: BENCHING, length: 15 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• INFILTRATION ( type: esriFieldTypeString, alias: INFILTRATION, length: 4 , Coded Values: [High: High] , [Low: Low] , [None: None] )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata