All Collections
Pledge platform
Importing your data
Last mile delivery & short trips file specification
Last mile delivery & short trips file specification

File specification for last mile delivery and short trips data

Updated over a week ago

Overview

This article covers the CSV/XLSX file format used by Pledge to import data pertaining to last mile delivery and short trips by road where there is no data about the number of passengers or weight of delivery involved.

General CSV/XLSX file specification

Before diving into the specific last mile & short trips fields, you are encouraged to first to familiarize 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 last mile deliveries and short trips:

  • Distance

  • Vehicle type

  • Fuel type

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 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

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?