Name: Sewer Manhole Work Order

Display Field: InspectDate

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:

• InspectDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectDate )
• Size ( type: esriFieldTypeString, alias: Manhole Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Size )
• Material ( type: esriFieldTypeString, alias: Manhole Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material , Coded Values: [Concrete: Concrete] , [Masonry: Masonry] , [PVC: PVC] , ...12 more... )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Contractor )
• System ( type: esriFieldTypeString, alias: System, editable: true, nullable: true, length: 50, defaultValue: null, modelName: System , Coded Values: [Storm: Storm] , [Sanitary: Sanitary] )
• BidNumber ( type: esriFieldTypeString, alias: Bid Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BidNumber )
• ManholeID ( type: esriFieldTypeString, alias: Manhole ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ManholeID )
• Notes ( type: esriFieldTypeString, alias: Inspection Notes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Notes )
• 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 )
• GUID_Relation ( type: esriFieldTypeGUID, alias: GUID_Relation, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID_Relation )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MH_ID ( type: esriFieldTypeString, alias: MH_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MH_ID )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: Good, modelName: Condition , Coded Values: [Good: Good] , [Needs Repair: Needs Repair] )
• MaintPerformed ( type: esriFieldTypeString, alias: Maintenance Performed?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintPerformed , Coded Values: [Inspection: Inspection] , [Rinse: Rinse] , [Repair: Repair] , ...1 more... )
• MaintNotes ( type: esriFieldTypeString, alias: Maintenance Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MaintNotes )
• Work_Status ( type: esriFieldTypeString, alias: Work Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Work_Status , Coded Values: [Open: Open] , [Closed: Closed] , [Future: Future] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ManholeDepth ( type: esriFieldTypeDouble, alias: Depth of Structure, editable: true, nullable: true, defaultValue: null, modelName: ManholeDepth )

Templates:

• Name: Sewer Manhole Work Order
  Description:
  Prototype:
  Work_Status: null
  InspectDate: null
  Size: null
  Material: null
  Inspector: null
  Contractor: null
  System: null
  BidNumber: null
  ManholeID: null
  Notes: null
  MaintNotes: null
  MaintPerformed: null
  Condition: Good
  MH_ID: null
  GUID_Relation: null
  ManholeDepth: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Sewer_Manholes_Relationship (0) -- Related To: Manholes (0)

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