Intermediate Point Data (Taxi Trip Duration)
First 2000 rows with intermediate point data using Google Maps API
@kaggle.artimous_intermediate_point_data_taxi_trip_duration
Metadata
@kaggle.artimous_intermediate_point_data_taxi_trip_duration.metadata
- 488.92 KB
- 2001 rows
- 9 columns
trip_idTrip Id | distanceDistance | pickup_latitudePickup Latitude | pickup_longitudePickup Longitude | dropoff_latitudeDropoff Latitude | dropoff_longitudeDropoff Longitude | start_addressStart Address | end_addressEnd Address | parametersParameters |
|---|---|---|---|---|---|---|---|---|
| id2875421 | 1.3 mi | 40.7679367065 | -73.9821548462 | 40.7656021118 | -73.964630127 | 4 Columbus Cir, New York, NY 10019, USA | 151-157 E 65th St, New York, NY 10065, USA | Step1:{distance=203 ft start_location=(40.7678855,-73.9823295) end_location=(40.7677123,-73.9817016) }, Step2:{distance=243 ft start_location=(40.7677123,-73.9817016) end_location=(40.7682791,-73.9814387) }, Step3:{distance=0.3 mi start_location=(40.7682791,-73.9814387) end_location=(40.7717916,-73.… |
| id2377394 | 1.6 mi | 40.7385635376 | -73.9804153442 | 40.7311515808 | -73.9994812012 | 418 2nd Ave, New York, NY 10010, USA | 37 Macdougal St, New York, NY 10011, USA | Step1:{distance=0.5 mi start_location=(40.7385641,-73.9804459) end_location=(40.732349,-73.9849373) }, Step2:{distance=0.5 mi start_location=(40.732349,-73.9849373) end_location=(40.7360158,-73.9936331) }, Step3:{distance=0.4 mi start_location=(40.7360158,-73.9936331) end_location=(40.7314123,-73.99… |
| id3858529 | 6.2 mi | 40.7639389038 | -73.9790267944 | 40.7100868225 | -74.0053329468 | 119-125 W 56th St, New York, NY 10019, USA | 49 Beekman St, New York, NY 10038, USA | Step1:{distance=374 ft start_location=(40.7641482,-73.9788741) end_location=(40.7636527,-73.9776904) }, Step2:{distance=282 ft start_location=(40.7636527,-73.9776904) end_location=(40.7643285,-73.9771987) }, Step3:{distance=0.7 mi start_location=(40.7643285,-73.9771987) end_location=(40.759306,-73.9… |
| id3504673 | 1.2 mi | 40.7199707031 | -74.0100402832 | 40.7067184448 | -74.0122680664 | 377-383 Greenwich St, New York, NY 10013, USA | 61 Canyon of Heroes, New York, NY 10006, USA | Step1:{distance=0.2 mi start_location=(40.7199813,-74.0101485) end_location=(40.7174655,-74.0106373) }, Step2:{distance=174 ft start_location=(40.7174655,-74.0106373) end_location=(40.717383,-74.0100187) }, Step3:{distance=0.3 mi start_location=(40.717383,-74.0100187) end_location=(40.7152403,-74.00… |
| id2181028 | 1.0 mi | 40.7932090759 | -73.9730529785 | 40.7825202942 | -73.9729232788 | 2519 Broadway, New York, NY 10025, USA | 22-54 W 81st St, New York, NY 10024, USA | Step1:{distance=436 ft start_location=(40.7931863,-73.9729985) end_location=(40.7921427,-73.9737738) }, Step2:{distance=0.3 mi start_location=(40.7921427,-73.9737738) end_location=(40.7903045,-73.9693897) }, Step3:{distance=0.6 mi start_location=(40.7903045,-73.9693897) end_location=(40.7832629,-73.… |
| id0801584 | 0.9 mi | 40.7421951294 | -73.9828567505 | 40.7491836548 | -73.9920806885 | 100-102 Lexington Ave, New York, NY 10016, USA | 201-229 W 31st St, New York, NY 10001, USA | Step1:{distance=66 ft start_location=(40.7421741,-73.9828072) end_location=(40.7420182,-73.9829222) }, Step2:{distance=0.5 mi start_location=(40.7420182,-73.9829222) end_location=(40.745418,-73.9909623) }, Step3:{distance=0.2 mi start_location=(40.745418,-73.9909623) end_location=(40.747893,-73.9891… |
| id1813257 | 1.1 mi | 40.7578392029 | -73.9690170288 | 40.7658958435 | -73.9574050903 | 886 3rd Ave, New York, NY 10022, USA | 1281 1st Avenue, New York, NY 10065, USA | Step1:{distance=174 ft start_location=(40.7579251,-73.9692334) end_location=(40.7583499,-73.9689463) }, Step2:{distance=0.3 mi start_location=(40.7583499,-73.9689463) end_location=(40.7563957,-73.9643439) }, Step3:{distance=0.7 mi start_location=(40.7563957,-73.9643439) end_location=(40.765874,-73.9… |
| id1324603 | 7.2 mi | 40.7977790833 | -73.9692764282 | 40.760559082 | -73.9224700928 | 215 W 101st St, New York, NY 10025, USA | 34-14-34-16 Broadway, Astoria, NY 11106, USA | Step1:{distance=26 ft start_location=(40.7977671,-73.9692851) end_location=(40.7978037,-73.9693734) }, Step2:{distance=312 ft start_location=(40.7978037,-73.9693734) end_location=(40.7972537,-73.9700112) }, Step3:{distance=0.3 mi start_location=(40.7972537,-73.9700112) end_location=(40.7954774,-73.9… |
| id1301050 | 0.8 mi | 40.7383995056 | -73.9994812012 | 40.7328147888 | -73.985786438 | 158 W 14th St, New York, NY 10011, USA | 231-233 E 14th St, New York, NY 10003, USA | Step1:{distance=0.8 mi start_location=(40.7384589,-73.9994377) end_location=(40.7327255,-73.9858505) }, |
| id0012891 | 4.2 mi | 40.7443389893 | -73.981048584 | 40.7899894714 | -73.9729995728 | 135 E 31st St, New York, NY 10016, USA | 148-198 W 90th St, New York, NY 10024, USA | Step1:{distance=0.1 mi start_location=(40.7444369,-73.9809775) end_location=(40.7451504,-73.9826835) }, Step2:{distance=0.1 mi start_location=(40.7451504,-73.9826835) end_location=(40.7463913,-73.9817686) }, Step3:{distance=0.3 mi start_location=(40.7463913,-73.9817686) end_location=(40.7507123,-73.… |
CREATE TABLE metadata (
"trip_id" VARCHAR,
"distance" VARCHAR,
"pickup_latitude" DOUBLE,
"pickup_longitude" DOUBLE,
"dropoff_latitude" DOUBLE,
"dropoff_longitude" DOUBLE,
"start_address" VARCHAR,
"end_address" VARCHAR,
"parameters" VARCHAR
);