View In:   ArcGIS Online map viewer

Name: piWorkorder

Display Field: WORKID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 1641221.122335717
YMin: 335614.22108356655
XMax: 1737889.963446468
YMax: 417702.88433372974
Spatial Reference: 102729  (2272)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: WORKSTATUS
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Assigned
  Label: Assigned
  Description:
  Symbol:
  
• Value: Unassigned
  Label: Unassigned
  Description:
  Symbol:
  
• Value: Water
  Label: Water
  Description:
  Symbol:
  
• Value: Sewer
  Label: Sewer
  Description:
  Symbol:
  
• Value: Work Completed
  Label: Work Completed
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [194, 252, 232, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
Transparency: 0
Labeling Info:

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: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: WORKSTATUS

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• WORKID ( type: esriFieldTypeString , alias: Workorder Identifier , editable: true , nullable: true , length: 50 )
• WORKTYPE ( type: esriFieldTypeString , alias: Workorder Type , editable: true , nullable: true , length: 50 , Coded Values: [Other: Other] , [Customer Valve: Customer Valve] , [Hydrant: Hydrant] , ...14 more... )
• WORKSTATUS ( type: esriFieldTypeString , alias: Workorder Status , editable: true , nullable: true , length: 20 , Coded Values: [Unassigned: Unassigned] , [Assigned: Assigned] , [Work Completed: Work Completed] , ...2 more... )
• CHARGECODE ( type: esriFieldTypeString , alias: Charge Code , editable: true , nullable: true , length: 10 , Coded Values: [I & I: I & I] , [W: W] , [S: S] , ...2 more... )
• FACILITYKEY ( type: esriFieldTypeString , alias: Facility Identifier , editable: true , nullable: true , length: 50 )
• FCLASS ( type: esriFieldTypeString , alias: Feature Class , editable: true , nullable: true , length: 50 )
• PRIORITY ( type: esriFieldTypeSmallInteger , alias: Priority , editable: true , nullable: true , Coded Values: [1: (1) High] , [2: (2) Normal] , [3: (3) Low] )
• EMERGENCY ( type: esriFieldTypeString , alias: Emergency Incident , editable: true , nullable: true , length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• ASSIGNEDTO ( type: esriFieldTypeString , alias: Assigned To , editable: true , nullable: true , length: 50 )
• SUPERVISOR ( type: esriFieldTypeString , alias: Supervisor , editable: true , nullable: true , length: 50 )
• PLANSTART ( type: esriFieldTypeDate , alias: Planned Start , editable: true , nullable: true , length: 8 )
• PLANEND ( type: esriFieldTypeDate , alias: Planned End , editable: true , nullable: true , length: 8 )
• ACTSTART ( type: esriFieldTypeDate , alias: Actual Start , editable: true , nullable: true , length: 8 )
• ACTEND ( type: esriFieldTypeDate , alias: Actual End , editable: true , nullable: true , length: 8 )
• FULLADDR ( type: esriFieldTypeString , alias: Location , editable: true , nullable: true , length: 255 )
• LOCATION ( type: esriFieldTypeString , alias: Location , editable: true , nullable: true , length: 255 )
• ROTATION ( type: esriFieldTypeDouble , alias: Rotation , editable: true , nullable: true )
• LASTUPDATE ( type: esriFieldTypeDate , alias: Last Update Date , editable: false , nullable: true , length: 8 )
• LASTEDITOR ( type: esriFieldTypeString , alias: Last Editor , editable: false , nullable: true , length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• DEPARTMENT ( type: esriFieldTypeString , alias: Department , editable: true , nullable: true , length: 10 , Coded Values: [Water: Water] , [Sewer: Sewer] , [Pump/Sampling: Pump/Sampling] , ...2 more... )
• DESCRIPTION ( type: esriFieldTypeString , alias: Description , editable: true , nullable: true , length: 255 )
• AREA_ ( type: esriFieldTypeString , alias: AREA , editable: true , nullable: true , length: 50 )
• ONECALLSTARTDATE ( type: esriFieldTypeDate , alias: 1Call Start Date , editable: true , nullable: true , length: 8 )
• ONECALLDUEDATE ( type: esriFieldTypeDate , alias: 1Call Due Date , editable: true , nullable: true , length: 8 )

Types:

ID: Assigned
Name: Assigned
Domains:
• WORKTYPE:
  Inherited
• WORKSTATUS:
  Inherited
• CHARGECODE:
  Inherited
• PRIORITY:
  Inherited
• EMERGENCY:
  Inherited
• DEPARTMENT:
  Inherited
Templates:
• Name: Assigned
  Description:
  Prototype:
  WORKTYPE: null
  FCLASS: null
  ONECALLDUEDATE: null
  WORKID: null
  WORKSTATUS: Assigned
  CHARGECODE: null
  FACILITYKEY: null
  PRIORITY: 2
  EMERGENCY: null
  ASSIGNEDTO: null
  SUPERVISOR: null
  PLANSTART: null
  PLANEND: null
  ACTSTART: null
  ACTEND: null
  FULLADDR: null
  LOCATION: null
  ROTATION: null
  AREA_: null
  DESCRIPTION: null
  ONECALLSTARTDATE: null
  DEPARTMENT: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Unassigned
Name: Unassigned
Domains:
• WORKTYPE:
  Inherited
• WORKSTATUS:
  Inherited
• CHARGECODE:
  Inherited
• PRIORITY:
  Inherited
• EMERGENCY:
  Inherited
• DEPARTMENT:
  Inherited
Templates:
• Name: Unassigned
  Description:
  Prototype:
  WORKTYPE: null
  FCLASS: null
  ONECALLDUEDATE: null
  WORKID: null
  WORKSTATUS: Unassigned
  CHARGECODE: null
  FACILITYKEY: null
  PRIORITY: 2
  EMERGENCY: null
  ASSIGNEDTO: null
  SUPERVISOR: null
  PLANSTART: null
  PLANEND: null
  ACTSTART: null
  ACTEND: null
  FULLADDR: null
  LOCATION: null
  ROTATION: null
  AREA_: null
  DESCRIPTION: null
  ONECALLSTARTDATE: null
  DEPARTMENT: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Water
Name: Water
Domains:
• WORKTYPE:
  Inherited
• WORKSTATUS:
  Inherited
• CHARGECODE:
  Inherited
• PRIORITY:
  Inherited
• EMERGENCY:
  Inherited
• DEPARTMENT:
  Inherited
Templates:
• Name: Water
  Description:
  Prototype:
  ONECALLSTARTDATE: null
  ONECALLDUEDATE: null
  WORKID: null
  WORKTYPE: null
  WORKSTATUS: Water
  CHARGECODE: null
  FACILITYKEY: null
  FCLASS: null
  PRIORITY: 2
  EMERGENCY: null
  ASSIGNEDTO: null
  SUPERVISOR: null
  PLANSTART: null
  PLANEND: null
  ACTSTART: null
  ACTEND: null
  FULLADDR: null
  LOCATION: null
  ROTATION: null
  DESCRIPTION: null
  DEPARTMENT: null
  AREA_: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Sewer
Name: Sewer
Domains:
• WORKTYPE:
  Inherited
• WORKSTATUS:
  Inherited
• CHARGECODE:
  Inherited
• PRIORITY:
  Inherited
• EMERGENCY:
  Inherited
• DEPARTMENT:
  Inherited
Templates:
• Name: Sewer
  Description:
  Prototype:
  ONECALLSTARTDATE: null
  ONECALLDUEDATE: null
  WORKID: null
  WORKTYPE: null
  WORKSTATUS: Sewer
  CHARGECODE: null
  FACILITYKEY: null
  FCLASS: null
  PRIORITY: 2
  EMERGENCY: null
  ASSIGNEDTO: null
  SUPERVISOR: null
  PLANSTART: null
  PLANEND: null
  ACTSTART: null
  ACTEND: null
  FULLADDR: null
  LOCATION: null
  ROTATION: null
  DESCRIPTION: null
  DEPARTMENT: null
  AREA_: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Work Completed
Name: Work Completed
Domains:
• WORKTYPE:
  Inherited
• WORKSTATUS:
  Inherited
• CHARGECODE:
  Inherited
• PRIORITY:
  Inherited
• EMERGENCY:
  Inherited
• DEPARTMENT:
  Inherited
Templates:
• Name: Work Completed
  Description:
  Prototype:
  WORKTYPE: null
  FCLASS: null
  ONECALLDUEDATE: null
  WORKID: null
  WORKSTATUS: Work Completed
  CHARGECODE: null
  FACILITYKEY: null
  PRIORITY: 2
  EMERGENCY: null
  ASSIGNEDTO: null
  SUPERVISOR: null
  PLANSTART: null
  PLANEND: null
  ACTSTART: null
  ACTEND: null
  FULLADDR: null
  LOCATION: null
  ROTATION: null
  AREA_: null
  DESCRIPTION: null
  ONECALLSTARTDATE: null
  DEPARTMENT: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: LASTUPDATE
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates