View In:   ArcGIS Online Map Viewer

Name: Cityworks Workorders

Display Field: WORKORDERID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Cityworks Workorders

Service Item Id: bd08ea42a316460a9c304d4d43903950

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 500000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -9431717.794
YMin: 1395243.46487468
XMax: 1426047.151
YMax: 9328784.1097475
Spatial Reference: 102658  (2236)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: false, length: 60, defaultValue: null, modelName: WORKORDERID )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DESCRIPTION )
• SUPERVISOR ( type: esriFieldTypeString, alias: SUPERVISOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUPERVISOR )
• REQUESTEDBY ( type: esriFieldTypeString, alias: REQUESTEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQUESTEDBY )
• INITIATEDBY ( type: esriFieldTypeString, alias: INITIATEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INITIATEDBY )
• INITIATEDATE ( type: esriFieldTypeDate, alias: INITIATEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INITIATEDATE )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 256, defaultValue: null, modelName: LOCATION )
• PROJSTARTDATE ( type: esriFieldTypeDate, alias: PROJSTARTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PROJSTARTDATE )
• PROJFINISHDATE ( type: esriFieldTypeDate, alias: PROJFINISHDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PROJFINISHDATE )
• ACTUALSTARTDATE ( type: esriFieldTypeDate, alias: ACTUALSTARTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUALSTARTDATE )
• ACTUALFINISHDATE ( type: esriFieldTypeDate, alias: ACTUALFINISHDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUALFINISHDATE )
• WOCLOSEDBY ( type: esriFieldTypeString, alias: WOCLOSEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WOCLOSEDBY )
• CANCEL ( type: esriFieldTypeString, alias: CANCEL, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CANCEL )
• PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PRIORITY )
• NUMDAYSBEFORE ( type: esriFieldTypeSmallInteger, alias: NUMDAYSBEFORE, editable: true, nullable: true, defaultValue: null, modelName: NUMDAYSBEFORE )
• DATETOBEPRINTED ( type: esriFieldTypeDate, alias: DATETOBEPRINTED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETOBEPRINTED )
• DATEPRINTED ( type: esriFieldTypeDate, alias: DATEPRINTED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEPRINTED )
• SOURCEWOID ( type: esriFieldTypeString, alias: SOURCEWOID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCEWOID )
• WOXCOORDINATE ( type: esriFieldTypeDouble, alias: WOXCOORDINATE, editable: true, nullable: true, defaultValue: null, modelName: WOXCOORDINATE )
• WOYCOORDINATE ( type: esriFieldTypeDouble, alias: WOYCOORDINATE, editable: true, nullable: true, defaultValue: null, modelName: WOYCOORDINATE )
• SHOP ( type: esriFieldTypeString, alias: SHOP, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SHOP )
• WOCATEGORY ( type: esriFieldTypeString, alias: WOCATEGORY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WOCATEGORY )
• WOCOST ( type: esriFieldTypeDouble, alias: WOCOST, editable: true, nullable: true, defaultValue: null, modelName: WOCOST )
• WOLABORCOST ( type: esriFieldTypeDouble, alias: WOLABORCOST, editable: true, nullable: true, defaultValue: null, modelName: WOLABORCOST )
• WOMATCOST ( type: esriFieldTypeDouble, alias: WOMATCOST, editable: true, nullable: true, defaultValue: null, modelName: WOMATCOST )
• WOEQUIPCOST ( type: esriFieldTypeDouble, alias: WOEQUIPCOST, editable: true, nullable: true, defaultValue: null, modelName: WOEQUIPCOST )
• WOPERMITCOST ( type: esriFieldTypeDouble, alias: WOPERMITCOST, editable: true, nullable: true, defaultValue: null, modelName: WOPERMITCOST )
• SUBMITTO ( type: esriFieldTypeString, alias: SUBMITTO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBMITTO )
• DATESUBMITTO ( type: esriFieldTypeDate, alias: DATESUBMITTO, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESUBMITTO )
• SUBMITTOOPENBY ( type: esriFieldTypeString, alias: SUBMITTOOPENBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBMITTOOPENBY )
• DATESUBMITTOOPEN ( type: esriFieldTypeDate, alias: DATESUBMITTOOPEN, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESUBMITTOOPEN )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS )
• WORKCOMPLETEDBY ( type: esriFieldTypeString, alias: WORKCOMPLETEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WORKCOMPLETEDBY )
• DATEWOCLOSED ( type: esriFieldTypeDate, alias: DATEWOCLOSED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEWOCLOSED )
• MAPPAGE ( type: esriFieldTypeString, alias: MAPPAGE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MAPPAGE )
• LEGALBILLABLE ( type: esriFieldTypeString, alias: LEGALBILLABLE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LEGALBILLABLE )
• CONTRBILLABLE ( type: esriFieldTypeString, alias: CONTRBILLABLE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CONTRBILLABLE )
• CANCELLEDBY ( type: esriFieldTypeString, alias: CANCELLEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CANCELLEDBY )
• DATECANCELLED ( type: esriFieldTypeDate, alias: DATECANCELLED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECANCELLED )
• APPLYTOENTITY ( type: esriFieldTypeString, alias: APPLYTOENTITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: APPLYTOENTITY )
• ASSETGROUP ( type: esriFieldTypeString, alias: ASSETGROUP, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSETGROUP )
• WOADDRESS ( type: esriFieldTypeString, alias: WOADDRESS, editable: true, nullable: true, length: 130, defaultValue: null, modelName: WOADDRESS )
• CREATEDBYCYCLE ( type: esriFieldTypeString, alias: CREATEDBYCYCLE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CREATEDBYCYCLE )
• TRANSTOWOID ( type: esriFieldTypeString, alias: TRANSTOWOID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TRANSTOWOID )
• EXPENSETYPE ( type: esriFieldTypeString, alias: EXPENSETYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EXPENSETYPE )
• CANCELREASON ( type: esriFieldTypeString, alias: CANCELREASON, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CANCELREASON )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DISTRICT )
• RESOLUTION ( type: esriFieldTypeString, alias: RESOLUTION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RESOLUTION )
• ISREACTIVE ( type: esriFieldTypeString, alias: ISREACTIVE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ISREACTIVE )
• SUPERVISORSID ( type: esriFieldTypeInteger, alias: SUPERVISORSID, editable: true, nullable: true, defaultValue: null, modelName: SUPERVISORSID )
• REQUESTEDBYSID ( type: esriFieldTypeInteger, alias: REQUESTEDBYSID, editable: true, nullable: true, defaultValue: null, modelName: REQUESTEDBYSID )
• INITIATEDBYSID ( type: esriFieldTypeInteger, alias: INITIATEDBYSID, editable: true, nullable: true, defaultValue: null, modelName: INITIATEDBYSID )
• SUBMITTOSID ( type: esriFieldTypeInteger, alias: SUBMITTOSID, editable: true, nullable: true, defaultValue: null, modelName: SUBMITTOSID )
• SUBMITTOOPENBYSID ( type: esriFieldTypeInteger, alias: SUBMITTOOPENBYSID, editable: true, nullable: true, defaultValue: null, modelName: SUBMITTOOPENBYSID )
• WORKCOMPLETEDBYSID ( type: esriFieldTypeInteger, alias: WORKCOMPLETEDBYSID, editable: true, nullable: true, defaultValue: null, modelName: WORKCOMPLETEDBYSID )
• CANCELLEDBYSID ( type: esriFieldTypeInteger, alias: CANCELLEDBYSID, editable: true, nullable: true, defaultValue: null, modelName: CANCELLEDBYSID )
• CLOSEDBYSID ( type: esriFieldTypeInteger, alias: CLOSEDBYSID, editable: true, nullable: true, defaultValue: null, modelName: CLOSEDBYSID )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID, editable: false, nullable: false, defaultValue: null, modelName: ESRI_OID )

