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 :
| No
Notes: If not specified will default to KM |
NO_OF_PAX | INTEGER eg. 2 | No |
VEHICLE | TEXT eg. C4
One of:
| Yes |
FUEL_TYPE | TEXT eg. DIESEL
One of:
| Yes |
MAKE | TEXT e.g. Toyota | No |
MODEL | TEXT e.g. Prius | No |