Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement