ArcGIS REST Services Directory
Login
Home
>
services
>
CITYWORKS
>
CityworksActivies (FeatureServer)
>
All Layers and Tables
Help
|
API Reference
JSON
All Layers and Tables (CITYWORKS/CityworksActivies)
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