Layers:

Layer: rms_crime_incidents (0)


Name: rms_crime_incidents

Display Field: incident_entry_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

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.2877760356601
YMin: 42.255425053853
XMax: -82.910539787421
YMax: 42.4502561423866
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 Timestamp, 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 Last Updated, 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: Last Updated Date, 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: Incident 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: 2020 Census Block ID, 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: 1/6/2026 2:49:12 AM

Schema Last Edit Date: 1/6/2026 2:49:12 AM

Data Last Edit Date: 1/6/2026 2:49:12 AM