Templates:

• Name: Cityworks Workorders
  Description:
  Prototype:
  CANCELLEDBYSID: null
  WORKORDERID:
  DESCRIPTION: null
  SUPERVISOR: null
  REQUESTEDBY: null
  INITIATEDBY: null
  INITIATEDATE: null
  LOCATION: null
  PROJSTARTDATE: null
  PROJFINISHDATE: null
  ACTUALSTARTDATE: null
  ACTUALFINISHDATE: null
  WOCLOSEDBY: null
  CANCEL: null
  PRIORITY: null
  NUMDAYSBEFORE: null
  DATETOBEPRINTED: null
  DATEPRINTED: null
  SOURCEWOID: null
  WOXCOORDINATE: null
  WOYCOORDINATE: null
  SHOP: null
  WOCATEGORY: null
  WOCOST: null
  WOLABORCOST: null
  WOMATCOST: null
  WOEQUIPCOST: null
  WOPERMITCOST: null
  SUBMITTO: null
  DATESUBMITTO: null
  SUBMITTOOPENBY: null
  DATESUBMITTOOPEN: null
  STATUS: null
  WORKCOMPLETEDBY: null
  DATEWOCLOSED: null
  MAPPAGE: null
  LEGALBILLABLE: null
  CONTRBILLABLE: null
  CANCELLEDBY: null
  DATECANCELLED: null
  APPLYTOENTITY: null
  ASSETGROUP: null
  WOADDRESS: null
  CREATEDBYCYCLE: null
  TRANSTOWOID: null
  EXPENSETYPE: null
  CANCELREASON: null
  DISTRICT: null
  RESOLUTION: null
  ISREACTIVE: null
  SUPERVISORSID: null
  REQUESTEDBYSID: null
  INITIATEDBYSID: null
  SUBMITTOSID: null
  SUBMITTOOPENBYSID: null
  WORKCOMPLETEDBYSID: null
  CLOSEDBYSID: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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