View In:   ArcGIS Online Map Viewer

Name: WorkOrders

Display Field: WORKTYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 840915fc128a48a481d984e19d5ca584

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.0556615528453002E7
YMin: -2.1524253170195673E7
XMax: 2437480.709680494
YMax: 7942385.278627403
Spatial Reference: 103022  (6438)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: DEPARTMENT
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 10000
  Label: Not Yet Referred
  Description: N/A
  Symbol:
  
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: DEPARTMENT

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• DEPARTMENT ( type: esriFieldTypeInteger, alias: Department, editable: true, nullable: true, defaultValue: 10000, modelName: DEPARTMENT )
• WORKTYPE ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: false, length: 50, defaultValue: Not Classified, modelName: WORKTYPE , Coded Values: [Arcing Line/Transformer: Arcing Line/Transformer] , [Damaged Equipment: Damaged Equipment] , [Damaged Facilities: Damaged Facilities] , ...40 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: false, length: 250, defaultValue: null, modelName: LOCATION )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: false, length: 30, defaultValue: New, modelName: STATUS , Coded Values: [Complete: Complete] , [New: New] , [In Progress: In Progress] , ...2 more... )
• ASSIGNEDTO ( type: esriFieldTypeString, alias: Assigned To, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSIGNEDTO , Coded Values: [Electric Lineman 1: Electric Lineman 1] , [Electric Lineman 2: Electric Lineman 2] , [Electric Lineman 3: Electric Lineman 3] , ...5 more... )
• DATECOMPLETED ( type: esriFieldTypeDate, alias: Date Completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECOMPLETED )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: NOTES )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_date ( type: esriFieldTypeDate, alias: Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• REQUESTORNAME ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: REQUESTORNAME )
• REQUESTORPHONE ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQUESTORPHONE )
• REQUESTOREMAIL ( type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQUESTOREMAIL )
• REQUESTDESCRIPTION ( type: esriFieldTypeString, alias: Request Description, editable: true, nullable: false, length: 1000, defaultValue: null, modelName: REQUESTDESCRIPTION )
• REQUESTTYPE ( type: esriFieldTypeString, alias: Request Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQUESTTYPE )
• REQUESTNOTES ( type: esriFieldTypeString, alias: Completion Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: REQUESTNOTES )
• REQUESTORIGIN ( type: esriFieldTypeString, alias: Request Origin, editable: true, nullable: false, length: 50, defaultValue: Department Dispatcher, modelName: REQUESTORIGIN , Coded Values: [Citizen Request: Citizen Request] , [City Staff: City Staff] , [Department Dispatcher: Department Dispatcher] , ...4 more... )
• PRIORITY ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 20, defaultValue: Normal, modelName: PRIORITY , Coded Values: [Normal: Normal] , [High: High] , [Critical: Critical] )
• LASTNOTIFICATION ( type: esriFieldTypeString, alias: Last Notification, editable: true, nullable: false, length: 50, defaultValue: null, modelName: LASTNOTIFICATION , Coded Values: [None: None] , [Routed: Routed] , [Complete: Complete] , ...1 more... )
• WORKORDERID ( type: esriFieldTypeInteger, alias: Work Order ID, editable: true, nullable: true, defaultValue: null, modelName: WORKORDERID )
• NOTIFYCREW ( type: esriFieldTypeString, alias: Notify Crew, editable: true, nullable: true, length: 3, defaultValue: null, modelName: NOTIFYCREW , Coded Values: [Yes: Yes] , [No: No] )
• PARENTID ( type: esriFieldTypeInteger, alias: Parent ID, editable: true, nullable: true, defaultValue: null, modelName: PARENTID )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ADDRESS )
• NEEDDATE ( type: esriFieldTypeDate, alias: NEEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NEEDDATE )
• WO_CALLCENTER ( type: esriFieldTypeString, alias: WO_CALLCENTER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WO_CALLCENTER )
• WO_BILLING ( type: esriFieldTypeString, alias: WO_BILLING, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WO_BILLING )
• REQUESTORADDRESS ( type: esriFieldTypeString, alias: REQUESTORADDRESS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQUESTORADDRESS )
• DATESTARTED ( type: esriFieldTypeDate, alias: DATESTARTED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTARTED )
• URL ( type: esriFieldTypeString, alias: URL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: URL )
• DATEADDED ( type: esriFieldTypeDate, alias: DATEADDED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEADDED )
• DATEUPDATED ( type: esriFieldTypeDate, alias: DATEUPDATED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEUPDATED )
• CARTEGRAPHID ( type: esriFieldTypeString, alias: CARTEGRAPHID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CARTEGRAPHID )

Types:

ID: 10000
Name: Not Yet Referred
Domains:
• WORKTYPE:
  Coded Values: [Not Classified: Not Classified] , [Information Request: Information Request]
• STATUS:
  Inherited
• ASSIGNEDTO:
  Coded Values: [Administration: Administration]
• REQUESTORIGIN:
  Inherited
• PRIORITY:
  Inherited
• LASTNOTIFICATION:
  Inherited
Templates:
• Name: Not Yet Referred
  Description:
  Prototype:
  REQUESTNOTES: null
  REQUESTORIGIN: Citizen Request
  LOCATION:
  DATEUPDATED: null
  WORKTYPE: Not Classified
  DEPARTMENT: 10000
  REQUESTOREMAIL: null
  STATUS: New
  PRIORITY: Normal
  ASSIGNEDTO: Administration
  DATECOMPLETED: null
  NOTES: null
  DATEADDED: null
  URL: null
  CARTEGRAPHID: null
  REQUESTORNAME: null
  REQUESTORPHONE: null
  REQUESTDESCRIPTION:
  REQUESTTYPE: null
  LASTNOTIFICATION: None
  WORKORDERID: null
  NOTIFYCREW: null
  PARENTID: null
  ADDRESS: null
  NEEDDATE: null
  WO_CALLCENTER: null
  WO_BILLING: null
  REQUESTORADDRESS: null
  DATESTARTED: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Uploads,Editing,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata