Layers:

Layer: Cityworks Workorders (0)

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

Layer: Cityworks ServiceRequests (1)

Name: Cityworks ServiceRequests

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Cityworks.dbo.ServiceRequests_Layer

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: -9236206.1705613
YMin: 1395695.251
XMax: 593410.353
YMax: 3292943.0489367
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:
• REQUESTID ( type: esriFieldTypeDouble, alias: REQUESTID, editable: true, nullable: false, defaultValue: null, modelName: REQUESTID )
• PROBLEMCODE ( type: esriFieldTypeString, alias: PROBLEMCODE, editable: true, nullable: false, length: 20, defaultValue: null, modelName: PROBLEMCODE )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DESCRIPTION )
• DETAILS ( type: esriFieldTypeString, alias: DETAILS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: DETAILS )
• PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PRIORITY )
• PROBADDRESS ( type: esriFieldTypeString, alias: PROBADDRESS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROBADDRESS )
• PROBCITY ( type: esriFieldTypeString, alias: PROBCITY, editable: true, nullable: true, length: 35, defaultValue: null, modelName: PROBCITY )
• PROBZIP ( type: esriFieldTypeString, alias: PROBZIP, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PROBZIP )
• INITIATEDBY ( type: esriFieldTypeString, alias: INITIATEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INITIATEDBY )
• SUBMITTO ( type: esriFieldTypeString, alias: SUBMITTO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBMITTO )
• SUBMITTOPHONE ( type: esriFieldTypeString, alias: SUBMITTOPHONE, editable: true, nullable: true, length: 24, defaultValue: null, modelName: SUBMITTOPHONE )
• SUBMITTOEMAIL ( type: esriFieldTypeString, alias: SUBMITTOEMAIL, editable: true, nullable: true, length: 256, defaultValue: null, modelName: SUBMITTOEMAIL )
• CLOSEDBY ( type: esriFieldTypeString, alias: CLOSEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLOSEDBY )
• DATETIMEINIT ( type: esriFieldTypeDate, alias: DATETIMEINIT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMEINIT )
• DATETIMECLOSED ( type: esriFieldTypeDate, alias: DATETIMECLOSED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMECLOSED )
• SRX ( type: esriFieldTypeDouble, alias: SRX, editable: true, nullable: true, defaultValue: null, modelName: SRX )
• SRY ( type: esriFieldTypeDouble, alias: SRY, editable: true, nullable: true, defaultValue: null, modelName: SRY )
• DATESUBMITTO ( type: esriFieldTypeDate, alias: DATESUBMITTO, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESUBMITTO )
• DATESUBMITTOOPEN ( type: esriFieldTypeDate, alias: DATESUBMITTOOPEN, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESUBMITTOOPEN )
• DISPATCHTO ( type: esriFieldTypeString, alias: DISPATCHTO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DISPATCHTO )
• DATEDISPATCHTO ( type: esriFieldTypeDate, alias: DATEDISPATCHTO, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEDISPATCHTO )
• DISPATCHOPENBY ( type: esriFieldTypeString, alias: DISPATCHOPENBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DISPATCHOPENBY )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS )
• REQCATEGORY ( type: esriFieldTypeString, alias: REQCATEGORY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQCATEGORY )
• CANCEL ( type: esriFieldTypeString, alias: CANCEL, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CANCEL )
• CANCELLEDBY ( type: esriFieldTypeString, alias: CANCELLEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CANCELLEDBY )
• RESOLUTION ( type: esriFieldTypeString, alias: RESOLUTION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RESOLUTION )
• STREETNAME ( type: esriFieldTypeString, alias: STREETNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETNAME )
• EFFORT ( type: esriFieldTypeDouble, alias: EFFORT, editable: true, nullable: false, defaultValue: null, modelName: EFFORT )
• 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 )
• 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 )
• DISPATCHTOSID ( type: esriFieldTypeInteger, alias: DISPATCHTOSID, editable: true, nullable: true, defaultValue: null, modelName: DISPATCHTOSID )
• DISPATCHOPENBYSID ( type: esriFieldTypeInteger, alias: DISPATCHOPENBYSID, editable: true, nullable: true, defaultValue: null, modelName: DISPATCHOPENBYSID )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID, editable: false, nullable: false, defaultValue: null, modelName: ESRI_OID )
Templates:
• Name: Cityworks ServiceRequests
  Description:
  Prototype:
  DISPATCHTOSID: null
  REQUESTID: 0
  PROBLEMCODE:
  DESCRIPTION: null
  DETAILS: null
  PRIORITY: null
  PROBADDRESS: null
  PROBCITY: null
  PROBZIP: null
  INITIATEDBY: null
  SUBMITTO: null
  SUBMITTOPHONE: null
  SUBMITTOEMAIL: null
  CLOSEDBY: null
  DATETIMEINIT: null
  DATETIMECLOSED: null
  SRX: null
  SRY: null
  DATESUBMITTO: null
  DATESUBMITTOOPEN: null
  DISPATCHTO: null
  DATEDISPATCHTO: null
  DISPATCHOPENBY: null
  STATUS: null
  REQCATEGORY: null
  CANCEL: null
  CANCELLEDBY: null
  RESOLUTION: null
  STREETNAME: null
  EFFORT: 0
  INITIATEDBYSID: null
  SUBMITTOSID: null
  SUBMITTOOPENBYSID: null
  CANCELLEDBYSID: null
  CLOSEDBYSID: null
  DISPATCHOPENBYSID: null
  
  Drawing Tool: esriFeatureEditToolPoint