Public view of calls for service dispatched to Mesa Police Patrol Officers through Computer Aided Dispatch (CAD) system beginning 1/1/2021-present day. See also <b><a href="https://data.mesaaz.gov/Police/Police-Computer-Aided-Dispatch-CAD-Events-2017-202/ex94-c5ad">Police CAD Events 2017-2020</b></a>. The Location and Geolocation values are approximated and do not represent actual call locations. Dispatched call Location is modified by rounding street number to the 100 block. Geolocation is a modified point on a street segment centerline based on the rounded 100 block street number. This public version redacts Location and Geolocation where the Initial Call Type or Final Call Type is considered sensitive: Sexual Assault, Homicide, Molesting, Dead Body, Suicide, Completed Suicide, Behavioral Health, Behavioral Health Transfer/Transport. Note that these are dispatched calls for service and may not necessarily correspond to the data located in <b><a href="https://data.mesaaz.gov/Police/Police-Incidents/39rt-2rfj">Police Incidents</b></a> dataset. Crimes reported in this data set have not been adjudicated in a court of law for final determination.
This dataset has the following 26 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Event Number | event_number | text | Unique identifier, automatically assigned to the call by CAD system. | ME2024173639 ME2024173340 ME2024157368 ME202466071 ME2023270506 view top 100 |
Received Date Time | received_date_time | calendar_date | The data and time the call was received | 2023-11-12T13:59:38.000 2021-09-17T22:40:13.000 2021-05-06T11:27:45.000 2023-05-17T06:18:57.000 2022-11-23T12:15:58.000 view top 100 |
Dispatch Date Time | dispatch_date_time | calendar_date | The date and time the call was dispatched | 2022-01-02T18:53:08.000 2022-04-06T17:00:26.000 2022-12-02T14:53:02.000 2021-01-03T01:49:18.000 2024-01-19T18:14:56.000 view top 100 |
Call Handling Time Seconds | call_handling_time_seconds | number | The difference between the received time and the dispatch time (Dispatch – Received) | 0 1 65 60 71 view top 100 |
At Scene Date Time | at_scene_date_time | calendar_date | The date and time a resource arrived to location | 2024-07-26T02:06:50.000 2024-02-13T09:36:19.000 2022-08-08T23:18:56.000 2023-01-18T15:23:26.000 2024-08-23T08:07:47.000 view top 100 |
Response Time Seconds | response_time_seconds | number | The difference between dispatch and at Scene (at scene dt – dispatch dt) | 0 4 3 5 6 view top 100 |
Clear Date Time | clear_date_time | calendar_date | This is the date and time that the call was cleared via CAD | 2022-01-17T14:05:17.000 2022-08-31T16:29:45.000 2021-09-14T13:56:53.000 2024-01-19T12:50:41.000 2023-07-03T20:22:59.000 view top 100 |
On Scene Time Seconds | on_scene_time_seconds | number | The difference between clear dt and at scene dt (clear dt – at scene dt) | 0 293 387 400 408 view top 100 |
Initial Priority | initial_priority | number | Priority of the call assigned by the 911 operator | 2 7 3 4 5 view top 100 |
Dispatch Priority | dispatch_priority | number | Priority the call was dispatched at (this can be upgraded or downgraded) | 2 7 3 5 4 view top 100 |
Arrive Priority | arrive_priority | number | The priority of the call when the resource arrives at scene (this can be upgraded or downgraded. | 2 7 3 5 4 view top 100 |
Final Priority | final_priority | number | The final call priority when the call is cleared via CAD, this can be upgraded or downgraded depending upon the situation | 2 7 3 5 4 view top 100 |
Initial Case Type | initial_case_type | text | This is the radio code assigned | TS 900 114 418 420 view top 100 |
Initial Case Type Description | initial_case_type_description | text | This is a description of the radio code | TRAFFIC STOP WELFARE CHECK CRIME PREVENTION SUBJECTS DISTURBING FAMILY FIGHT view top 100 |
Final Case Type | final_case_type | text | This is the final radio code assigned to the call (this may change depending upon the situation) | TS 900 418 238 114 view top 100 |
Final Case Type Description | final_case_type_description | text | Description of the final radio code | TRAFFIC STOP WELFARE CHECK SUBJECTS DISTURBING TRESPASSING CRIME PREVENTION view top 100 |
Call Source | call_source | text | Source of the call (Telephone, On-View, 911, Walk-in, ASAP) | Telephone On View 911 Walk In ASAP view top 100 |
Municipality | municipality | text | The city where the incident occurred | MESA MARI GILB QNCR TEMP view top 100 |
District | district | text | This field refers to the assigned patrol district | Central Fiesta Superstition Red Mountain view top 100 |
ESZ | esz | number | This refers to the Emergency Services Zone and where the Police Beat numbers are stored | 22 12 21 13 41 view top 100 |
Grid | grid | text | referring to a map grid that is laid out into ¼ mile square segments throughout the city | AA01 BD01 BP30 BC04 BC05 view top 100 |
Call Handling Time Minutes | call_handling_time_minutes | number | Minutes from call received to dispatch in decimal format (ex 4.50 minutes = 4 minutes and 30 seconds) | 0.01666666666666666667 1.0833333333333333 1.00000000000000000000 1.1833333333333333 1.2000000000000000 view top 100 |
Response Time Minutes | response_time_minutes | number | Minutes from call dispatch to first officer on scene in decimal format (ex 4.50 minutes = 4 minutes and 30 seconds) | 0.06666666666666666667 0.05000000000000000000 0.08333333333333333333 0.10000000000000000000 0.03333333333333333333 view top 100 |
On-Scene Time Minutes | on_scene_time_minutes | number | Minutes from first officer on scene to officer of record leaving in decimal format (ex 4.50 minutes = 4 minutes and 30 seconds) | 4.8833333333333333 6.4500000000000000 6.6666666666666667 6.8000000000000000 6.4000000000000000 view top 100 |
Location | location | text | Address of the incident rounded to 100 block | 100 N ROBSON 6000 S SOSSAMAN RD 1400 S DOBSON RD 5700 E MAIN ST 1000 W GROVE AVE view top 100 |
Geolocation | geolocation | point | Point on the street centerline nearest to the rounded 100 block location | {"coordinates":[-111.83668,33.41728],"type":"Point"} {"coordinates":[-111.67012,33.30706],"type":"Point"} {"coordinates":[-111.85657,33.41499],"type":"Point"} {"coordinates":[-111.87465,33.38941],"type":"Point"} {"coordinates":[-111.70878,33.41566],"type":"Point"} view top 100 |