Advertisement
Guest User

Untitled

a guest
Apr 24th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. CREATE TABLE sf_crime_incidents (
  2. incident_number integer,
  3. category varchar,
  4. description varchar,
  5. day_of_week varchar,
  6. date date,
  7. time time,
  8. police_department_district varchar,
  9. resolution varchar,
  10. address varchar,
  11. latitude double precision,
  12. longitude double precision,
  13. location varchar
  14. );
  15.  
  16. COPY sf_crime_incidents
  17. FROM '/Users/tlrobinson/Downloads/SF_Crime_Heat_Map.csv'
  18. DELIMITER ','
  19. CSV HEADER;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement