Ride-hailing file specification

File specification for ride-hailing data

Updated over a week ago

Overview

This article covers the file format used by Pledge to import data pertaining to ride-hailing journeys, ideally where there is data about the number of passengers taking the journey.

General CSV/XLSX file specification

Before diving into the specific ride-hailing fields, you are encouraged to first to familiarise yourself with Pledge's general CSV/XLSX file specification for importing data.

Understanding how to map your data

There are relatively few data points that are needed to compute emissions estimates for ride-hailing journeys:

  • Distance

  • Vehicle type

  • Fuel type

  • Ideally, number of passengers

However, if more precise data is provided then better emissions estimates can be computed. For example, for VEHICLE, instead of specifying just C (for CAR - AVERAGE), if the size of the car is provided e.g. C6 (for CAR - LUXURY) then a more accurate estimate will be computed. Better still, if MAKE and MODEL are provided then that will produce even better results.

DISTANCE

It's always best to provide distance if you have it, especially if it is a reflection of the actual distance for a journey that has already happened. If the distance is provided it will always be used for the emissions computations. However, if no distance is provided then you will have to either provide origin and destination addresses or co-ordinates and Pledge will attempt to estimate the appropriate planned distance.

For display purposes it is ideal to provide address or co-ordinates in addition to distance if that is available.

Template and sample files

Fields

Column

Data Type

Mandatory

DATE

ISO 8601 e.g. 2021-09-15T12:31

Yes

FROM_ADDRESS

TEXT e.g. 66 Faubourg Saint Honoré, Paris

Yes (either this or FROM_COORDINATES or DISTANCE)

FROM_COORDINATES

DECIMAL,DECIMAL e.g. 48.8700388,2.3185802

Yes (either this or FROM_ADDRESS or DISTANCE)

TO_ADDRESS

TEXT e.g. 4 rue Sophie Germain, Paris, France

Yes (either this or TO_COORDINATES or DISTANCE)

TO_COORDINATES

DECIMAL,DECIMAL e.g. 48.8307843, 2.3312721

Yes (either this or TO_ADDRESS or DISTANCE)

DISTANCE

DECIMAL e.g. 12.54

Yes (either this or FROM_X and TO_X)

DISTANCE_UNIT

TEXT eg. KM

One of :

  • KM - KILOMETER

  • MI - MILE

No

Notes: If not specified will default to KM

NO_OF_PAX

INTEGER eg. 2

No

Notes: strongly recommended, only considered when vehicle is Car or Van

VEHICLE

TEXT eg. C4

One of:

  • B - BICYCLE

  • C - CAR - AVERAGE

  • M - MOTORBIKE - AVERAGE

  • V - VAN - AVERAGE

  • C1 - CAR - MINI

  • C2 - CAR - SUPERMINI

  • C3 - CAR - LOWER MEDIUM

  • C4 - CAR - UPPER MEDIUM

  • C5 - CAR - EXECUTIVE

  • C6 - CAR - LUXURY

  • C7 - CAR - SPORTS

  • C8 - CAR - DUAL PURPOSE 4x4

  • C9 - CAR - MPV

  • M1 - MOTORBIKE - SMALL

  • M2 - MOTORBIKE - MEDIUM

  • M3 - MOTORBIKE - LARGE

  • V1 - VAN - CLASS I

  • V2 - VAN - CLASS II

  • V3 - VAN - CLASS III

Yes

FUEL_TYPE

TEXT eg. DIESEL

One of:

  • DIESEL

  • PETROL

  • HYBRID

  • CNG

  • LPG

  • PLUGIN_HYBRID

  • ELECTRICITY

  • OTHER

Yes

MAKE

TEXT e.g. Toyota

No

MODEL

TEXT e.g. Prius

No

Did this answer your question?