Name: CSR Customer Counts

Display Field: Customer

Type: Table

Geometry Type: N/A

Description: Customer counts recorded by the Customer Service Representative team. Used to track requests by volume, type (phone vs in person), timing (AM, Lunch, PM), and customer group. Data aggregated and updated monthly by CSR team.

Service Item Id: f3ea6896c2e04787bf8c391ea1f60dc0

Copyright Text: Town of Cochrane Geomatics Services

Default Visibility: false

MaxRecordCount: 20000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Customer ( type: esriFieldTypeString, alias: Customer, length: 150 )
• Phone_AM ( type: esriFieldTypeSmallInteger, alias: Phone_AM )
• Walkin_AM ( type: esriFieldTypeSmallInteger, alias: Walkin_AM )
• Phone_Lunch ( type: esriFieldTypeSmallInteger, alias: Phone_Lunch )
• Walkin_Lunch ( type: esriFieldTypeSmallInteger, alias: Walkin_Lunch )
• Phone_PM ( type: esriFieldTypeSmallInteger, alias: Phone_PM )
• Walkin_PM ( type: esriFieldTypeSmallInteger, alias: Walkin_PM )
• Total_by_Customer ( type: esriFieldTypeSmallInteger, alias: Total_by_Customer )
• Month ( type: esriFieldTypeString, alias: Month, length: 20 )
• Year ( type: esriFieldTypeInteger, alias: Year )
• Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata