View In:   ArcGIS Online Map Viewer

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

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