Name: Sewer Catch Basin Work Order

Display Field: InspectionDate

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 927c8c7a0be94a2097d771986509176b

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Sewer Catch Basin Work Order
  Description:
  Prototype:
  CB_Condition: null
  InspectionDate: null
  Inspector: null
  Dry: null
  StandingWater: null
  FlowingWater: null
  SurfaceSheen: null
  Odor: null
  DebrisBlockage: null
  Collapsed: null
  Overgrown: null
  GeneralLocation: null
  Comments: null
  WorkType: null
  GUID_Relation: null
  WorkStatus: null
  Manhole_ID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata