Taxi Data Mapping w/ ES-compatible data types

mappings.txt

trip_id                 integer
vendor_id               string
pickup_datetime         TIMESTAMP
dropoff_datetime        TIMESTAMP
store_and_fwd_flag      string
rate_code_id            integer
pickup_longitude        float
pickup_latitude         float
dropoff_longitude       float
dropoff_latitude        float
passenger_count         integer
trip_distance           float
fare_amount             float
extra                   float
mta_tax                 float
tip_amount              float
tolls_amount            float
ehail_fee               float
improvement_surcharge   float
total_amount            float
payment_type            string
trip_type               integer
pickup                  string
dropoff                 string
cab_type                string
precipitation           integer
snow_depth              integer
snowfall                integer
max_temperature         integer
min_temperature         integer
average_wind_speed      integer
pickup_nyct2010_gid     integer
pickup_ctlabel          string
pickup_borocode         integer
pickup_boroname         string
pickup_ct2010           string
pickup_boroct2010       string
pickup_cdeligibil       string
pickup_ntacode          string
pickup_ntaname          string
pickup_puma             string
dropoff_nyct2010_gid    integer
dropoff_ctlabel         string
dropoff_borocode        integer
dropoff_boroname        string
dropoff_ct2010          string
dropoff_boroct2010      string
dropoff_cdeligibil      string
dropoff_ntacode         string
dropoff_ntaname         string
dropoff_puma            string