Import SF crime data from https://data.sfgov.org/Public-Safety/SF-Crime-Heat-Map/q6gg-sa2p/data into PostgreSQL

sf-crime-incident-import.sql

CREATE TABLE sf_crime_incidents (
  incident_number integer,
  category varchar,
  description varchar,
  day_of_week varchar,
  date date,
  time time,
  police_department_district varchar,
  resolution varchar,
  address varchar,
  latitude double precision,
  longitude double precision,
  location varchar
);

COPY sf_crime_incidents
FROM '/Users/tlrobinson/Downloads/SF_Crime_Heat_Map.csv'
DELIMITER ','
CSV HEADER;