Ecodrive - what's it measuring?

Currently reading:
Ecodrive - what's it measuring?

Joined
Aug 1, 2007
Messages
2,636
Points
558
Location
Scotland
Well to answer that I've found the database file held on your PC and taken a look with the help of the SQLiteManager extension for Firefox.

Makes for very interesting reading. There's fields for measuring oil levels, brake wear and even measurements held in the trip computer.
Code:
CREATE TABLE [AccelerationBandData]

(

    [JourneyId] integer NOT NULL,

    LowerSpeed integer NOT NULL,

    UpperSpeed integer NOT NULL,

    Acceleration FLOAT NOT NULL,

    Deceleration FLOAT NOT NULL,

    PRIMARY KEY ([JourneyId],[LowerSpeed], [UpperSpeed])

    /* Foreign keys */

      FOREIGN KEY (JourneyId) REFERENCES Journey(Id)

);
CREATE TABLE DatabaseVersion (SequenceNumber INTEGER NOT NULL PRIMARY KEY, Description TEXT NOT NULL, Signature VARCHAR(64) NOT NULL, DateAdded FLOAT);
CREATE TABLE [DrivingCategoryScore] (
  JourneyId          integer NOT NULL,
  JourneyCategoryId  integer NOT NULL,
  Score              numeric(50) NOT NULL,
  /* Foreign keys */
  FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE [GearData] (
    [JourneyId] INTEGER  NOT NULL,
    [Gear] INTEGER  NOT NULL,
    [AverageAcceleration] FLOAT  NOT NULL,
    [AverageDownshiftRPM] FLOAT  NOT NULL,
    [AverageUpshiftRPM] FLOAT  NOT NULL,
    [PercentUsage] FLOAT  NOT NULL, AverageDeceleration FLOAT NULL,
    PRIMARY KEY ([JourneyId],[Gear])
    /* Foreign keys */
      FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE [Journey] (
[Id] integer  PRIMARY KEY NOT NULL,
[UserLocalId] varchar(36)  NOT NULL,
[VehicleLocalId] varchar(36)  NOT NULL,
[StartTime] float  NOT NULL,
[StartDate] float  NOT NULL,
[EndTime] float  NULL,
[StartOdometer] float  NULL,
[EndOdometer] float  NULL,
[EcoIndex] int  NULL,
[EcoIndexServerId] varchar(36)  NULL,
[EcoIndexServerAlgorithmVersion] varchar(36)  NULL,
[PricePerUnit] float  NULL,
[FuelConsumed] float  NULL,
[JourneyType] varchar(16)  NULL,
[ComputedServerFuelConsumption] FLOAT  NULL,
[ConsumptionUnit] VARCHAR(64)  NULL,
[TripDataCount] INTEGER  NOT NULL
, OilLevelStatus INTEGER NULL);
CREATE TABLE [KeyOffData] (

[JourneyId] INTEGER  NOT NULL,

[DistanceUnit] INTEGER  NULL,

[DistanceToService] INTEGER  NULL,

[DistanceToServiceValidData] INTEGER  NULL,

[FuelLevel] INTEGER  NULL,

[FuelLevelFailSts] INTEGER  NULL,

[CNGFillingTank] INTEGER  NULL,

[AutonomyDistance] INTEGER  NULL,

[AutonomyDistanceValidData] INTEGER  NULL,

[OilLevelIndication] INTEGER  NULL,

[OilLifeSts] INTEGER  NULL,

[EngineWaterLevel] INTEGER  NULL,

[BrakeFluidLevelSts] INTEGER  NULL,

[BrakePadWearSts] INTEGER  NULL,

[TyreInflationState] INTEGER  NULL,

[TyrePressureSystemFailSts] INTEGER  NULL,

[DPFStatus] INTEGER  NULL,

/* Foreign keys */

FOREIGN KEY (JourneyId) REFERENCES Journey(Id)

);
CREATE TABLE [TripAComputerData] (
[JourneyId] integer  NOT NULL,
[DateTime] float  NOT NULL,
[PartialOdometer] float  NULL,
[AverageSpeed] float  NULL,
[AverageFuelConsumption] float  NULL,
[EventType] INTEGER  NOT NULL,
[DistanceUnit] VARCHAR(10)  NOT NULL
);
CREATE TABLE TripData (
  JourneyId                     integer NOT NULL,
  "DateTime"                    float NOT NULL,
  EngineSpeed                   float NOT NULL,
  VehicleSpeed                  float NOT NULL,
  InstantaneousFuelConsumption  float NOT NULL,
  AverageFuelConsumption        float NOT NULL,
  /* Foreign keys */
  FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);
CREATE TABLE TripStatusData (
  JourneyId            integer NOT NULL,
  "DateTime"           float NOT NULL,
  ExternalTemperature  float,
  CompressorSts        smallint,
  /* Foreign keys */
  FOREIGN KEY (JourneyId) REFERENCES Journey(Id)
);

makes interesting reading for fellow geeks :eek:
 
That *Is* quite a lot of data it's logging , quite a bit of it not directly related to your driving.

How detailed are the stats? Could you see what speed you were doing at any given time for example?
 
That *Is* quite a lot of data it's logging , quite a bit of it not directly related to your driving.

How detailed are the stats? Could you see what speed you were doing at any given time for example?

That is a great question, and could your dealer / Fiat see this if they wanted to... ? Anyone NOT see where I'm going with this? :p
 
As I understand it , the B&M system can log 8 hours of driving data before it overwrites the oldest information.

I wonder if that's actually purged when you insert your USB stick or if it's just flagged and left on there.

If you assume that Fiat can see at least this much of your history then you won't go far wrong - just have a few days of sedate driving before a trip to the dealer.

Nof if only I could get my score above 68 I'd be happy :D
 
Has this "over-revving" only become an issue since the Eco-Drive launch?

Could Eco-Drive be a bit of a Trojan horse?

I love conspiracy theories! :D
 
How detailed are the stats? Could you see what speed you were doing at any given time for example?

Yes - and I'm not going to post here what my max speed has been as I don't need to incriminate myself :rolleyes: My highest revs have been 5376 rpm (and that's not normal for me) so at least I haven't been over revving it.

Timestamps appears to be the standard Unix format and speeds are in km/h.
 
Back
Top