View In:   ArcGIS Online Map Viewer

Name: Service Requests

Display Field: PROBLEMCODE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: dbo._Mayor_Hotline_interactive_dashboard_Layer

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: -1.0710281152732003E7
YMin: -2559306.361881005
XMax: 3.887149850677966E7
YMax: 3.404736008750011E7
Spatial Reference: 102704  (26852)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [130, 31, 52, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeDouble, alias: OBJECTID, editable: true, nullable: false, defaultValue: null, modelName: OBJECTID )
• REQUESTID ( type: esriFieldTypeOID, alias: REQUESTID, editable: false, 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 )
• PROBADDRESS ( type: esriFieldTypeString, alias: PROBADDRESS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PROBADDRESS )
• 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 )
• 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 )
• DATETIMEINITFULL ( type: esriFieldTypeDate, alias: DATETIMEINITFULL, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMEINITFULL )
• DATETIMECLOSED ( type: esriFieldTypeDate, alias: DATETIMECLOSED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATETIMECLOSED )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: true, length: 60, defaultValue: null, modelName: WORKORDERID )
• 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 )
• 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 )
• ORGANIZATION ( type: esriFieldTypeString, alias: ORGANIZATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ORGANIZATION )
• Request_Init_byOrg ( type: esriFieldTypeString, alias: Request_Init_byOrg, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Request_Init_byOrg )
• Submit_To_byOrg ( type: esriFieldTypeString, alias: Submit_To_byOrg, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Submit_To_byOrg )
• InitiatedDept ( type: esriFieldTypeString, alias: InitiatedDept, editable: true, nullable: false, length: 33, defaultValue: null, modelName: InitiatedDept )
• SubmitToDept ( type: esriFieldTypeString, alias: SubmitToDept, editable: true, nullable: false, length: 17, defaultValue: null, modelName: SubmitToDept )

Templates:

• Name: Service Requests
  Description:
  Prototype:
  InitiatedDept:
  OBJECTID: 0
  SubmitToDept:
  PROBLEMCODE:
  DESCRIPTION: null
  DETAILS: null
  PROBADDRESS: null
  INITIATEDBY: null
  SUBMITTO: null
  CLOSEDBY: null
  DATETIMEINIT: null
  DATETIMEINITFULL: null
  DATETIMECLOSED: null
  WORKORDERID: null
  SRX: null
  SRY: null
  STATUS: null
  REQCATEGORY: null
  ORGANIZATION: null
  Request_Init_byOrg: null
  Submit_To_byOrg: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata