Name: rms_crime_incidents

Display Field: incident_entry_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description: production.dbt_mart_public_safety.rms_crime_incidents

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -83.3111558627013
YMin: 42.2259814590876
XMax: -82.8806085831591
YMax: 42.4703207591257
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[56,140,100,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ESRI_OID

Unique ID Field:

Name : ESRI_OID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• incident_entry_id (type: esriFieldTypeString, alias: incident_entry_id, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• nearest_intersection (type: esriFieldTypeString, alias: nearest_intersection, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• offense_category (type: esriFieldTypeString, alias: offense_category, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• offense_description (type: esriFieldTypeString, alias: offense_description, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• state_offense_code (type: esriFieldTypeString, alias: state_offense_code, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• arrest_charge (type: esriFieldTypeString, alias: arrest_charge, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• charge_description (type: esriFieldTypeString, alias: charge_description, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• incident_occurred_at (type: esriFieldTypeDate, alias: incident_occurred_at, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• incident_time (type: esriFieldTypeString, alias: incident_time, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• incident_day_of_week (type: esriFieldTypeDouble, alias: incident_day_of_week, SQL Type: sqlTypeOther, nullable: true, editable: true)
• incident_hour_of_day (type: esriFieldTypeDouble, alias: incident_hour_of_day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• incident_year (type: esriFieldTypeDouble, alias: incident_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• case_id (type: esriFieldTypeString, alias: case_id, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• case_status (type: esriFieldTypeString, alias: case_status, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• case_status_updated_at (type: esriFieldTypeDate, alias: case_status_updated_at, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updated_in_ibr_at (type: esriFieldTypeDate, alias: updated_in_ibr_at, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updated_at (type: esriFieldTypeDate, alias: updated_at, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• crime_id (type: esriFieldTypeString, alias: crime_id, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• report_number (type: esriFieldTypeString, alias: report_number, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• scout_car_area (type: esriFieldTypeString, alias: scout_car_area, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• police_precinct (type: esriFieldTypeString, alias: police_precinct, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• census_block_2020_geoid (type: esriFieldTypeString, alias: census_block_2020_geoid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• neighborhood (type: esriFieldTypeString, alias: neighborhood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• council_district (type: esriFieldTypeInteger, alias: council_district, SQL Type: sqlTypeOther, nullable: true, editable: true)
• zip_code (type: esriFieldTypeString, alias: zip_code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESRI_OID (type: esriFieldTypeOID, alias: ESRI_OID, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: rms_crime_incidents
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/2/2025 1:53:05 AM

Schema Last Edit Date: 6/2/2025 1:53:05 AM

Data Last Edit Date: 6/2/2025 1:53:05 AM

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