2017 FordGoBike/Baywheels data in OmniSci

2017_baywheels_omnisci.sql

--define table for 2017 schema
CREATE TABLE baywheels_tripdata(
duration_sec INTEGER,
start_time TIMESTAMP,
end_time TIMESTAMP,
start_station_id SMALLINT,
start_station_name TEXT ENCODING DICT,
start_station_latitude FLOAT,
start_station_longitude FLOAT,
end_station_id SMALLINT,
end_station_name TEXT ENCODING DICT,
end_station_latitude FLOAT,
end_station_longitude FLOAT,
bike_id SMALLINT,
user_type TEXT ENCODING DICT,
member_birth_year SMALLINT,
member_gender TEXT ENCODING DICT
);

--load data for 2017
copy baywheels_tripdata from 's3://baywheels-data/2017-fordgobike-tripdata.csv';