View In:   ArcGIS Online Map Viewer

Name: Work Orders

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 8a5f1ba2ba7b4364b4364c2c9e803ba5

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: NaN
YMin: NaN
XMax: NaN
YMax: NaN
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Assigned
  Label: Assigned
  Description: N/A
  Symbol:
  
• Value: Failed
  Label: Failed
  Description: N/A
  Symbol:
  
• Value: Finished
  Label: Finished
  Description: N/A
  Symbol:
  
• Value: In-progress
  Label: In-progress
  Description: N/A
  Symbol:
  
• Value: Open
  Label: Open
  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: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: STATUS

Fields:

• REQUESTID ( type: esriFieldTypeInteger, alias: Request ID, editable: true, nullable: true, defaultValue: null, modelName: REQUESTID )
• TEMPLATE ( type: esriFieldTypeString, alias: Template, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: TEMPLATE )
• DESCRIPTION ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: DESCRIPTION )
• DATE_CREATED ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_CREATED )
• DATE_CLOSED ( type: esriFieldTypeDate, alias: Date Closed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_CLOSED )
• PROJECT ( type: esriFieldTypeString, alias: Project, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: PROJECT )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: STATUS , Coded Values: [Open: Open] , [Assigned: Assigned] , [In-progress: In-progress] , ...2 more... )
• CATEGORY ( type: esriFieldTypeString, alias: Category, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: CATEGORY )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ADDRESS )
• PRIORITY ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRIORITY )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• ASSET ( type: esriFieldTypeString, alias: Asset, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ASSET )
• ASSETID ( type: esriFieldTypeInteger, alias: Asset ID, editable: true, nullable: true, defaultValue: null, modelName: ASSETID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• fk_InspectionID ( type: esriFieldTypeGUID, alias: fk_InspectionID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: fk_InspectionID )
• fk_ProjectID ( type: esriFieldTypeGUID, alias: fk_ProjectID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: fk_ProjectID )

Types:

ID: Assigned
Name: Assigned
Domains:
• STATUS:
  Inherited
Templates:
• Name: Assigned
  Description:
  Prototype:
  PROJECT: null
  fk_InspectionID: null
  REQUESTID: null
  TEMPLATE: null
  DESCRIPTION: null
  DATE_CREATED: null
  DATE_CLOSED: null
  STATUS: Assigned
  CATEGORY: null
  ADDRESS: null
  PRIORITY: null
  COMMENTS: null
  ASSET: null
  ASSETID: null
  fk_ProjectID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Failed
Name: Failed
Domains:
• STATUS:
  Inherited
Templates:
• Name: Failed
  Description:
  Prototype:
  PROJECT: null
  fk_InspectionID: null
  REQUESTID: null
  TEMPLATE: null
  DESCRIPTION: null
  DATE_CREATED: null
  DATE_CLOSED: null
  STATUS: Failed
  CATEGORY: null
  ADDRESS: null
  PRIORITY: null
  COMMENTS: null
  ASSET: null
  ASSETID: null
  fk_ProjectID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Finished
Name: Finished
Domains:
• STATUS:
  Inherited
Templates:
• Name: Finished
  Description:
  Prototype:
  PROJECT: null
  fk_InspectionID: null
  REQUESTID: null
  TEMPLATE: null
  DESCRIPTION: null
  DATE_CREATED: null
  DATE_CLOSED: null
  STATUS: Finished
  CATEGORY: null
  ADDRESS: null
  PRIORITY: null
  COMMENTS: null
  ASSET: null
  ASSETID: null
  fk_ProjectID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: In-progress
Name: In-progress
Domains:
• STATUS:
  Inherited
Templates:
• Name: In-progress
  Description:
  Prototype:
  PROJECT: null
  fk_InspectionID: null
  REQUESTID: null
  TEMPLATE: null
  DESCRIPTION: null
  DATE_CREATED: null
  DATE_CLOSED: null
  STATUS: In-progress
  CATEGORY: null
  ADDRESS: null
  PRIORITY: null
  COMMENTS: null
  ASSET: null
  ASSETID: null
  fk_ProjectID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Open
Name: Open
Domains:
• STATUS:
  Inherited
Templates:
• Name: Open
  Description:
  Prototype:
  PROJECT: null
  fk_InspectionID: null
  REQUESTID: null
  TEMPLATE: null
  DESCRIPTION: null
  DATE_CREATED: null
  DATE_CLOSED: null
  STATUS: Open
  CATEGORY: null
  ADDRESS: null
  PRIORITY: null
  COMMENTS: null
  ASSET: null
  ASSETID: null
  fk_ProjectID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• DBO.Inspection (0) -- Related To: Inspections (1)
• DBO.AEC_Projects (3) -- Related To: Projects (3)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,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   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata