SFPD Incidents From 2018-Present

CREATE TABLE law_enforcement_dispatched_calls_for_service_closed (
  "cad_number" BIGINT,
  "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" BOOLEAN,
  "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,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE
);

CREATE TABLE police_department_incident_reports_2018_to_present (
  "incident_datetime" VARCHAR,
  "incident_date" TIMESTAMP,
  "incident_time" VARCHAR,
  "incident_year" BIGINT,
  "incident_day_of_week" VARCHAR,
  "report_datetime" VARCHAR,
  "row_id" BIGINT,
  "incident_id" BIGINT,
  "incident_number" BIGINT,
  "cad_number" DOUBLE,
  "report_type_code" VARCHAR,
  "report_type_description" VARCHAR,
  "filed_online" VARCHAR,
  "incident_code" BIGINT,
  "incident_category" VARCHAR,
  "incident_subcategory" VARCHAR,
  "incident_description" VARCHAR,
  "resolution" VARCHAR,
  "intersection" VARCHAR,
  "cnn" DOUBLE,
  "police_district" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "supervisor_district_2012" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "point" VARCHAR,
  "neighborhoods" DOUBLE,
  "esncag_boundary_file" DOUBLE,
  "central_market_tenderloin_boundary_polygon_updated" DOUBLE,
  "civic_center_harm_reduction_project_boundary" DOUBLE,
  "hsoc_zones_as_of_2018_06_05" DOUBLE,
  "invest_in_neighborhoods_iin_areas" VARCHAR,
  "current_supervisor_districts" DOUBLE,
  "current_police_districts" DOUBLE
);