Law Enforcement Dispatched Calls For Service: Closed by US Government | Demographics and Population Studies

About this Dataset

Law Enforcement Dispatched Calls For Service: Closed

_Revision Note (February 10, 2025): The data pipeline for "Law Enforcement Dispatched Calls for Service: Closed" has been updated. The largest updates are:

Consistent geo-masked intersections have been applied to all historical data
We have resolved a bug that was incorrectly mapping calls with no recorded location See our Release Notes here for all changes. Email support@datasf.org with any questions or concerns._ A. SUMMARY Law Enforcement Dispatched Calls for Service: Closed includes all calls for service that generate a record in the Department of Emergency Management's Computer Aided Dispatch (CAD) System and result in a law enforcement unit being dispatched to a location. Calls originate either from the public (via calls to the 911 call center) or from law enforcement officers in the field upon viewing an incident (‘On-View’). The Closed Calls dataset only includes calls for service that have been closed, and is updated every 24 hours. Not all calls for service generate a police incident report, so data does not directly correlate to the _Police Incident Reports_ dataset. The Closed Calls dataset contains all calls handled by law enforcement which can include Police, MTA parking enforcement, the Sheriff’s Office, and others. Some fields in the calls for service data are redacted due to the sensitive nature of the call and/or privacy concerns related to the incident. Please refer to the Dispatched Calls for Service Explainer for full documentation B. HOW THE DATASET IS CREATED Once a received 911 call is dispatched, a record (CAD#) is generated in the Department of Emergency Management's Computer Aided Dispatch (CAD) System. C. UPDATE PROCESS Updated daily at 5:00am with the previous day's data. D. HOW TO USE THIS DATASET Please refer to the Dispatched Calls for Service Explainer for full documentation. Note: To find data for calls originating from the 311 Connected Worker app dispatched from the Healthy Streets Operations Center (HSOC), search for the value “HSOC” in the onview_flag column. E. KEY RELATED DATASETS Datasets: Law Enforcement Dispatched Calls for Service: Real-time Police Department Incident Reports: 2018 to Present Fire Department Calls for Service Geographic Boundaries: Current Police Districts Analysis Neighborhoods Supervisor Districts
Organization: City of San Francisco
Last updated: 2022-03-08T00:29:28.611735

Tables

Table 1

@usgov.city_of_san_francisco_law_enforcement_dispatched_calls_6318d081.table_1

509.94 MB
7099063 rows
36 columns


CREATE TABLE table_1 (
  "cad_number" VARCHAR,
  "dup_cad_number" DOUBLE,
  "pd_incident_report" VARCHAR,
  "received_datetime" VARCHAR,
  "entry_datetime" VARCHAR,
  "dispatch_datetime" VARCHAR,
  "enroute_datetime" VARCHAR,
  "onscene_datetime" VARCHAR,
  "close_datetime" VARCHAR,
  "call_type_original" VARCHAR,
  "call_type_original_desc" VARCHAR,
  "call_type_original_notes" VARCHAR,
  "call_type_final" VARCHAR,
  "call_type_final_desc" VARCHAR,
  "call_type_final_notes" VARCHAR,
  "priority_original" VARCHAR,
  "priority_final" VARCHAR,
  "agency" VARCHAR,
  "disposition" VARCHAR,
  "onview_flag" VARCHAR,
  "sensitive_call" VARCHAR,
  "intersection_name" VARCHAR,
  "intersection_id" DOUBLE,
  "intersection_point" VARCHAR,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "police_district" VARCHAR,
  "data_as_of" VARCHAR,
  "data_updated_at" VARCHAR,
  "data_loaded_at" VARCHAR,
  "source_filename" VARCHAR,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE
);