Baselight

Law Enforcement Dispatched Calls For Service: Real-Time

City of San Francisco

@usgov.city_of_san_francisco_law_enforcement_dispatched_calls_97cb6fe2

Loading...
Loading...

About this Dataset

Law Enforcement Dispatched Calls For Service: Real-Time

Revision Note (February 10, 2025) : The data pipeline for "Law Enforcement Dispatched Calls for Service: Real-Time" has been updated. A spelling error with the column "priority_original" has been corrected. Column data types and formatting have been updated to reflect DataSF standards. Law Enforcement Dispatched Calls for Service: Closed Calls has also been updated as part of a larger effort to upgrade our Calls for Service pipelines. Email support@datasf.org with any questions or concerns. A. SUMMARY Law Enforcement Dispatched Calls for Service: Real-Time 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’). This dataset represents a rolling 48 hour window of calls for service. It contains both open and closed calls. It is both updated every 10 minutes and delayed by an additional 10 minutes. Open calls are defined as active calls that are unverified, but being worked by law enforcement. Closed calls are calls that law enforcement have indicated are resolved. Not all calls for service generate a police incident report, so data does not directly correlate to the _Police Incident Reports_ dataset. The Real-time Calls dataset contains 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 Law Enforcement 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 every 10 minutes with the past 48hrs of open and closed calls that have been dispatched. D. HOW TO USE THIS DATASET Please refer Law Enforcement 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: Closed Calls 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: 2021-12-03T10:33:21.357250

Tables

Table 1

@usgov.city_of_san_francisco_law_enforcement_dispatched_calls_97cb6fe2.table_1
  • 375.02 KB
  • 3540 rows
  • 30 columns
Loading...

CREATE TABLE table_1 (
  "id" BIGINT,
  "cad_number" BIGINT,
  "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" BOOLEAN,
  "intersection_name" VARCHAR,
  "intersection_id" DOUBLE,
  "intersection_point" VARCHAR,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "police_district" VARCHAR,
  "call_last_updated_at" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhoods" DOUBLE
);

Share link

Anyone who has the link will be able to view this.