search

NYCPlanning / db-safegraph

SafeGraph ETL
4 stars 1 forks source link

new quarantine zones #62

Closed SPTKL closed 4 years ago

SPTKL commented 4 years ago

DDL 

CREATE EXTERNAL TABLE IF NOT EXISTS safegraph.zones (
  `wkt` string,
  `name` string,
  `zonename` string,
  `zonecolor` string
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES (
  'serialization.format' = ',',
  'field.delim' = ',',
  'quoteChar' = '"'
) LOCATION 's3://recovery-data-partnership/spatial/'
TBLPROPERTIES (
  'has_encrypted_data'='false',
  "skip.header.line.count"="1"
)

zones.csv.zip Zones_10072020_0805AM_SHP.zip

SPTKL commented 4 years ago

data already loaded