Name: Case Offenses Table
Display Field: CommonName
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- CaseNumber (type: esriFieldTypeString, alias: CaseNumber, SQL Type: sqlTypeOther, length: 13, nullable: false, editable: true)
- ReportedDate (type: esriFieldTypeDate, alias: ReportedDate, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
- Day_of_Week (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- CrimeCode (type: esriFieldTypeString, alias: CrimeCode, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- CrimeCodeDesc (type: esriFieldTypeString, alias: CrimeCodeDesc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Counts (type: esriFieldTypeInteger, alias: Counts, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CaseAddress (type: esriFieldTypeString, alias: CaseAddress, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Statute (type: esriFieldTypeString, alias: Statute, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- StatuteDesc (type: esriFieldTypeString, alias: StatuteDesc, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
- AttemptCode (type: esriFieldTypeString, alias: AttemptCode, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Templates:
Name: Case Offenses Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- CaseNumber:
- ReportedDate: -2209161600000
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/12/2026 1:29:25 PM
Schema Last Edit Date: 8/12/2026 1:29:25 PM
Data Last Edit Date: 8/12/2026 1:29:25 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat