Name: crime_data_2023

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• incident_number (type: esriFieldTypeString, alias: incident_number, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• date_reported (type: esriFieldTypeDate, alias: date_reported, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• date_occurred (type: esriFieldTypeDate, alias: date_occurred, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• badge_id (type: esriFieldTypeString, alias: badge_id, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• offense_classification (type: esriFieldTypeString, alias: offense_classification, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• offense_code_name (type: esriFieldTypeString, alias: offense_code_name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• nibrs_code (type: esriFieldTypeString, alias: nibrs_code, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• nibrs_group_name (type: esriFieldTypeString, alias: nibrs_group_name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• was_offense_completed (type: esriFieldTypeString, alias: was_offense_completed, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• lmpd_division (type: esriFieldTypeString, alias: lmpd_division, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• lmpd_beat (type: esriFieldTypeString, alias: lmpd_beat, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• location_category (type: esriFieldTypeString, alias: location_category, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• block_address (type: esriFieldTypeString, alias: block_address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• zip_code (type: esriFieldTypeString, alias: zip_code, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/17/2025 3:16:07 PM

Schema Last Edit Date: 8/17/2025 3:16:07 PM

Data Last Edit Date: 8/17/2025 3:15:45 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat