Skip to content

📦 CTT Pilot MongoDB

Cloud storage URL: https://storage.cloud.google.com/dingoo-datasets/ctt/pilot/ctt.csv
Date Range: March 24, 2025 – June 3, 2025
Total Records: 9,370
Max Deliveries in a Day: 360
Purpose:
This dataset captures delivery orders fulfilled during a 48-day pilot project with CTT in MongoDB (only business days, the pilot did not occur during weekends or bankholidays). Each row represents one delivery, possibly consisting of multiple boxes. The dataset includes delivery metadata, location information, routing decisions, and flags relevant for optimization (e.g., van-only deliveries, out-of-format parcels).

🧱 Column Descriptions

Column Name Type Description
_id object Unique MongoDB identifier.
orderId object ID assigned to the order by CTT.
isActive bool Whether the order is active in the system.
isPickupActive bool Unknown.
optimizerOrderId int64 Internal optimizer ID. Not relevant.
orderDate object Date when the order was placed.
business object Unknown.
contract object Unknown.
orderAddress object Raw address provided by the client.
formattedAddress object Address standardized using Google Address Validation.
slot object Delivery window as a dictionary, e.g., {"from": 28800000, "to": 46800000} (milliseconds since midnight).
totalWeight float64 Total weight of the delivery order.
totalVolume int64 Unknown.
itemsQuantity float64 Unknown.
user object Unknown.
userAddress object ID reference to the user's address.
phone float64 Unknown.
marketplaceCode float64 Unknown.
serviceType object Unknown.
archived bool Unknown.
orderErrors object Unknown.
lot object Unknown.
onlyBike bool True if the order must be delivered by bike.
onlyVan bool Unknown.
distanceToDepot float64 Distance (in meters) from depot to delivery address using OSRM routing.
attachments object Unknown.
_created object Unknown.
_modified object Unknown.
__v int64 MongoDB versioning field.
optimizerDelay float64 Unknown.
arrivalTime object Timestamp when the vehicle arrived at the delivery location.
deliveryInfo object Unknown.
notes object Unknown.
departureTime object Timestamp when the vehicle left the delivery location.
bagId object Internal Dingoo logic: ID of the bag used to group parcels.
boxes object Internal Dingoo logic: number or list of boxes in the order.
boxId object Internal Dingoo logic: identifier for each box.
parcelIndirectStop object Flag for points elected by parcelIndirect logic to be serviced by van (considered out-of-format).
oriXformat bool True if the delivery contains out-of-size boxes.
vanStop bool True if the point is pre-assigned as a van-only stop.

📝 Notes

  • Slot Format: Time in milliseconds since midnight. For example, {"from": 28800000, "to": 46800000} corresponds to 08:00–13:00.
  • userAddress vs orderAddress: While orderAddress is a text address, userAddress is just an ID reference (not a full address string).
  • parcelIndirectStop: It designates points that the parcelIndirect logic automatically classifies as van stops due to their characteristics.

❓ Unknown Fields

These fields are retained but not documented due to lack of information :

  • business
  • contract
  • totalVolume
  • itemsQuantity
  • user
  • phone
  • marketplaceCode
  • serviceType
  • archived
  • orderErrors
  • lot
  • onlyVan
  • attachments
  • _created
  • _modified
  • __v
  • optimizerDelay
  • deliveryInfo
  • notes