Tables:

Table: Library Circulation Data Dashboard (1)

Name: Library Circulation Data Dashboard

Display Field: DataLocation

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4aa5ae53ec104154827d6e93a9734c6f

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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: false
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:

Fields:
• DataID ( type: esriFieldTypeOID, alias: DataID, editable: false, nullable: false, defaultValue: null, modelName: DataID )
• DashboardDate ( type: esriFieldTypeDate, alias: DashboardDate, editable: false, nullable: false, length: 8, defaultValue: null, modelName: DashboardDate )
• DashboardMonth ( type: esriFieldTypeInteger, alias: DashboardMonth, editable: false, nullable: false, defaultValue: null, modelName: DashboardMonth )
• DataLocation ( type: esriFieldTypeString, alias: DataLocation, editable: false, nullable: true, length: 255, defaultValue: null, modelName: DataLocation )
• DataDate ( type: esriFieldTypeString, alias: DataDate, editable: false, nullable: true, length: 50, defaultValue: null, modelName: DataDate )
• DataMonth ( type: esriFieldTypeString, alias: DataMonth, editable: false, nullable: true, length: 50, defaultValue: null, modelName: DataMonth )
• DataYear ( type: esriFieldTypeInteger, alias: DataYear, editable: false, nullable: false, defaultValue: null, modelName: DataYear )
• FiscalYear ( type: esriFieldTypeString, alias: FiscalYear, editable: false, nullable: true, length: 50, defaultValue: null, modelName: FiscalYear )
• MainDaysOpen ( type: esriFieldTypeInteger, alias: MainDaysOpen, editable: false, nullable: false, defaultValue: null, modelName: MainDaysOpen )
• OtherDaysOpen ( type: esriFieldTypeInteger, alias: OtherDaysOpen, editable: false, nullable: false, defaultValue: null, modelName: OtherDaysOpen )
• AvgDailyGateCount ( type: esriFieldTypeInteger, alias: AvgDailyGateCount, editable: false, nullable: false, defaultValue: null, modelName: AvgDailyGateCount )
• TotalGateCount ( type: esriFieldTypeInteger, alias: TotalGateCount, editable: false, nullable: false, defaultValue: null, modelName: TotalGateCount )
• VolunteerHours ( type: esriFieldTypeInteger, alias: VolunteerHours, editable: false, nullable: false, defaultValue: null, modelName: VolunteerHours )
• InternetUserSessions ( type: esriFieldTypeInteger, alias: InternetUserSessions, editable: false, nullable: false, defaultValue: null, modelName: InternetUserSessions )
• ReferenceQuestions ( type: esriFieldTypeInteger, alias: ReferenceQuestions, editable: false, nullable: false, defaultValue: null, modelName: ReferenceQuestions )
• NumberOfOtherQuestions ( type: esriFieldTypeInteger, alias: NumberOfOtherQuestions, editable: false, nullable: false, defaultValue: null, modelName: NumberOfOtherQuestions )
• NumberOfPrograms ( type: esriFieldTypeInteger, alias: NumberOfPrograms, editable: false, nullable: false, defaultValue: null, modelName: NumberOfPrograms )
• ProgramAttend ( type: esriFieldTypeInteger, alias: ProgramAttend, editable: false, nullable: false, defaultValue: null, modelName: ProgramAttend )
• DAMVisits ( type: esriFieldTypeInteger, alias: DAMVisits, editable: false, nullable: false, defaultValue: null, modelName: DAMVisits )
• NumberOfStoryTimes ( type: esriFieldTypeInteger, alias: NumberOfStoryTimes, editable: false, nullable: false, defaultValue: null, modelName: NumberOfStoryTimes )
• NumberOfOutreach ( type: esriFieldTypeInteger, alias: NumberOfOutreach, editable: false, nullable: false, defaultValue: null, modelName: NumberOfOutreach )
• OutreachAttend ( type: esriFieldTypeInteger, alias: OutreachAttend, editable: false, nullable: false, defaultValue: null, modelName: OutreachAttend )
• NumberOfCEEventsBookshelfVisits ( type: esriFieldTypeInteger, alias: NumberOfCEEventsBookshelfVisits, editable: false, nullable: false, defaultValue: null, modelName: NumberOfCEEventsBookshelfVisits )
• NumberOfCEContactsAndBooksStocked ( type: esriFieldTypeInteger, alias: NumberOfCEContactsAndBooksStocked, editable: false, nullable: false, defaultValue: null, modelName: NumberOfCEContactsAndBooksStocked )
• BCLWebsiteVisits ( type: esriFieldTypeInteger, alias: BCLWebsiteVisits, editable: false, nullable: false, defaultValue: null, modelName: BCLWebsiteVisits )
• RepeatedMonth ( type: esriFieldTypeInteger, alias: RepeatedMonth, editable: false, nullable: false, defaultValue: null, modelName: RepeatedMonth )
• CardRegistrations ( type: esriFieldTypeInteger, alias: CardRegistrations, editable: false, nullable: false, defaultValue: null, modelName: CardRegistrations )
• BookmobileCardRegistrations ( type: esriFieldTypeInteger, alias: BookmobileCardRegistrations, editable: false, nullable: false, defaultValue: null, modelName: BookmobileCardRegistrations )
• LoansToOtherLibraries ( type: esriFieldTypeInteger, alias: LoansToOtherLibraries, editable: false, nullable: false, defaultValue: null, modelName: LoansToOtherLibraries )
• BorrowedFromOtherLibraries ( type: esriFieldTypeInteger, alias: BorrowedFromOtherLibraries, editable: false, nullable: false, defaultValue: null, modelName: BorrowedFromOtherLibraries )
• ItemsAddedToCollection ( type: esriFieldTypeInteger, alias: ItemsAddedToCollection, editable: false, nullable: false, defaultValue: null, modelName: ItemsAddedToCollection )
• ItemsWithdrawnFromCollection ( type: esriFieldTypeInteger, alias: ItemsWithdrawnFromCollection, editable: false, nullable: false, defaultValue: null, modelName: ItemsWithdrawnFromCollection )
• HoldingsAtEndOfMonth ( type: esriFieldTypeInteger, alias: HoldingsAtEndOfMonth, editable: false, nullable: false, defaultValue: null, modelName: HoldingsAtEndOfMonth )
• NumberOfBCLItemsHeld ( type: esriFieldTypeInteger, alias: NumberOfBCLItemsHeld, editable: false, nullable: false, defaultValue: null, modelName: NumberOfBCLItemsHeld )
• HoldsPickedUpAtBCL ( type: esriFieldTypeInteger, alias: HoldsPickedUpAtBCL, editable: false, nullable: false, defaultValue: null, modelName: HoldsPickedUpAtBCL )
• CheckIns ( type: esriFieldTypeInteger, alias: CheckIns, editable: false, nullable: false, defaultValue: null, modelName: CheckIns )
• AdultCircOfPhysicalItems ( type: esriFieldTypeInteger, alias: AdultCircOfPhysicalItems, editable: false, nullable: false, defaultValue: null, modelName: AdultCircOfPhysicalItems )
• YACircOfPhysicalItems ( type: esriFieldTypeInteger, alias: YACircOfPhysicalItems, editable: false, nullable: false, defaultValue: null, modelName: YACircOfPhysicalItems )
• JuvCircOfPhysicalItems ( type: esriFieldTypeInteger, alias: JuvCircOfPhysicalItems, editable: false, nullable: false, defaultValue: null, modelName: JuvCircOfPhysicalItems )
• TotalCircPhysical ( type: esriFieldTypeInteger, alias: TotalCircPhysical, editable: false, nullable: false, defaultValue: null, modelName: TotalCircPhysical )
• AdultCircOfDigitalItems ( type: esriFieldTypeInteger, alias: AdultCircOfDigitalItems, editable: false, nullable: false, defaultValue: null, modelName: AdultCircOfDigitalItems )
• YACircOfDigitalItems ( type: esriFieldTypeInteger, alias: YACircOfDigitalItems, editable: false, nullable: false, defaultValue: null, modelName: YACircOfDigitalItems )
• JuvCircOfDigitalItems ( type: esriFieldTypeInteger, alias: JuvCircOfDigitalItems, editable: false, nullable: false, defaultValue: null, modelName: JuvCircOfDigitalItems )
• TotalCircEContentItems ( type: esriFieldTypeInteger, alias: TotalCircEContentItems, editable: false, nullable: false, defaultValue: null, modelName: TotalCircEContentItems )
• GrandTotalCirculation ( type: esriFieldTypeInteger, alias: GrandTotalCirculation, editable: false, nullable: false, defaultValue: null, modelName: GrandTotalCirculation )
• RepeatedMonth2 ( type: esriFieldTypeString, alias: RepeatedMonth2, editable: false, nullable: true, length: 50, defaultValue: null, modelName: RepeatedMonth2 )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: false, nullable: true, length: 2147483647, defaultValue: null, modelName: Notes )
Templates:
• Name: Library Circulation Data Dashboard
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone